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 deaths
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 ▼ |
---|---|---|---|---|---|---|---|
1225 | 1225 | 2020-03-11 | Lee | Georgia | 13177 | 1 | 0 |
1439 | 1439 | 2020-03-12 | Lee | Georgia | 13177 | 1 | 0 |
1709 | 1709 | 2020-03-13 | Lee | Georgia | 13177 | 1 | 0 |
2032 | 2032 | 2020-03-14 | Lee | Georgia | 13177 | 1 | 0 |
2313 | 2313 | 2020-03-15 | Lee | Alabama | 1081 | 1 | 0 |
2419 | 2419 | 2020-03-15 | Lee | Georgia | 13177 | 2 | 0 |
2742 | 2742 | 2020-03-16 | Lee | Alabama | 1081 | 1 | 0 |
2858 | 2858 | 2020-03-16 | Lee | Georgia | 13177 | 2 | 0 |
3218 | 3218 | 2020-03-17 | Lee | Alabama | 1081 | 3 | 0 |
3343 | 3343 | 2020-03-17 | Lee | Georgia | 13177 | 2 | 0 |
3765 | 3765 | 2020-03-18 | Lee | Alabama | 1081 | 7 | 0 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
20957 | 20957 | 2020-03-30 | Lee | North Carolina | 37105 | 2 | 0 |
21245 | 21245 | 2020-03-30 | Lee | South Carolina | 45061 | 5 | 0 |
21559 | 21559 | 2020-03-30 | Lee | Virginia | 51105 | 2 | 0 |
23083 | 23083 | 2020-03-31 | Lee | North Carolina | 37105 | 2 | 0 |
23383 | 23383 | 2020-03-31 | Lee | South Carolina | 45061 | 5 | 0 |
23705 | 23705 | 2020-03-31 | Lee | Virginia | 51105 | 2 | 0 |
23995 | 23995 | 2020-04-01 | Lee | Arkansas | 5077 | 1 | 0 |
25277 | 25277 | 2020-04-01 | Lee | North Carolina | 37105 | 3 | 0 |
25921 | 25921 | 2020-04-01 | Lee | Virginia | 51105 | 2 | 0 |
26219 | 26219 | 2020-04-02 | Lee | Arkansas | 5077 | 1 | 0 |
27540 | 27540 | 2020-04-02 | Lee | North Carolina | 37105 | 3 | 0 |
28069 | 28069 | 2020-04-02 | Lee | Texas | 48287 | 1 | 0 |
28211 | 28211 | 2020-04-02 | Lee | Virginia | 51105 | 2 | 0 |
28517 | 28517 | 2020-04-03 | Lee | Arkansas | 5077 | 1 | 0 |
29867 | 29867 | 2020-04-03 | Lee | North Carolina | 37105 | 3 | 0 |
30405 | 30405 | 2020-04-03 | Lee | Texas | 48287 | 2 | 0 |
30557 | 30557 | 2020-04-03 | Lee | Virginia | 51105 | 2 | 0 |
30875 | 30875 | 2020-04-04 | Lee | Arkansas | 5077 | 1 | 0 |
31307 | 31307 | 2020-04-04 | Lee | Illinois | 17103 | 2 | 0 |
31469 | 31469 | 2020-04-04 | Lee | Iowa | 19111 | 1 | 0 |
32254 | 32254 | 2020-04-04 | Lee | North Carolina | 37105 | 3 | 0 |
32800 | 32800 | 2020-04-04 | Lee | Texas | 48287 | 2 | 0 |
32956 | 32956 | 2020-04-04 | Lee | Virginia | 51105 | 2 | 0 |
33279 | 33279 | 2020-04-05 | Lee | Arkansas | 5077 | 2 | 0 |
33717 | 33717 | 2020-04-05 | Lee | Illinois | 17103 | 2 | 0 |
33882 | 33882 | 2020-04-05 | Lee | Iowa | 19111 | 1 | 0 |
34685 | 34685 | 2020-04-05 | Lee | North Carolina | 37105 | 3 | 0 |
35238 | 35238 | 2020-04-05 | Lee | Texas | 48287 | 2 | 0 |
35394 | 35394 | 2020-04-05 | Lee | Virginia | 51105 | 2 | 0 |
35722 | 35722 | 2020-04-06 | Lee | Arkansas | 5077 | 2 | 0 |
36169 | 36169 | 2020-04-06 | Lee | Illinois | 17103 | 2 | 0 |
36337 | 36337 | 2020-04-06 | Lee | Iowa | 19111 | 1 | 0 |
37154 | 37154 | 2020-04-06 | Lee | North Carolina | 37105 | 3 | 0 |
37714 | 37714 | 2020-04-06 | Lee | Texas | 48287 | 2 | 0 |
37877 | 37877 | 2020-04-06 | Lee | Virginia | 51105 | 2 | 0 |
38211 | 38211 | 2020-04-07 | Lee | Arkansas | 5077 | 2 | 0 |
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);