ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where county = "Lawrence", deaths = 0 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
279162 | 279162 | 2020-06-27 | Lawrence | Missouri | 29109 | 30 | 0 |
276014 | 276014 | 2020-06-26 | Lawrence | Missouri | 29109 | 28 | 0 |
272871 | 272871 | 2020-06-25 | Lawrence | Missouri | 29109 | 20 | 0 |
269732 | 269732 | 2020-06-24 | Lawrence | Missouri | 29109 | 20 | 0 |
266599 | 266599 | 2020-06-23 | Lawrence | Missouri | 29109 | 19 | 0 |
263473 | 263473 | 2020-06-22 | Lawrence | Missouri | 29109 | 13 | 0 |
260345 | 260345 | 2020-06-21 | Lawrence | Missouri | 29109 | 13 | 0 |
257219 | 257219 | 2020-06-20 | Lawrence | Missouri | 29109 | 11 | 0 |
254099 | 254099 | 2020-06-19 | Lawrence | Missouri | 29109 | 11 | 0 |
250984 | 250984 | 2020-06-18 | Lawrence | Missouri | 29109 | 10 | 0 |
247871 | 247871 | 2020-06-17 | Lawrence | Missouri | 29109 | 8 | 0 |
244758 | 244758 | 2020-06-16 | Lawrence | Missouri | 29109 | 8 | 0 |
241647 | 241647 | 2020-06-15 | Lawrence | Missouri | 29109 | 7 | 0 |
238537 | 238537 | 2020-06-14 | Lawrence | Missouri | 29109 | 7 | 0 |
235430 | 235430 | 2020-06-13 | Lawrence | Missouri | 29109 | 7 | 0 |
232324 | 232324 | 2020-06-12 | Lawrence | Missouri | 29109 | 7 | 0 |
229220 | 229220 | 2020-06-11 | Lawrence | Missouri | 29109 | 7 | 0 |
226117 | 226117 | 2020-06-10 | Lawrence | Missouri | 29109 | 7 | 0 |
223018 | 223018 | 2020-06-09 | Lawrence | Missouri | 29109 | 7 | 0 |
219923 | 219923 | 2020-06-08 | Lawrence | Missouri | 29109 | 7 | 0 |
216831 | 216831 | 2020-06-07 | Lawrence | Missouri | 29109 | 7 | 0 |
213743 | 213743 | 2020-06-06 | Lawrence | Missouri | 29109 | 7 | 0 |
210659 | 210659 | 2020-06-05 | Lawrence | Missouri | 29109 | 7 | 0 |
207578 | 207578 | 2020-06-04 | Lawrence | Missouri | 29109 | 7 | 0 |
204497 | 204497 | 2020-06-03 | Lawrence | Missouri | 29109 | 7 | 0 |
201420 | 201420 | 2020-06-02 | Lawrence | Missouri | 29109 | 7 | 0 |
198347 | 198347 | 2020-06-01 | Lawrence | Missouri | 29109 | 7 | 0 |
195276 | 195276 | 2020-05-31 | Lawrence | Missouri | 29109 | 7 | 0 |
192207 | 192207 | 2020-05-30 | Lawrence | Missouri | 29109 | 7 | 0 |
189143 | 189143 | 2020-05-29 | Lawrence | Missouri | 29109 | 7 | 0 |
186085 | 186085 | 2020-05-28 | Lawrence | Missouri | 29109 | 7 | 0 |
183029 | 183029 | 2020-05-27 | Lawrence | Missouri | 29109 | 7 | 0 |
179983 | 179983 | 2020-05-26 | Lawrence | Missouri | 29109 | 7 | 0 |
176939 | 176939 | 2020-05-25 | Lawrence | Missouri | 29109 | 7 | 0 |
173896 | 173896 | 2020-05-24 | Lawrence | Missouri | 29109 | 7 | 0 |
170854 | 170854 | 2020-05-23 | Lawrence | Missouri | 29109 | 7 | 0 |
167815 | 167815 | 2020-05-22 | Lawrence | Missouri | 29109 | 7 | 0 |
164779 | 164779 | 2020-05-21 | Lawrence | Missouri | 29109 | 7 | 0 |
161750 | 161750 | 2020-05-20 | Lawrence | Missouri | 29109 | 7 | 0 |
158724 | 158724 | 2020-05-19 | Lawrence | Missouri | 29109 | 8 | 0 |
155706 | 155706 | 2020-05-18 | Lawrence | Missouri | 29109 | 7 | 0 |
152692 | 152692 | 2020-05-17 | Lawrence | Missouri | 29109 | 7 | 0 |
149681 | 149681 | 2020-05-16 | Lawrence | Missouri | 29109 | 7 | 0 |
146676 | 146676 | 2020-05-15 | Lawrence | Missouri | 29109 | 7 | 0 |
143675 | 143675 | 2020-05-14 | Lawrence | Missouri | 29109 | 7 | 0 |
140680 | 140680 | 2020-05-13 | Lawrence | Missouri | 29109 | 7 | 0 |
137686 | 137686 | 2020-05-12 | Lawrence | Missouri | 29109 | 7 | 0 |
134696 | 134696 | 2020-05-11 | Lawrence | Missouri | 29109 | 7 | 0 |
131705 | 131705 | 2020-05-10 | Lawrence | Missouri | 29109 | 7 | 0 |
128715 | 128715 | 2020-05-09 | Lawrence | Missouri | 29109 | 7 | 0 |
125727 | 125727 | 2020-05-08 | Lawrence | Missouri | 29109 | 7 | 0 |
122745 | 122745 | 2020-05-07 | Lawrence | Missouri | 29109 | 2 | 0 |
119771 | 119771 | 2020-05-06 | Lawrence | Missouri | 29109 | 1 | 0 |
116811 | 116811 | 2020-05-05 | Lawrence | Missouri | 29109 | 1 | 0 |
113929 | 113929 | 2020-05-04 | Lawrence | Missouri | 29109 | 1 | 0 |
111050 | 111050 | 2020-05-03 | Lawrence | Missouri | 29109 | 1 | 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);