ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Boone" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535925 | 535925 | 2020-09-15 | Boone | Missouri | 29019 | 4182 | 7 |
532690 | 532690 | 2020-09-14 | Boone | Missouri | 29019 | 4131 | 7 |
529454 | 529454 | 2020-09-13 | Boone | Missouri | 29019 | 4071 | 7 |
526218 | 526218 | 2020-09-12 | Boone | Missouri | 29019 | 3918 | 7 |
522982 | 522982 | 2020-09-11 | Boone | Missouri | 29019 | 3780 | 7 |
519745 | 519745 | 2020-09-10 | Boone | Missouri | 29019 | 3695 | 7 |
516510 | 516510 | 2020-09-09 | Boone | Missouri | 29019 | 3627 | 7 |
513276 | 513276 | 2020-09-08 | Boone | Missouri | 29019 | 3568 | 7 |
510044 | 510044 | 2020-09-07 | Boone | Missouri | 29019 | 3524 | 7 |
506811 | 506811 | 2020-09-06 | Boone | Missouri | 29019 | 3473 | 7 |
503578 | 503578 | 2020-09-05 | Boone | Missouri | 29019 | 3359 | 7 |
500344 | 500344 | 2020-09-04 | Boone | Missouri | 29019 | 3169 | 7 |
497110 | 497110 | 2020-09-03 | Boone | Missouri | 29019 | 2994 | 7 |
493877 | 493877 | 2020-09-02 | Boone | Missouri | 29019 | 2877 | 7 |
490643 | 490643 | 2020-09-01 | Boone | Missouri | 29019 | 2714 | 7 |
487410 | 487410 | 2020-08-31 | Boone | Missouri | 29019 | 2618 | 7 |
484176 | 484176 | 2020-08-30 | Boone | Missouri | 29019 | 2532 | 7 |
480941 | 480941 | 2020-08-29 | Boone | Missouri | 29019 | 2447 | 7 |
477709 | 477709 | 2020-08-28 | Boone | Missouri | 29019 | 2316 | 7 |
474476 | 474476 | 2020-08-27 | Boone | Missouri | 29019 | 2235 | 7 |
471244 | 471244 | 2020-08-26 | Boone | Missouri | 29019 | 2152 | 7 |
468014 | 468014 | 2020-08-25 | Boone | Missouri | 29019 | 2065 | 6 |
464785 | 464785 | 2020-08-24 | Boone | Missouri | 29019 | 1995 | 6 |
461554 | 461554 | 2020-08-23 | Boone | Missouri | 29019 | 1964 | 5 |
458327 | 458327 | 2020-08-22 | Boone | Missouri | 29019 | 1923 | 5 |
455099 | 455099 | 2020-08-21 | Boone | Missouri | 29019 | 1845 | 5 |
451871 | 451871 | 2020-08-20 | Boone | Missouri | 29019 | 1764 | 5 |
448643 | 448643 | 2020-08-19 | Boone | Missouri | 29019 | 1704 | 5 |
445417 | 445417 | 2020-08-18 | Boone | Missouri | 29019 | 1641 | 5 |
442191 | 442191 | 2020-08-17 | Boone | Missouri | 29019 | 1619 | 5 |
438964 | 438964 | 2020-08-16 | Boone | Missouri | 29019 | 1594 | 5 |
435739 | 435739 | 2020-08-15 | Boone | Missouri | 29019 | 1587 | 5 |
432513 | 432513 | 2020-08-14 | Boone | Missouri | 29019 | 1537 | 5 |
429286 | 429286 | 2020-08-13 | Boone | Missouri | 29019 | 1503 | 5 |
426062 | 426062 | 2020-08-12 | Boone | Missouri | 29019 | 1478 | 5 |
422840 | 422840 | 2020-08-11 | Boone | Missouri | 29019 | 1462 | 5 |
419618 | 419618 | 2020-08-10 | Boone | Missouri | 29019 | 1429 | 5 |
416397 | 416397 | 2020-08-09 | Boone | Missouri | 29019 | 1408 | 5 |
413177 | 413177 | 2020-08-08 | Boone | Missouri | 29019 | 1398 | 5 |
409957 | 409957 | 2020-08-07 | Boone | Missouri | 29019 | 1345 | 5 |
406737 | 406737 | 2020-08-06 | Boone | Missouri | 29019 | 1318 | 4 |
403519 | 403519 | 2020-08-05 | Boone | Missouri | 29019 | 1302 | 4 |
400302 | 400302 | 2020-08-04 | Boone | Missouri | 29019 | 1281 | 4 |
397088 | 397088 | 2020-08-03 | Boone | Missouri | 29019 | 1261 | 4 |
393872 | 393872 | 2020-08-02 | Boone | Missouri | 29019 | 1251 | 4 |
390655 | 390655 | 2020-08-01 | Boone | Missouri | 29019 | 1235 | 4 |
387438 | 387438 | 2020-07-31 | Boone | Missouri | 29019 | 1174 | 4 |
384220 | 384220 | 2020-07-30 | Boone | Missouri | 29019 | 1146 | 3 |
381004 | 381004 | 2020-07-29 | Boone | Missouri | 29019 | 1118 | 3 |
377787 | 377787 | 2020-07-28 | Boone | Missouri | 29019 | 1090 | 3 |
374572 | 374572 | 2020-07-27 | Boone | Missouri | 29019 | 1061 | 3 |
371360 | 371360 | 2020-07-26 | Boone | Missouri | 29019 | 1051 | 3 |
368149 | 368149 | 2020-07-25 | Boone | Missouri | 29019 | 1039 | 3 |
364941 | 364941 | 2020-07-24 | Boone | Missouri | 29019 | 1003 | 3 |
361734 | 361734 | 2020-07-23 | Boone | Missouri | 29019 | 978 | 3 |
358529 | 358529 | 2020-07-22 | Boone | Missouri | 29019 | 953 | 3 |
355326 | 355326 | 2020-07-21 | Boone | Missouri | 29019 | 927 | 3 |
352124 | 352124 | 2020-07-20 | Boone | Missouri | 29019 | 901 | 3 |
348924 | 348924 | 2020-07-19 | Boone | Missouri | 29019 | 892 | 3 |
345723 | 345723 | 2020-07-18 | Boone | Missouri | 29019 | 871 | 3 |
342523 | 342523 | 2020-07-17 | Boone | Missouri | 29019 | 843 | 3 |
339327 | 339327 | 2020-07-16 | Boone | Missouri | 29019 | 821 | 3 |
336131 | 336131 | 2020-07-15 | Boone | Missouri | 29019 | 800 | 3 |
332938 | 332938 | 2020-07-14 | Boone | Missouri | 29019 | 777 | 3 |
329751 | 329751 | 2020-07-13 | Boone | Missouri | 29019 | 764 | 3 |
326565 | 326565 | 2020-07-12 | Boone | Missouri | 29019 | 758 | 2 |
323382 | 323382 | 2020-07-11 | Boone | Missouri | 29019 | 726 | 2 |
320203 | 320203 | 2020-07-10 | Boone | Missouri | 29019 | 670 | 2 |
317028 | 317028 | 2020-07-09 | Boone | Missouri | 29019 | 639 | 2 |
313854 | 313854 | 2020-07-08 | Boone | Missouri | 29019 | 597 | 2 |
310684 | 310684 | 2020-07-07 | Boone | Missouri | 29019 | 547 | 2 |
307516 | 307516 | 2020-07-06 | Boone | Missouri | 29019 | 513 | 2 |
304349 | 304349 | 2020-07-05 | Boone | Missouri | 29019 | 498 | 2 |
301185 | 301185 | 2020-07-04 | Boone | Missouri | 29019 | 478 | 2 |
298022 | 298022 | 2020-07-03 | Boone | Missouri | 29019 | 460 | 2 |
294864 | 294864 | 2020-07-02 | Boone | Missouri | 29019 | 429 | 2 |
291710 | 291710 | 2020-07-01 | Boone | Missouri | 29019 | 390 | 2 |
288559 | 288559 | 2020-06-30 | Boone | Missouri | 29019 | 379 | 2 |
285409 | 285409 | 2020-06-29 | Boone | Missouri | 29019 | 354 | 2 |
282264 | 282264 | 2020-06-28 | Boone | Missouri | 29019 | 353 | 2 |
279116 | 279116 | 2020-06-27 | Boone | Missouri | 29019 | 342 | 2 |
275968 | 275968 | 2020-06-26 | Boone | Missouri | 29019 | 334 | 2 |
272825 | 272825 | 2020-06-25 | Boone | Missouri | 29019 | 319 | 2 |
269687 | 269687 | 2020-06-24 | Boone | Missouri | 29019 | 288 | 2 |
266554 | 266554 | 2020-06-23 | Boone | Missouri | 29019 | 280 | 2 |
263428 | 263428 | 2020-06-22 | Boone | Missouri | 29019 | 266 | 2 |
260300 | 260300 | 2020-06-21 | Boone | Missouri | 29019 | 258 | 2 |
257174 | 257174 | 2020-06-20 | Boone | Missouri | 29019 | 257 | 2 |
254054 | 254054 | 2020-06-19 | Boone | Missouri | 29019 | 246 | 2 |
250939 | 250939 | 2020-06-18 | Boone | Missouri | 29019 | 226 | 2 |
247826 | 247826 | 2020-06-17 | Boone | Missouri | 29019 | 222 | 2 |
244713 | 244713 | 2020-06-16 | Boone | Missouri | 29019 | 216 | 2 |
241602 | 241602 | 2020-06-15 | Boone | Missouri | 29019 | 215 | 2 |
238493 | 238493 | 2020-06-14 | Boone | Missouri | 29019 | 208 | 2 |
235386 | 235386 | 2020-06-13 | Boone | Missouri | 29019 | 208 | 2 |
232280 | 232280 | 2020-06-12 | Boone | Missouri | 29019 | 204 | 2 |
229176 | 229176 | 2020-06-11 | Boone | Missouri | 29019 | 201 | 1 |
226073 | 226073 | 2020-06-10 | Boone | Missouri | 29019 | 197 | 1 |
222975 | 222975 | 2020-06-09 | Boone | Missouri | 29019 | 194 | 1 |
219880 | 219880 | 2020-06-08 | Boone | Missouri | 29019 | 193 | 1 |
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);