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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-05-28 12
- 2020-05-29 12
- 2020-05-30 12
- 2020-05-31 12
- 2020-06-01 12
- 2020-06-02 12
- 2020-06-03 12
- 2020-06-04 12
- 2020-06-05 12
- 2020-06-06 12
- 2020-06-07 12
- 2020-06-08 12
- 2020-06-09 12
- 2020-06-10 12
- 2020-06-11 12
- 2020-06-12 12
- 2020-06-13 12
- 2020-06-14 12
- 2020-06-15 12
- 2020-06-16 12
- 2020-06-17 12
- 2020-06-18 12
- 2020-06-19 12
- 2020-06-20 12
- 2020-06-21 12
- 2020-06-22 12
- 2020-06-23 12
- 2020-06-24 12
- 2020-06-25 12
- 2020-06-26 12
- …
state 12
- North Carolina 775
- South Carolina 775
- Virginia 775
- Alabama 774
- Florida 774
- Georgia 774
- Mississippi 774
- Arkansas 773
- Texas 772
- Illinois 770
- Iowa 770
- Kentucky 716
fips 12
county 1
- Lee · 9,222 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
21761 | 21761 | 2020-03-31 | Lee | Alabama | 1081 | 75 | 2 |
22003 | 22003 | 2020-03-31 | Lee | Florida | 12071 | 206 | 8 |
22109 | 22109 | 2020-03-31 | Lee | Georgia | 13177 | 90 | 7 |
22776 | 22776 | 2020-03-31 | Lee | Mississippi | 28081 | 24 | 1 |
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 |
23917 | 23917 | 2020-04-01 | Lee | Alabama | 1081 | 83 | 2 |
23995 | 23995 | 2020-04-01 | Lee | Arkansas | 5077 | 1 | 0 |
24164 | 24164 | 2020-04-01 | Lee | Florida | 12071 | 235 | 10 |
24273 | 24273 | 2020-04-01 | Lee | Georgia | 13177 | 94 | 7 |
24960 | 24960 | 2020-04-01 | Lee | Mississippi | 28081 | 25 | 1 |
25277 | 25277 | 2020-04-01 | Lee | North Carolina | 37105 | 3 | 0 |
25581 | 25581 | 2020-04-01 | Lee | South Carolina | 45061 | 5 | 1 |
25921 | 25921 | 2020-04-01 | Lee | Virginia | 51105 | 2 | 0 |
26139 | 26139 | 2020-04-02 | Lee | Alabama | 1081 | 91 | 3 |
26219 | 26219 | 2020-04-02 | Lee | Arkansas | 5077 | 1 | 0 |
26394 | 26394 | 2020-04-02 | Lee | Florida | 12071 | 274 | 10 |
26504 | 26504 | 2020-04-02 | Lee | Georgia | 13177 | 104 | 7 |
27214 | 27214 | 2020-04-02 | Lee | Mississippi | 28081 | 24 | 1 |
27540 | 27540 | 2020-04-02 | Lee | North Carolina | 37105 | 3 | 0 |
27856 | 27856 | 2020-04-02 | Lee | South Carolina | 45061 | 8 | 1 |
28069 | 28069 | 2020-04-02 | Lee | Texas | 48287 | 1 | 0 |
28211 | 28211 | 2020-04-02 | Lee | Virginia | 51105 | 2 | 0 |
28436 | 28436 | 2020-04-03 | Lee | Alabama | 1081 | 99 | 3 |
28517 | 28517 | 2020-04-03 | Lee | Arkansas | 5077 | 1 | 0 |
28697 | 28697 | 2020-04-03 | Lee | Florida | 12071 | 303 | 11 |
28808 | 28808 | 2020-04-03 | Lee | Georgia | 13177 | 123 | 8 |
29533 | 29533 | 2020-04-03 | Lee | Mississippi | 28081 | 26 | 1 |
29867 | 29867 | 2020-04-03 | Lee | North Carolina | 37105 | 3 | 0 |
30191 | 30191 | 2020-04-03 | Lee | South Carolina | 45061 | 13 | 1 |
30405 | 30405 | 2020-04-03 | Lee | Texas | 48287 | 2 | 0 |
30557 | 30557 | 2020-04-03 | Lee | Virginia | 51105 | 2 | 0 |
30793 | 30793 | 2020-04-04 | Lee | Alabama | 1081 | 104 | 3 |
30875 | 30875 | 2020-04-04 | Lee | Arkansas | 5077 | 1 | 0 |
31057 | 31057 | 2020-04-04 | Lee | Florida | 12071 | 347 | 11 |
31168 | 31168 | 2020-04-04 | Lee | Georgia | 13177 | 134 | 8 |
31307 | 31307 | 2020-04-04 | Lee | Illinois | 17103 | 2 | 0 |
31469 | 31469 | 2020-04-04 | Lee | Iowa | 19111 | 1 | 0 |
31913 | 31913 | 2020-04-04 | Lee | Mississippi | 28081 | 28 | 1 |
32254 | 32254 | 2020-04-04 | Lee | North Carolina | 37105 | 3 | 0 |
32582 | 32582 | 2020-04-04 | Lee | South Carolina | 45061 | 16 | 1 |
32800 | 32800 | 2020-04-04 | Lee | Texas | 48287 | 2 | 0 |
32956 | 32956 | 2020-04-04 | Lee | Virginia | 51105 | 2 | 0 |
33197 | 33197 | 2020-04-05 | Lee | Alabama | 1081 | 110 | 3 |
33279 | 33279 | 2020-04-05 | Lee | Arkansas | 5077 | 2 | 0 |
33463 | 33463 | 2020-04-05 | Lee | Florida | 12071 | 378 | 11 |
33575 | 33575 | 2020-04-05 | Lee | Georgia | 13177 | 138 | 9 |
33717 | 33717 | 2020-04-05 | Lee | Illinois | 17103 | 2 | 0 |
33882 | 33882 | 2020-04-05 | Lee | Iowa | 19111 | 1 | 0 |
34340 | 34340 | 2020-04-05 | Lee | Mississippi | 28081 | 30 | 1 |
34685 | 34685 | 2020-04-05 | Lee | North Carolina | 37105 | 3 | 0 |
35018 | 35018 | 2020-04-05 | Lee | South Carolina | 45061 | 17 | 2 |
35238 | 35238 | 2020-04-05 | Lee | Texas | 48287 | 2 | 0 |
35394 | 35394 | 2020-04-05 | Lee | Virginia | 51105 | 2 | 0 |
35636 | 35636 | 2020-04-06 | Lee | Alabama | 1081 | 118 | 3 |
35722 | 35722 | 2020-04-06 | Lee | Arkansas | 5077 | 2 | 0 |
35909 | 35909 | 2020-04-06 | Lee | Florida | 12071 | 399 | 14 |
36025 | 36025 | 2020-04-06 | Lee | Georgia | 13177 | 148 | 13 |
36169 | 36169 | 2020-04-06 | Lee | Illinois | 17103 | 2 | 0 |
36337 | 36337 | 2020-04-06 | Lee | Iowa | 19111 | 1 | 0 |
36803 | 36803 | 2020-04-06 | Lee | Mississippi | 28081 | 30 | 2 |
37154 | 37154 | 2020-04-06 | Lee | North Carolina | 37105 | 3 | 0 |
37493 | 37493 | 2020-04-06 | Lee | South Carolina | 45061 | 18 | 2 |
37714 | 37714 | 2020-04-06 | Lee | Texas | 48287 | 2 | 0 |
37877 | 37877 | 2020-04-06 | Lee | Virginia | 51105 | 2 | 0 |
38124 | 38124 | 2020-04-07 | Lee | Alabama | 1081 | 133 | 5 |
38211 | 38211 | 2020-04-07 | Lee | Arkansas | 5077 | 2 | 0 |
38400 | 38400 | 2020-04-07 | Lee | Florida | 12071 | 438 | 14 |
38518 | 38518 | 2020-04-07 | Lee | Georgia | 13177 | 204 | 15 |
38665 | 38665 | 2020-04-07 | Lee | Illinois | 17103 | 3 | 0 |
38838 | 38838 | 2020-04-07 | Lee | Iowa | 19111 | 1 | 0 |
39314 | 39314 | 2020-04-07 | Lee | Mississippi | 28081 | 38 | 2 |
39669 | 39669 | 2020-04-07 | Lee | North Carolina | 37105 | 4 | 0 |
40016 | 40016 | 2020-04-07 | Lee | South Carolina | 45061 | 19 | 2 |
40242 | 40242 | 2020-04-07 | Lee | Texas | 48287 | 2 | 0 |
40410 | 40410 | 2020-04-07 | Lee | Virginia | 51105 | 2 | 0 |
40666 | 40666 | 2020-04-08 | Lee | Alabama | 1081 | 190 | 5 |
40754 | 40754 | 2020-04-08 | Lee | Arkansas | 5077 | 2 | 0 |
40944 | 40944 | 2020-04-08 | Lee | Florida | 12071 | 475 | 14 |
41062 | 41062 | 2020-04-08 | Lee | Georgia | 13177 | 210 | 14 |
41210 | 41210 | 2020-04-08 | Lee | Illinois | 17103 | 6 | 0 |
41384 | 41384 | 2020-04-08 | Lee | Iowa | 19111 | 1 | 0 |
41868 | 41868 | 2020-04-08 | Lee | Mississippi | 28081 | 40 | 2 |
42226 | 42226 | 2020-04-08 | Lee | North Carolina | 37105 | 5 | 0 |
42576 | 42576 | 2020-04-08 | Lee | South Carolina | 45061 | 22 | 2 |
42810 | 42810 | 2020-04-08 | Lee | Texas | 48287 | 2 | 0 |
42979 | 42979 | 2020-04-08 | Lee | Virginia | 51105 | 3 | 0 |
43239 | 43239 | 2020-04-09 | Lee | Alabama | 1081 | 206 | 6 |
43326 | 43326 | 2020-04-09 | Lee | Arkansas | 5077 | 2 | 0 |
43518 | 43518 | 2020-04-09 | Lee | Florida | 12071 | 521 | 14 |
43636 | 43636 | 2020-04-09 | Lee | Georgia | 13177 | 217 | 15 |
43784 | 43784 | 2020-04-09 | Lee | Illinois | 17103 | 9 | 0 |
43960 | 43960 | 2020-04-09 | Lee | Iowa | 19111 | 1 | 0 |
44445 | 44445 | 2020-04-09 | Lee | Mississippi | 28081 | 40 | 2 |
44810 | 44810 | 2020-04-09 | Lee | North Carolina | 37105 | 4 | 0 |
45162 | 45162 | 2020-04-09 | Lee | South Carolina | 45061 | 24 | 3 |
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);