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
- Arkansas 760
- Virginia 749
- Illinois 748
- Iowa 748
- North Carolina 748
- Texas 748
- Kentucky 716
fips 12
county 1
- Lee · 9,122 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
89435 | 89435 | 2020-04-25 | Lee | Virginia | 51105 | 8 | 0 |
90277 | 90277 | 2020-04-26 | Lee | Illinois | 17103 | 19 | 0 |
90465 | 90465 | 2020-04-26 | Lee | Iowa | 19111 | 5 | 0 |
91416 | 91416 | 2020-04-26 | Lee | North Carolina | 37105 | 104 | 0 |
92056 | 92056 | 2020-04-26 | Lee | Texas | 48287 | 2 | 0 |
92252 | 92252 | 2020-04-26 | Lee | Virginia | 51105 | 8 | 0 |
93096 | 93096 | 2020-04-27 | Lee | Illinois | 17103 | 20 | 0 |
93284 | 93284 | 2020-04-27 | Lee | Iowa | 19111 | 5 | 0 |
94242 | 94242 | 2020-04-27 | Lee | North Carolina | 37105 | 114 | 0 |
94885 | 94885 | 2020-04-27 | Lee | Texas | 48287 | 2 | 0 |
95081 | 95081 | 2020-04-27 | Lee | Virginia | 51105 | 8 | 0 |
95928 | 95928 | 2020-04-28 | Lee | Illinois | 17103 | 22 | 0 |
96116 | 96116 | 2020-04-28 | Lee | Iowa | 19111 | 7 | 0 |
97079 | 97079 | 2020-04-28 | Lee | North Carolina | 37105 | 127 | 0 |
97725 | 97725 | 2020-04-28 | Lee | Texas | 48287 | 2 | 0 |
97924 | 97924 | 2020-04-28 | Lee | Virginia | 51105 | 9 | 0 |
98772 | 98772 | 2020-04-29 | Lee | Illinois | 17103 | 23 | 0 |
98961 | 98961 | 2020-04-29 | Lee | Iowa | 19111 | 8 | 0 |
99927 | 99927 | 2020-04-29 | Lee | North Carolina | 37105 | 142 | 0 |
100575 | 100575 | 2020-04-29 | Lee | Texas | 48287 | 2 | 0 |
100774 | 100774 | 2020-04-29 | Lee | Virginia | 51105 | 9 | 0 |
101623 | 101623 | 2020-04-30 | Lee | Illinois | 17103 | 24 | 0 |
101812 | 101812 | 2020-04-30 | Lee | Iowa | 19111 | 8 | 0 |
102780 | 102780 | 2020-04-30 | Lee | North Carolina | 37105 | 156 | 0 |
103430 | 103430 | 2020-04-30 | Lee | Texas | 48287 | 2 | 0 |
103629 | 103629 | 2020-04-30 | Lee | Virginia | 51105 | 9 | 0 |
104479 | 104479 | 2020-05-01 | Lee | Illinois | 17103 | 23 | 0 |
104670 | 104670 | 2020-05-01 | Lee | Iowa | 19111 | 9 | 0 |
105642 | 105642 | 2020-05-01 | Lee | North Carolina | 37105 | 169 | 0 |
106294 | 106294 | 2020-05-01 | Lee | Texas | 48287 | 2 | 0 |
106493 | 106493 | 2020-05-01 | Lee | Virginia | 51105 | 10 | 0 |
107344 | 107344 | 2020-05-02 | Lee | Illinois | 17103 | 23 | 0 |
107535 | 107535 | 2020-05-02 | Lee | Iowa | 19111 | 12 | 0 |
109163 | 109163 | 2020-05-02 | Lee | Texas | 48287 | 2 | 0 |
109362 | 109362 | 2020-05-02 | Lee | Virginia | 51105 | 10 | 0 |
110214 | 110214 | 2020-05-03 | Lee | Illinois | 17103 | 25 | 0 |
110405 | 110405 | 2020-05-03 | Lee | Iowa | 19111 | 13 | 0 |
112037 | 112037 | 2020-05-03 | Lee | Texas | 48287 | 2 | 0 |
112236 | 112236 | 2020-05-03 | Lee | Virginia | 51105 | 10 | 0 |
113089 | 113089 | 2020-05-04 | Lee | Illinois | 17103 | 25 | 0 |
113280 | 113280 | 2020-05-04 | Lee | Iowa | 19111 | 14 | 0 |
114919 | 114919 | 2020-05-04 | Lee | Texas | 48287 | 2 | 0 |
115119 | 115119 | 2020-05-04 | Lee | Virginia | 51105 | 10 | 0 |
115972 | 115972 | 2020-05-05 | Lee | Illinois | 17103 | 41 | 0 |
116163 | 116163 | 2020-05-05 | Lee | Iowa | 19111 | 16 | 0 |
117878 | 117878 | 2020-05-05 | Lee | Texas | 48287 | 2 | 0 |
118078 | 118078 | 2020-05-05 | Lee | Virginia | 51105 | 10 | 0 |
118932 | 118932 | 2020-05-06 | Lee | Illinois | 17103 | 49 | 0 |
119123 | 119123 | 2020-05-06 | Lee | Iowa | 19111 | 16 | 0 |
120842 | 120842 | 2020-05-06 | Lee | Texas | 48287 | 2 | 0 |
121042 | 121042 | 2020-05-06 | Lee | Virginia | 51105 | 10 | 0 |
121902 | 121902 | 2020-05-07 | Lee | Illinois | 17103 | 51 | 0 |
122093 | 122093 | 2020-05-07 | Lee | Iowa | 19111 | 17 | 0 |
123821 | 123821 | 2020-05-07 | Lee | Texas | 48287 | 2 | 0 |
124023 | 124023 | 2020-05-07 | Lee | Virginia | 51105 | 10 | 0 |
124881 | 124881 | 2020-05-08 | Lee | Illinois | 17103 | 63 | 0 |
125074 | 125074 | 2020-05-08 | Lee | Iowa | 19111 | 18 | 0 |
126805 | 126805 | 2020-05-08 | Lee | Texas | 48287 | 4 | 0 |
127008 | 127008 | 2020-05-08 | Lee | Virginia | 51105 | 10 | 0 |
127868 | 127868 | 2020-05-09 | Lee | Illinois | 17103 | 63 | 0 |
128061 | 128061 | 2020-05-09 | Lee | Iowa | 19111 | 18 | 0 |
129794 | 129794 | 2020-05-09 | Lee | Texas | 48287 | 5 | 0 |
129998 | 129998 | 2020-05-09 | Lee | Virginia | 51105 | 10 | 0 |
130859 | 130859 | 2020-05-10 | Lee | Illinois | 17103 | 63 | 0 |
131052 | 131052 | 2020-05-10 | Lee | Iowa | 19111 | 18 | 0 |
132784 | 132784 | 2020-05-10 | Lee | Texas | 48287 | 5 | 0 |
132988 | 132988 | 2020-05-10 | Lee | Virginia | 51105 | 10 | 0 |
133850 | 133850 | 2020-05-11 | Lee | Illinois | 17103 | 63 | 0 |
134042 | 134042 | 2020-05-11 | Lee | Iowa | 19111 | 18 | 0 |
135775 | 135775 | 2020-05-11 | Lee | Texas | 48287 | 5 | 0 |
135978 | 135978 | 2020-05-11 | Lee | Virginia | 51105 | 10 | 0 |
136839 | 136839 | 2020-05-12 | Lee | Illinois | 17103 | 69 | 0 |
137032 | 137032 | 2020-05-12 | Lee | Iowa | 19111 | 18 | 0 |
138765 | 138765 | 2020-05-12 | Lee | Texas | 48287 | 6 | 0 |
138969 | 138969 | 2020-05-12 | Lee | Virginia | 51105 | 10 | 0 |
139831 | 139831 | 2020-05-13 | Lee | Illinois | 17103 | 70 | 0 |
140025 | 140025 | 2020-05-13 | Lee | Iowa | 19111 | 18 | 0 |
141761 | 141761 | 2020-05-13 | Lee | Texas | 48287 | 6 | 0 |
141965 | 141965 | 2020-05-13 | Lee | Virginia | 51105 | 10 | 0 |
143021 | 143021 | 2020-05-14 | Lee | Iowa | 19111 | 18 | 0 |
144758 | 144758 | 2020-05-14 | Lee | Texas | 48287 | 6 | 0 |
144962 | 144962 | 2020-05-14 | Lee | Virginia | 51105 | 10 | 0 |
146021 | 146021 | 2020-05-15 | Lee | Iowa | 19111 | 18 | 0 |
147762 | 147762 | 2020-05-15 | Lee | Texas | 48287 | 6 | 0 |
147965 | 147965 | 2020-05-15 | Lee | Virginia | 51105 | 10 | 0 |
149025 | 149025 | 2020-05-16 | Lee | Iowa | 19111 | 18 | 0 |
150770 | 150770 | 2020-05-16 | Lee | Texas | 48287 | 6 | 0 |
150974 | 150974 | 2020-05-16 | Lee | Virginia | 51105 | 10 | 0 |
152035 | 152035 | 2020-05-17 | Lee | Iowa | 19111 | 18 | 0 |
153781 | 153781 | 2020-05-17 | Lee | Texas | 48287 | 6 | 0 |
153985 | 153985 | 2020-05-17 | Lee | Virginia | 51105 | 10 | 0 |
155047 | 155047 | 2020-05-18 | Lee | Iowa | 19111 | 19 | 0 |
156798 | 156798 | 2020-05-18 | Lee | Texas | 48287 | 6 | 0 |
157002 | 157002 | 2020-05-18 | Lee | Virginia | 51105 | 10 | 0 |
158063 | 158063 | 2020-05-19 | Lee | Iowa | 19111 | 20 | 0 |
159820 | 159820 | 2020-05-19 | Lee | Texas | 48287 | 7 | 0 |
160026 | 160026 | 2020-05-19 | Lee | Virginia | 51105 | 10 | 0 |
161089 | 161089 | 2020-05-20 | Lee | Iowa | 19111 | 20 | 0 |
162848 | 162848 | 2020-05-20 | Lee | Texas | 48287 | 6 | 0 |
163054 | 163054 | 2020-05-20 | Lee | Virginia | 51105 | 10 | 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);