ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Stone" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387535 | 387535 | 2020-07-31 | Stone | Missouri | 29209 | 80 | 1 |
384317 | 384317 | 2020-07-30 | Stone | Missouri | 29209 | 79 | 1 |
381101 | 381101 | 2020-07-29 | Stone | Missouri | 29209 | 71 | 1 |
377884 | 377884 | 2020-07-28 | Stone | Missouri | 29209 | 70 | 1 |
374669 | 374669 | 2020-07-27 | Stone | Missouri | 29209 | 59 | 1 |
371457 | 371457 | 2020-07-26 | Stone | Missouri | 29209 | 58 | 1 |
368246 | 368246 | 2020-07-25 | Stone | Missouri | 29209 | 58 | 1 |
365038 | 365038 | 2020-07-24 | Stone | Missouri | 29209 | 58 | 1 |
361831 | 361831 | 2020-07-23 | Stone | Missouri | 29209 | 50 | 1 |
358626 | 358626 | 2020-07-22 | Stone | Missouri | 29209 | 47 | 1 |
355423 | 355423 | 2020-07-21 | Stone | Missouri | 29209 | 41 | 0 |
352221 | 352221 | 2020-07-20 | Stone | Missouri | 29209 | 38 | 0 |
349021 | 349021 | 2020-07-19 | Stone | Missouri | 29209 | 38 | 0 |
345820 | 345820 | 2020-07-18 | Stone | Missouri | 29209 | 37 | 0 |
342620 | 342620 | 2020-07-17 | Stone | Missouri | 29209 | 36 | 0 |
339424 | 339424 | 2020-07-16 | Stone | Missouri | 29209 | 32 | 0 |
336228 | 336228 | 2020-07-15 | Stone | Missouri | 29209 | 32 | 0 |
333035 | 333035 | 2020-07-14 | Stone | Missouri | 29209 | 30 | 0 |
329848 | 329848 | 2020-07-13 | Stone | Missouri | 29209 | 22 | 0 |
326662 | 326662 | 2020-07-12 | Stone | Missouri | 29209 | 22 | 0 |
323479 | 323479 | 2020-07-11 | Stone | Missouri | 29209 | 22 | 0 |
320300 | 320300 | 2020-07-10 | Stone | Missouri | 29209 | 22 | 0 |
317125 | 317125 | 2020-07-09 | Stone | Missouri | 29209 | 21 | 0 |
313951 | 313951 | 2020-07-08 | Stone | Missouri | 29209 | 21 | 0 |
310780 | 310780 | 2020-07-07 | Stone | Missouri | 29209 | 19 | 0 |
307612 | 307612 | 2020-07-06 | Stone | Missouri | 29209 | 20 | 0 |
304445 | 304445 | 2020-07-05 | Stone | Missouri | 29209 | 20 | 0 |
301281 | 301281 | 2020-07-04 | Stone | Missouri | 29209 | 20 | 0 |
298118 | 298118 | 2020-07-03 | Stone | Missouri | 29209 | 20 | 0 |
294960 | 294960 | 2020-07-02 | Stone | Missouri | 29209 | 16 | 0 |
291806 | 291806 | 2020-07-01 | Stone | Missouri | 29209 | 14 | 0 |
288655 | 288655 | 2020-06-30 | Stone | Missouri | 29209 | 14 | 0 |
285505 | 285505 | 2020-06-29 | Stone | Missouri | 29209 | 14 | 0 |
282360 | 282360 | 2020-06-28 | Stone | Missouri | 29209 | 13 | 0 |
279212 | 279212 | 2020-06-27 | Stone | Missouri | 29209 | 12 | 0 |
276064 | 276064 | 2020-06-26 | Stone | Missouri | 29209 | 12 | 0 |
272921 | 272921 | 2020-06-25 | Stone | Missouri | 29209 | 11 | 0 |
269782 | 269782 | 2020-06-24 | Stone | Missouri | 29209 | 11 | 0 |
266649 | 266649 | 2020-06-23 | Stone | Missouri | 29209 | 11 | 0 |
263523 | 263523 | 2020-06-22 | Stone | Missouri | 29209 | 10 | 0 |
260395 | 260395 | 2020-06-21 | Stone | Missouri | 29209 | 10 | 0 |
257269 | 257269 | 2020-06-20 | Stone | Missouri | 29209 | 10 | 0 |
254148 | 254148 | 2020-06-19 | Stone | Missouri | 29209 | 10 | 0 |
251033 | 251033 | 2020-06-18 | Stone | Missouri | 29209 | 8 | 0 |
247920 | 247920 | 2020-06-17 | Stone | Missouri | 29209 | 7 | 0 |
244807 | 244807 | 2020-06-16 | Stone | Missouri | 29209 | 7 | 0 |
241696 | 241696 | 2020-06-15 | Stone | Missouri | 29209 | 7 | 0 |
238586 | 238586 | 2020-06-14 | Stone | Missouri | 29209 | 7 | 0 |
235479 | 235479 | 2020-06-13 | Stone | Missouri | 29209 | 7 | 0 |
232373 | 232373 | 2020-06-12 | Stone | Missouri | 29209 | 7 | 0 |
229269 | 229269 | 2020-06-11 | Stone | Missouri | 29209 | 7 | 0 |
226166 | 226166 | 2020-06-10 | Stone | Missouri | 29209 | 7 | 0 |
223067 | 223067 | 2020-06-09 | Stone | Missouri | 29209 | 8 | 0 |
219972 | 219972 | 2020-06-08 | Stone | Missouri | 29209 | 8 | 0 |
216880 | 216880 | 2020-06-07 | Stone | Missouri | 29209 | 8 | 0 |
213791 | 213791 | 2020-06-06 | Stone | Missouri | 29209 | 8 | 0 |
210707 | 210707 | 2020-06-05 | Stone | Missouri | 29209 | 9 | 0 |
207626 | 207626 | 2020-06-04 | Stone | Missouri | 29209 | 10 | 0 |
204545 | 204545 | 2020-06-03 | Stone | Missouri | 29209 | 5 | 0 |
201468 | 201468 | 2020-06-02 | Stone | Missouri | 29209 | 5 | 0 |
198395 | 198395 | 2020-06-01 | Stone | Missouri | 29209 | 4 | 0 |
195324 | 195324 | 2020-05-31 | Stone | Missouri | 29209 | 4 | 0 |
192254 | 192254 | 2020-05-30 | Stone | Missouri | 29209 | 4 | 0 |
189190 | 189190 | 2020-05-29 | Stone | Missouri | 29209 | 4 | 0 |
186132 | 186132 | 2020-05-28 | Stone | Missouri | 29209 | 4 | 0 |
183076 | 183076 | 2020-05-27 | Stone | Missouri | 29209 | 4 | 0 |
180028 | 180028 | 2020-05-26 | Stone | Missouri | 29209 | 4 | 0 |
176984 | 176984 | 2020-05-25 | Stone | Missouri | 29209 | 4 | 0 |
173941 | 173941 | 2020-05-24 | Stone | Missouri | 29209 | 4 | 0 |
170899 | 170899 | 2020-05-23 | Stone | Missouri | 29209 | 4 | 0 |
167860 | 167860 | 2020-05-22 | Stone | Missouri | 29209 | 4 | 0 |
164824 | 164824 | 2020-05-21 | Stone | Missouri | 29209 | 4 | 0 |
161795 | 161795 | 2020-05-20 | Stone | Missouri | 29209 | 4 | 0 |
158769 | 158769 | 2020-05-19 | Stone | Missouri | 29209 | 4 | 0 |
155751 | 155751 | 2020-05-18 | Stone | Missouri | 29209 | 4 | 0 |
152737 | 152737 | 2020-05-17 | Stone | Missouri | 29209 | 3 | 0 |
149726 | 149726 | 2020-05-16 | Stone | Missouri | 29209 | 3 | 0 |
146720 | 146720 | 2020-05-15 | Stone | Missouri | 29209 | 3 | 0 |
143719 | 143719 | 2020-05-14 | Stone | Missouri | 29209 | 3 | 0 |
140724 | 140724 | 2020-05-13 | Stone | Missouri | 29209 | 3 | 0 |
137730 | 137730 | 2020-05-12 | Stone | Missouri | 29209 | 3 | 0 |
134740 | 134740 | 2020-05-11 | Stone | Missouri | 29209 | 3 | 0 |
131749 | 131749 | 2020-05-10 | Stone | Missouri | 29209 | 3 | 0 |
128759 | 128759 | 2020-05-09 | Stone | Missouri | 29209 | 3 | 0 |
125771 | 125771 | 2020-05-08 | Stone | Missouri | 29209 | 3 | 0 |
122789 | 122789 | 2020-05-07 | Stone | Missouri | 29209 | 3 | 0 |
119815 | 119815 | 2020-05-06 | Stone | Missouri | 29209 | 3 | 0 |
116855 | 116855 | 2020-05-05 | Stone | Missouri | 29209 | 3 | 0 |
113973 | 113973 | 2020-05-04 | Stone | Missouri | 29209 | 3 | 0 |
111094 | 111094 | 2020-05-03 | Stone | Missouri | 29209 | 3 | 0 |
108222 | 108222 | 2020-05-02 | Stone | Missouri | 29209 | 3 | 0 |
105357 | 105357 | 2020-05-01 | Stone | Missouri | 29209 | 3 | 0 |
102496 | 102496 | 2020-04-30 | Stone | Missouri | 29209 | 3 | 0 |
99644 | 99644 | 2020-04-29 | Stone | Missouri | 29209 | 3 | 0 |
96798 | 96798 | 2020-04-28 | Stone | Missouri | 29209 | 3 | 0 |
93962 | 93962 | 2020-04-27 | Stone | Missouri | 29209 | 3 | 0 |
91141 | 91141 | 2020-04-26 | Stone | Missouri | 29209 | 3 | 0 |
88325 | 88325 | 2020-04-25 | Stone | Missouri | 29209 | 3 | 0 |
85515 | 85515 | 2020-04-24 | Stone | Missouri | 29209 | 3 | 0 |
82711 | 82711 | 2020-04-23 | Stone | Missouri | 29209 | 3 | 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);