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)
state 12
- Florida 799
- Georgia 781
- Mississippi 777
- Alabama 775
- South Carolina 773
- Illinois 767
- Iowa 767
- North Carolina 767
- Texas 767
- Virginia 767
- Arkansas 766
- Kentucky 716
fips 12
county 1
- Lee · 9,222 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
38665 | 38665 | 2020-04-07 | Lee | Illinois | 17103 | 3 | 0 |
38838 | 38838 | 2020-04-07 | Lee | Iowa | 19111 | 1 | 0 |
39669 | 39669 | 2020-04-07 | Lee | North Carolina | 37105 | 4 | 0 |
40242 | 40242 | 2020-04-07 | Lee | Texas | 48287 | 2 | 0 |
40410 | 40410 | 2020-04-07 | Lee | Virginia | 51105 | 2 | 0 |
40754 | 40754 | 2020-04-08 | Lee | Arkansas | 5077 | 2 | 0 |
41210 | 41210 | 2020-04-08 | Lee | Illinois | 17103 | 6 | 0 |
41384 | 41384 | 2020-04-08 | Lee | Iowa | 19111 | 1 | 0 |
42226 | 42226 | 2020-04-08 | Lee | North Carolina | 37105 | 5 | 0 |
42810 | 42810 | 2020-04-08 | Lee | Texas | 48287 | 2 | 0 |
42979 | 42979 | 2020-04-08 | Lee | Virginia | 51105 | 3 | 0 |
43326 | 43326 | 2020-04-09 | Lee | Arkansas | 5077 | 2 | 0 |
43784 | 43784 | 2020-04-09 | Lee | Illinois | 17103 | 9 | 0 |
43960 | 43960 | 2020-04-09 | Lee | Iowa | 19111 | 1 | 0 |
44810 | 44810 | 2020-04-09 | Lee | North Carolina | 37105 | 4 | 0 |
45400 | 45400 | 2020-04-09 | Lee | Texas | 48287 | 2 | 0 |
45574 | 45574 | 2020-04-09 | Lee | Virginia | 51105 | 3 | 0 |
45925 | 45925 | 2020-04-10 | Lee | Arkansas | 5077 | 2 | 0 |
46388 | 46388 | 2020-04-10 | Lee | Illinois | 17103 | 12 | 0 |
46565 | 46565 | 2020-04-10 | Lee | Iowa | 19111 | 1 | 0 |
47423 | 47423 | 2020-04-10 | Lee | North Carolina | 37105 | 4 | 0 |
48021 | 48021 | 2020-04-10 | Lee | Texas | 48287 | 2 | 0 |
48200 | 48200 | 2020-04-10 | Lee | Virginia | 51105 | 3 | 0 |
48555 | 48555 | 2020-04-11 | Lee | Arkansas | 5077 | 2 | 0 |
49019 | 49019 | 2020-04-11 | Lee | Illinois | 17103 | 12 | 0 |
49199 | 49199 | 2020-04-11 | Lee | Iowa | 19111 | 1 | 0 |
50078 | 50078 | 2020-04-11 | Lee | North Carolina | 37105 | 8 | 0 |
50679 | 50679 | 2020-04-11 | Lee | Texas | 48287 | 2 | 0 |
50858 | 50858 | 2020-04-11 | Lee | Virginia | 51105 | 6 | 0 |
51217 | 51217 | 2020-04-12 | Lee | Arkansas | 5077 | 2 | 0 |
51681 | 51681 | 2020-04-12 | Lee | Illinois | 17103 | 13 | 0 |
51863 | 51863 | 2020-04-12 | Lee | Iowa | 19111 | 1 | 0 |
52751 | 52751 | 2020-04-12 | Lee | North Carolina | 37105 | 15 | 0 |
53354 | 53354 | 2020-04-12 | Lee | Texas | 48287 | 2 | 0 |
53533 | 53533 | 2020-04-12 | Lee | Virginia | 51105 | 6 | 0 |
53896 | 53896 | 2020-04-13 | Lee | Arkansas | 5077 | 2 | 0 |
54362 | 54362 | 2020-04-13 | Lee | Illinois | 17103 | 14 | 0 |
54545 | 54545 | 2020-04-13 | Lee | Iowa | 19111 | 2 | 0 |
55435 | 55435 | 2020-04-13 | Lee | North Carolina | 37105 | 12 | 0 |
56042 | 56042 | 2020-04-13 | Lee | Texas | 48287 | 2 | 0 |
56223 | 56223 | 2020-04-13 | Lee | Virginia | 51105 | 7 | 0 |
57055 | 57055 | 2020-04-14 | Lee | Illinois | 17103 | 13 | 0 |
57238 | 57238 | 2020-04-14 | Lee | Iowa | 19111 | 2 | 0 |
58135 | 58135 | 2020-04-14 | Lee | North Carolina | 37105 | 14 | 0 |
58747 | 58747 | 2020-04-14 | Lee | Texas | 48287 | 2 | 0 |
58929 | 58929 | 2020-04-14 | Lee | Virginia | 51105 | 6 | 0 |
59762 | 59762 | 2020-04-15 | Lee | Illinois | 17103 | 15 | 0 |
59946 | 59946 | 2020-04-15 | Lee | Iowa | 19111 | 2 | 0 |
60849 | 60849 | 2020-04-15 | Lee | North Carolina | 37105 | 16 | 0 |
61465 | 61465 | 2020-04-15 | Lee | Texas | 48287 | 2 | 0 |
61648 | 61648 | 2020-04-15 | Lee | Virginia | 51105 | 6 | 0 |
62483 | 62483 | 2020-04-16 | Lee | Illinois | 17103 | 15 | 0 |
62667 | 62667 | 2020-04-16 | Lee | Iowa | 19111 | 3 | 0 |
63575 | 63575 | 2020-04-16 | Lee | North Carolina | 37105 | 18 | 0 |
64193 | 64193 | 2020-04-16 | Lee | Texas | 48287 | 2 | 0 |
64381 | 64381 | 2020-04-16 | Lee | Virginia | 51105 | 6 | 0 |
65216 | 65216 | 2020-04-17 | Lee | Illinois | 17103 | 17 | 0 |
65401 | 65401 | 2020-04-17 | Lee | Iowa | 19111 | 3 | 0 |
66318 | 66318 | 2020-04-17 | Lee | North Carolina | 37105 | 21 | 0 |
66940 | 66940 | 2020-04-17 | Lee | Texas | 48287 | 2 | 0 |
67129 | 67129 | 2020-04-17 | Lee | Virginia | 51105 | 7 | 0 |
67965 | 67965 | 2020-04-18 | Lee | Illinois | 17103 | 17 | 0 |
68150 | 68150 | 2020-04-18 | Lee | Iowa | 19111 | 3 | 0 |
69075 | 69075 | 2020-04-18 | Lee | North Carolina | 37105 | 30 | 0 |
69700 | 69700 | 2020-04-18 | Lee | Texas | 48287 | 2 | 0 |
69891 | 69891 | 2020-04-18 | Lee | Virginia | 51105 | 7 | 0 |
70727 | 70727 | 2020-04-19 | Lee | Illinois | 17103 | 17 | 0 |
70912 | 70912 | 2020-04-19 | Lee | Iowa | 19111 | 3 | 0 |
71841 | 71841 | 2020-04-19 | Lee | North Carolina | 37105 | 34 | 0 |
72469 | 72469 | 2020-04-19 | Lee | Texas | 48287 | 2 | 0 |
72661 | 72661 | 2020-04-19 | Lee | Virginia | 51105 | 7 | 0 |
73497 | 73497 | 2020-04-20 | Lee | Illinois | 17103 | 17 | 0 |
73683 | 73683 | 2020-04-20 | Lee | Iowa | 19111 | 3 | 0 |
74616 | 74616 | 2020-04-20 | Lee | North Carolina | 37105 | 38 | 0 |
75245 | 75245 | 2020-04-20 | Lee | Texas | 48287 | 2 | 0 |
75437 | 75437 | 2020-04-20 | Lee | Virginia | 51105 | 7 | 0 |
76274 | 76274 | 2020-04-21 | Lee | Illinois | 17103 | 17 | 0 |
76462 | 76462 | 2020-04-21 | Lee | Iowa | 19111 | 3 | 0 |
77397 | 77397 | 2020-04-21 | Lee | North Carolina | 37105 | 44 | 0 |
78027 | 78027 | 2020-04-21 | Lee | Texas | 48287 | 2 | 0 |
78219 | 78219 | 2020-04-21 | Lee | Virginia | 51105 | 7 | 0 |
79058 | 79058 | 2020-04-22 | Lee | Illinois | 17103 | 18 | 0 |
79246 | 79246 | 2020-04-22 | Lee | Iowa | 19111 | 3 | 0 |
80186 | 80186 | 2020-04-22 | Lee | North Carolina | 37105 | 49 | 0 |
80818 | 80818 | 2020-04-22 | Lee | Texas | 48287 | 2 | 0 |
81012 | 81012 | 2020-04-22 | Lee | Virginia | 51105 | 7 | 0 |
81851 | 81851 | 2020-04-23 | Lee | Illinois | 17103 | 18 | 0 |
82039 | 82039 | 2020-04-23 | Lee | Iowa | 19111 | 3 | 0 |
82985 | 82985 | 2020-04-23 | Lee | North Carolina | 37105 | 65 | 0 |
83619 | 83619 | 2020-04-23 | Lee | Texas | 48287 | 2 | 0 |
83813 | 83813 | 2020-04-23 | Lee | Virginia | 51105 | 7 | 0 |
84651 | 84651 | 2020-04-24 | Lee | Illinois | 17103 | 18 | 0 |
84839 | 84839 | 2020-04-24 | Lee | Iowa | 19111 | 4 | 0 |
85789 | 85789 | 2020-04-24 | Lee | North Carolina | 37105 | 81 | 0 |
86424 | 86424 | 2020-04-24 | Lee | Texas | 48287 | 2 | 0 |
86620 | 86620 | 2020-04-24 | Lee | Virginia | 51105 | 8 | 0 |
87461 | 87461 | 2020-04-25 | Lee | Illinois | 17103 | 19 | 0 |
87649 | 87649 | 2020-04-25 | Lee | Iowa | 19111 | 4 | 0 |
88601 | 88601 | 2020-04-25 | Lee | North Carolina | 37105 | 101 | 0 |
89239 | 89239 | 2020-04-25 | Lee | Texas | 48287 | 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);