Error saying weakly balanced panel data for location, but correct balanced for timing

[Tariq Abdullah]

My data is acting weird . This is a sample of my data where I have the understanding the location and year both are correctly balanced. policy is a dummy variable.

however, when I ma running the following command this is what I get

tsset county year

Panel variable: county (weakly balanced)
 Time variable: year, 2000 to 2022
         Delta: 1 unit

From looking at the fraction of data snippet I'm not sure how to figure out where county observation is missing. Because from my initial look it seems I have 23 observations for each single county.

Is there any way to find out why my county is weakly balanced ? I have 52,210 observations in my data which is also completely divisible by 23 ( my number of years ) 52,210 / 23 = 2270. So, that also gives me the idea I have 23 years of data for each unique county. Unless I have 46 or more for a county which I have not figured out yet.

* Example generated by -dataex-. For more info, type help dataex
clear
input float(county year total_inc1 policy)
1001 2000 0 0
1001 2001 0 0
1001 2002 0 0
1001 2003 0 0
1001 2004 0 0
1001 2005 0 0
1001 2006 0 0
1001 2007 0 0
1001 2008 1 0
1001 2009 0 0
1001 2010 0 0
1001 2011 0 0
1001 2012 0 0
1001 2013 0 0
1001 2014 0 0
1001 2015 0 0
1001 2016 0 0
1001 2017 0 0
1001 2018 0 0
1001 2019 0 0
1001 2020 0 0
1001 2021 0 0
1001 2022 0 0
1003 2000 0 0
1003 2001 0 0
1003 2002 0 0
1003 2003 0 0
1003 2004 0 0
1003 2005 0 0
1003 2006 0 0
1003 2007 2 0
1003 2008 0 0
1003 2009 3 0
1003 2010 5 0
1003 2011 0 0
1003 2012 0 0
1003 2013 1 0
1003 2014 1 0
1003 2015 0 0
1003 2016 0 0
1003 2017 0 0
1003 2018 0 0
1003 2019 0 0
1003 2020 0 0
1003 2021 0 0
1003 2022 0 0
36001 2000  0 0
36001 2001  0 0
36001 2002  8 0
36001 2003  3 0
36001 2004  7 0
36001 2005  4 0
36001 2006 19 0
36001 2007 20 0
36001 2008 19 0
36001 2009 15 0
36001 2010 34 0
36001 2011 25 0
36001 2012 25 1
36001 2013 44 1
36001 2014 51 1
36001 2015 41 1
36001 2016 37 1
36001 2017 22 1
36001 2018 27 1
36001 2019 34 1
36001 2020 15 1
36001 2021  9 1
36001 2022 15 1
end

[Tariq Abdullah]

sorry there was a problem with my data. I have figured it out. The issue was I didn't drop the county beyond 57,000.