ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,322 rows where county = "Lee" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 12
- Florida 799
- Georgia 794
- Alabama 790
- South Carolina 787
- Mississippi 785
- North Carolina 783
- Virginia 783
- Arkansas 773
- Texas 772
- Illinois 770
- Iowa 770
- Kentucky 716
fips 12
county 1
- Lee · 9,322 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607 | 607 | 2020-03-06 | Lee | Florida | 12071 | 1 | 1 |
687 | 687 | 2020-03-07 | Lee | Florida | 12071 | 2 | 1 |
783 | 783 | 2020-03-08 | Lee | Florida | 12071 | 2 | 1 |
900 | 900 | 2020-03-09 | Lee | Florida | 12071 | 2 | 1 |
1037 | 1037 | 2020-03-10 | Lee | Florida | 12071 | 2 | 1 |
1206 | 1206 | 2020-03-11 | Lee | Florida | 12071 | 2 | 1 |
1225 | 1225 | 2020-03-11 | Lee | Georgia | 13177 | 1 | 0 |
1417 | 1417 | 2020-03-12 | Lee | Florida | 12071 | 4 | 1 |
1439 | 1439 | 2020-03-12 | Lee | Georgia | 13177 | 1 | 0 |
1683 | 1683 | 2020-03-13 | Lee | Florida | 12071 | 4 | 1 |
1709 | 1709 | 2020-03-13 | Lee | Georgia | 13177 | 1 | 0 |
2005 | 2005 | 2020-03-14 | Lee | Florida | 12071 | 4 | 2 |
2032 | 2032 | 2020-03-14 | Lee | Georgia | 13177 | 1 | 0 |
2313 | 2313 | 2020-03-15 | Lee | Alabama | 1081 | 1 | 0 |
2389 | 2389 | 2020-03-15 | Lee | Florida | 12071 | 5 | 2 |
2419 | 2419 | 2020-03-15 | Lee | Georgia | 13177 | 2 | 0 |
2742 | 2742 | 2020-03-16 | Lee | Alabama | 1081 | 1 | 0 |
2826 | 2826 | 2020-03-16 | Lee | Florida | 12071 | 5 | 2 |
2858 | 2858 | 2020-03-16 | Lee | Georgia | 13177 | 2 | 0 |
3218 | 3218 | 2020-03-17 | Lee | Alabama | 1081 | 3 | 0 |
3310 | 3310 | 2020-03-17 | Lee | Florida | 12071 | 7 | 2 |
3343 | 3343 | 2020-03-17 | Lee | Georgia | 13177 | 2 | 0 |
3765 | 3765 | 2020-03-18 | Lee | Alabama | 1081 | 7 | 0 |
3867 | 3867 | 2020-03-18 | Lee | Florida | 12071 | 11 | 2 |
3905 | 3905 | 2020-03-18 | Lee | Georgia | 13177 | 2 | 0 |
4268 | 4268 | 2020-03-18 | Lee | South Carolina | 45061 | 1 | 0 |
4406 | 4406 | 2020-03-19 | Lee | Alabama | 1081 | 10 | 0 |
4535 | 4535 | 2020-03-19 | Lee | Florida | 12071 | 11 | 2 |
4579 | 4579 | 2020-03-19 | Lee | Georgia | 13177 | 4 | 0 |
5012 | 5012 | 2020-03-19 | Lee | South Carolina | 45061 | 1 | 0 |
5176 | 5176 | 2020-03-20 | Lee | Alabama | 1081 | 11 | 0 |
5314 | 5314 | 2020-03-20 | Lee | Florida | 12071 | 14 | 2 |
5365 | 5365 | 2020-03-20 | Lee | Georgia | 13177 | 13 | 0 |
5618 | 5618 | 2020-03-20 | Lee | Mississippi | 28081 | 1 | 0 |
5890 | 5890 | 2020-03-20 | Lee | South Carolina | 45061 | 1 | 0 |
6092 | 6092 | 2020-03-21 | Lee | Alabama | 1081 | 12 | 0 |
6243 | 6243 | 2020-03-21 | Lee | Florida | 12071 | 17 | 2 |
6298 | 6298 | 2020-03-21 | Lee | Georgia | 13177 | 14 | 0 |
6598 | 6598 | 2020-03-21 | Lee | Mississippi | 28081 | 5 | 0 |
6898 | 6898 | 2020-03-21 | Lee | South Carolina | 45061 | 1 | 0 |
7126 | 7126 | 2020-03-22 | Lee | Alabama | 1081 | 16 | 0 |
7283 | 7283 | 2020-03-22 | Lee | Florida | 12071 | 26 | 2 |
7344 | 7344 | 2020-03-22 | Lee | Georgia | 13177 | 16 | 0 |
7681 | 7681 | 2020-03-22 | Lee | Mississippi | 28081 | 6 | 0 |
7864 | 7864 | 2020-03-22 | Lee | North Carolina | 37105 | 1 | 0 |
8019 | 8019 | 2020-03-22 | Lee | South Carolina | 45061 | 1 | 0 |
8164 | 8164 | 2020-03-22 | Lee | Virginia | 51105 | 2 | 0 |
8266 | 8266 | 2020-03-23 | Lee | Alabama | 1081 | 19 | 0 |
8429 | 8429 | 2020-03-23 | Lee | Florida | 12071 | 30 | 2 |
8493 | 8493 | 2020-03-23 | Lee | Georgia | 13177 | 19 | 0 |
8862 | 8862 | 2020-03-23 | Lee | Mississippi | 28081 | 8 | 0 |
9065 | 9065 | 2020-03-23 | Lee | North Carolina | 37105 | 1 | 0 |
9232 | 9232 | 2020-03-23 | Lee | South Carolina | 45061 | 2 | 0 |
9386 | 9386 | 2020-03-23 | Lee | Virginia | 51105 | 2 | 0 |
9493 | 9493 | 2020-03-24 | Lee | Alabama | 1081 | 26 | 0 |
9674 | 9674 | 2020-03-24 | Lee | Florida | 12071 | 34 | 3 |
9748 | 9748 | 2020-03-24 | Lee | Georgia | 13177 | 24 | 1 |
10158 | 10158 | 2020-03-24 | Lee | Mississippi | 28081 | 12 | 0 |
10373 | 10373 | 2020-03-24 | Lee | North Carolina | 37105 | 1 | 0 |
10558 | 10558 | 2020-03-24 | Lee | South Carolina | 45061 | 2 | 0 |
10734 | 10734 | 2020-03-24 | Lee | Virginia | 51105 | 2 | 0 |
10858 | 10858 | 2020-03-25 | Lee | Alabama | 1081 | 40 | 0 |
11049 | 11049 | 2020-03-25 | Lee | Florida | 12071 | 52 | 3 |
11127 | 11127 | 2020-03-25 | Lee | Georgia | 13177 | 25 | 1 |
11578 | 11578 | 2020-03-25 | Lee | Mississippi | 28081 | 14 | 0 |
11815 | 11815 | 2020-03-25 | Lee | North Carolina | 37105 | 1 | 0 |
12029 | 12029 | 2020-03-25 | Lee | South Carolina | 45061 | 2 | 0 |
12248 | 12248 | 2020-03-25 | Lee | Virginia | 51105 | 2 | 0 |
12395 | 12395 | 2020-03-26 | Lee | Alabama | 1081 | 47 | 0 |
12597 | 12597 | 2020-03-26 | Lee | Florida | 12071 | 66 | 3 |
12678 | 12678 | 2020-03-26 | Lee | Georgia | 13177 | 30 | 1 |
13171 | 13171 | 2020-03-26 | Lee | Mississippi | 28081 | 15 | 0 |
13419 | 13419 | 2020-03-26 | Lee | North Carolina | 37105 | 1 | 0 |
13651 | 13651 | 2020-03-26 | Lee | South Carolina | 45061 | 2 | 0 |
13889 | 13889 | 2020-03-26 | Lee | Virginia | 51105 | 2 | 0 |
14056 | 14056 | 2020-03-27 | Lee | Alabama | 1081 | 53 | 0 |
14266 | 14266 | 2020-03-27 | Lee | Florida | 12071 | 95 | 5 |
14352 | 14352 | 2020-03-27 | Lee | Georgia | 13177 | 37 | 1 |
14889 | 14889 | 2020-03-27 | Lee | Mississippi | 28081 | 15 | 0 |
15154 | 15154 | 2020-03-27 | Lee | North Carolina | 37105 | 2 | 0 |
15398 | 15398 | 2020-03-27 | Lee | South Carolina | 45061 | 2 | 0 |
15657 | 15657 | 2020-03-27 | Lee | Virginia | 51105 | 2 | 0 |
15834 | 15834 | 2020-03-28 | Lee | Alabama | 1081 | 56 | 0 |
16051 | 16051 | 2020-03-28 | Lee | Florida | 12071 | 119 | 6 |
16139 | 16139 | 2020-03-28 | Lee | Georgia | 13177 | 39 | 6 |
16713 | 16713 | 2020-03-28 | Lee | Mississippi | 28081 | 17 | 1 |
16986 | 16986 | 2020-03-28 | Lee | North Carolina | 37105 | 2 | 0 |
17253 | 17253 | 2020-03-28 | Lee | South Carolina | 45061 | 5 | 0 |
17533 | 17533 | 2020-03-28 | Lee | Virginia | 51105 | 2 | 0 |
17717 | 17717 | 2020-03-29 | Lee | Alabama | 1081 | 57 | 0 |
17944 | 17944 | 2020-03-29 | Lee | Florida | 12071 | 151 | 6 |
18036 | 18036 | 2020-03-29 | Lee | Georgia | 13177 | 43 | 6 |
18635 | 18635 | 2020-03-29 | Lee | Mississippi | 28081 | 21 | 1 |
18917 | 18917 | 2020-03-29 | Lee | North Carolina | 37105 | 2 | 0 |
19193 | 19193 | 2020-03-29 | Lee | South Carolina | 45061 | 5 | 0 |
19494 | 19494 | 2020-03-29 | Lee | Virginia | 51105 | 2 | 0 |
19689 | 19689 | 2020-03-30 | Lee | Alabama | 1081 | 74 | 2 |
19925 | 19925 | 2020-03-30 | Lee | Florida | 12071 | 170 | 6 |
20028 | 20028 | 2020-03-30 | Lee | Georgia | 13177 | 44 | 6 |
20659 | 20659 | 2020-03-30 | Lee | Mississippi | 28081 | 23 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);