ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rapides" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535580 | 535580 | 2020-09-15 | Rapides | Louisiana | 22079 | 4017 | 139 |
532345 | 532345 | 2020-09-14 | Rapides | Louisiana | 22079 | 4018 | 139 |
529108 | 529108 | 2020-09-13 | Rapides | Louisiana | 22079 | 4010 | 139 |
525872 | 525872 | 2020-09-12 | Rapides | Louisiana | 22079 | 3988 | 137 |
522636 | 522636 | 2020-09-11 | Rapides | Louisiana | 22079 | 3988 | 137 |
519399 | 519399 | 2020-09-10 | Rapides | Louisiana | 22079 | 3961 | 136 |
516164 | 516164 | 2020-09-09 | Rapides | Louisiana | 22079 | 3947 | 136 |
512931 | 512931 | 2020-09-08 | Rapides | Louisiana | 22079 | 3916 | 136 |
509699 | 509699 | 2020-09-07 | Rapides | Louisiana | 22079 | 3914 | 135 |
506466 | 506466 | 2020-09-06 | Rapides | Louisiana | 22079 | 3899 | 135 |
503232 | 503232 | 2020-09-05 | Rapides | Louisiana | 22079 | 3875 | 135 |
499999 | 499999 | 2020-09-04 | Rapides | Louisiana | 22079 | 3875 | 135 |
496765 | 496765 | 2020-09-03 | Rapides | Louisiana | 22079 | 3856 | 135 |
493532 | 493532 | 2020-09-02 | Rapides | Louisiana | 22079 | 3849 | 135 |
490298 | 490298 | 2020-09-01 | Rapides | Louisiana | 22079 | 3839 | 135 |
487065 | 487065 | 2020-08-31 | Rapides | Louisiana | 22079 | 3833 | 135 |
483830 | 483830 | 2020-08-30 | Rapides | Louisiana | 22079 | 3827 | 135 |
480596 | 480596 | 2020-08-29 | Rapides | Louisiana | 22079 | 3742 | 135 |
477363 | 477363 | 2020-08-28 | Rapides | Louisiana | 22079 | 3742 | 135 |
474130 | 474130 | 2020-08-27 | Rapides | Louisiana | 22079 | 3711 | 134 |
470898 | 470898 | 2020-08-26 | Rapides | Louisiana | 22079 | 3691 | 134 |
467669 | 467669 | 2020-08-25 | Rapides | Louisiana | 22079 | 3679 | 133 |
464440 | 464440 | 2020-08-24 | Rapides | Louisiana | 22079 | 3703 | 131 |
461209 | 461209 | 2020-08-23 | Rapides | Louisiana | 22079 | 3682 | 131 |
457982 | 457982 | 2020-08-22 | Rapides | Louisiana | 22079 | 3642 | 130 |
454754 | 454754 | 2020-08-21 | Rapides | Louisiana | 22079 | 3642 | 130 |
451526 | 451526 | 2020-08-20 | Rapides | Louisiana | 22079 | 3597 | 130 |
448298 | 448298 | 2020-08-19 | Rapides | Louisiana | 22079 | 3522 | 129 |
445071 | 445071 | 2020-08-18 | Rapides | Louisiana | 22079 | 3499 | 128 |
441845 | 441845 | 2020-08-17 | Rapides | Louisiana | 22079 | 3472 | 128 |
438618 | 438618 | 2020-08-16 | Rapides | Louisiana | 22079 | 3472 | 127 |
435393 | 435393 | 2020-08-15 | Rapides | Louisiana | 22079 | 3447 | 123 |
432168 | 432168 | 2020-08-14 | Rapides | Louisiana | 22079 | 3447 | 123 |
428940 | 428940 | 2020-08-13 | Rapides | Louisiana | 22079 | 3410 | 122 |
425716 | 425716 | 2020-08-12 | Rapides | Louisiana | 22079 | 3380 | 119 |
422495 | 422495 | 2020-08-11 | Rapides | Louisiana | 22079 | 3327 | 114 |
419273 | 419273 | 2020-08-10 | Rapides | Louisiana | 22079 | 3304 | 114 |
416052 | 416052 | 2020-08-09 | Rapides | Louisiana | 22079 | 3290 | 114 |
412832 | 412832 | 2020-08-08 | Rapides | Louisiana | 22079 | 3223 | 114 |
409612 | 409612 | 2020-08-07 | Rapides | Louisiana | 22079 | 3223 | 114 |
406392 | 406392 | 2020-08-06 | Rapides | Louisiana | 22079 | 3194 | 112 |
403174 | 403174 | 2020-08-05 | Rapides | Louisiana | 22079 | 3155 | 111 |
399957 | 399957 | 2020-08-04 | Rapides | Louisiana | 22079 | 3126 | 107 |
396742 | 396742 | 2020-08-03 | Rapides | Louisiana | 22079 | 3068 | 106 |
393526 | 393526 | 2020-08-02 | Rapides | Louisiana | 22079 | 3037 | 104 |
390309 | 390309 | 2020-08-01 | Rapides | Louisiana | 22079 | 2945 | 102 |
387092 | 387092 | 2020-07-31 | Rapides | Louisiana | 22079 | 2945 | 102 |
383874 | 383874 | 2020-07-30 | Rapides | Louisiana | 22079 | 2901 | 101 |
380657 | 380657 | 2020-07-29 | Rapides | Louisiana | 22079 | 2817 | 100 |
377440 | 377440 | 2020-07-28 | Rapides | Louisiana | 22079 | 2786 | 98 |
374225 | 374225 | 2020-07-27 | Rapides | Louisiana | 22079 | 2743 | 98 |
371013 | 371013 | 2020-07-26 | Rapides | Louisiana | 22079 | 2687 | 98 |
367803 | 367803 | 2020-07-25 | Rapides | Louisiana | 22079 | 2585 | 96 |
364596 | 364596 | 2020-07-24 | Rapides | Louisiana | 22079 | 2585 | 96 |
361389 | 361389 | 2020-07-23 | Rapides | Louisiana | 22079 | 2538 | 94 |
358184 | 358184 | 2020-07-22 | Rapides | Louisiana | 22079 | 2492 | 94 |
354981 | 354981 | 2020-07-21 | Rapides | Louisiana | 22079 | 2429 | 92 |
351779 | 351779 | 2020-07-20 | Rapides | Louisiana | 22079 | 2371 | 90 |
348579 | 348579 | 2020-07-19 | Rapides | Louisiana | 22079 | 2278 | 85 |
345378 | 345378 | 2020-07-18 | Rapides | Louisiana | 22079 | 2201 | 83 |
342178 | 342178 | 2020-07-17 | Rapides | Louisiana | 22079 | 2201 | 83 |
338982 | 338982 | 2020-07-16 | Rapides | Louisiana | 22079 | 2159 | 81 |
335786 | 335786 | 2020-07-15 | Rapides | Louisiana | 22079 | 2104 | 81 |
332593 | 332593 | 2020-07-14 | Rapides | Louisiana | 22079 | 2059 | 79 |
329406 | 329406 | 2020-07-13 | Rapides | Louisiana | 22079 | 2019 | 79 |
326220 | 326220 | 2020-07-12 | Rapides | Louisiana | 22079 | 2001 | 79 |
323037 | 323037 | 2020-07-11 | Rapides | Louisiana | 22079 | 1978 | 79 |
319858 | 319858 | 2020-07-10 | Rapides | Louisiana | 22079 | 1909 | 79 |
316683 | 316683 | 2020-07-09 | Rapides | Louisiana | 22079 | 1870 | 76 |
313509 | 313509 | 2020-07-08 | Rapides | Louisiana | 22079 | 1823 | 75 |
310339 | 310339 | 2020-07-07 | Rapides | Louisiana | 22079 | 1759 | 72 |
307171 | 307171 | 2020-07-06 | Rapides | Louisiana | 22079 | 1689 | 68 |
304004 | 304004 | 2020-07-05 | Rapides | Louisiana | 22079 | 1678 | 67 |
300840 | 300840 | 2020-07-04 | Rapides | Louisiana | 22079 | 1653 | 66 |
297678 | 297678 | 2020-07-03 | Rapides | Louisiana | 22079 | 1653 | 66 |
294520 | 294520 | 2020-07-02 | Rapides | Louisiana | 22079 | 1597 | 65 |
291366 | 291366 | 2020-07-01 | Rapides | Louisiana | 22079 | 1578 | 62 |
288215 | 288215 | 2020-06-30 | Rapides | Louisiana | 22079 | 1536 | 59 |
285066 | 285066 | 2020-06-29 | Rapides | Louisiana | 22079 | 1499 | 57 |
281920 | 281920 | 2020-06-28 | Rapides | Louisiana | 22079 | 1498 | 57 |
278772 | 278772 | 2020-06-27 | Rapides | Louisiana | 22079 | 1453 | 57 |
275624 | 275624 | 2020-06-26 | Rapides | Louisiana | 22079 | 1453 | 57 |
272481 | 272481 | 2020-06-25 | Rapides | Louisiana | 22079 | 1423 | 56 |
269345 | 269345 | 2020-06-24 | Rapides | Louisiana | 22079 | 1408 | 55 |
266212 | 266212 | 2020-06-23 | Rapides | Louisiana | 22079 | 1358 | 53 |
263085 | 263085 | 2020-06-22 | Rapides | Louisiana | 22079 | 1323 | 51 |
259956 | 259956 | 2020-06-21 | Rapides | Louisiana | 22079 | 1320 | 50 |
256830 | 256830 | 2020-06-20 | Rapides | Louisiana | 22079 | 1312 | 50 |
253710 | 253710 | 2020-06-19 | Rapides | Louisiana | 22079 | 1290 | 48 |
250595 | 250595 | 2020-06-18 | Rapides | Louisiana | 22079 | 1229 | 47 |
247483 | 247483 | 2020-06-17 | Rapides | Louisiana | 22079 | 1229 | 47 |
244370 | 244370 | 2020-06-16 | Rapides | Louisiana | 22079 | 1209 | 45 |
241259 | 241259 | 2020-06-15 | Rapides | Louisiana | 22079 | 1193 | 41 |
238150 | 238150 | 2020-06-14 | Rapides | Louisiana | 22079 | 1145 | 41 |
235043 | 235043 | 2020-06-13 | Rapides | Louisiana | 22079 | 1132 | 41 |
231938 | 231938 | 2020-06-12 | Rapides | Louisiana | 22079 | 1098 | 41 |
228834 | 228834 | 2020-06-11 | Rapides | Louisiana | 22079 | 1074 | 41 |
225732 | 225732 | 2020-06-10 | Rapides | Louisiana | 22079 | 1007 | 41 |
222636 | 222636 | 2020-06-09 | Rapides | Louisiana | 22079 | 992 | 38 |
219541 | 219541 | 2020-06-08 | Rapides | Louisiana | 22079 | 975 | 38 |
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);