ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tangipahoa" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535593 | 535593 | 2020-09-15 | Tangipahoa | Louisiana | 22105 | 4307 | 111 |
532358 | 532358 | 2020-09-14 | Tangipahoa | Louisiana | 22105 | 4292 | 111 |
529121 | 529121 | 2020-09-13 | Tangipahoa | Louisiana | 22105 | 4278 | 109 |
525885 | 525885 | 2020-09-12 | Tangipahoa | Louisiana | 22105 | 4255 | 108 |
522649 | 522649 | 2020-09-11 | Tangipahoa | Louisiana | 22105 | 4255 | 108 |
519412 | 519412 | 2020-09-10 | Tangipahoa | Louisiana | 22105 | 4239 | 107 |
516177 | 516177 | 2020-09-09 | Tangipahoa | Louisiana | 22105 | 4217 | 107 |
512944 | 512944 | 2020-09-08 | Tangipahoa | Louisiana | 22105 | 4173 | 107 |
509712 | 509712 | 2020-09-07 | Tangipahoa | Louisiana | 22105 | 4181 | 107 |
506479 | 506479 | 2020-09-06 | Tangipahoa | Louisiana | 22105 | 4168 | 107 |
503245 | 503245 | 2020-09-05 | Tangipahoa | Louisiana | 22105 | 4134 | 104 |
500012 | 500012 | 2020-09-04 | Tangipahoa | Louisiana | 22105 | 4134 | 104 |
496778 | 496778 | 2020-09-03 | Tangipahoa | Louisiana | 22105 | 4098 | 103 |
493545 | 493545 | 2020-09-02 | Tangipahoa | Louisiana | 22105 | 4095 | 102 |
490311 | 490311 | 2020-09-01 | Tangipahoa | Louisiana | 22105 | 4071 | 98 |
487078 | 487078 | 2020-08-31 | Tangipahoa | Louisiana | 22105 | 4046 | 98 |
483843 | 483843 | 2020-08-30 | Tangipahoa | Louisiana | 22105 | 4030 | 97 |
480609 | 480609 | 2020-08-29 | Tangipahoa | Louisiana | 22105 | 3985 | 94 |
477376 | 477376 | 2020-08-28 | Tangipahoa | Louisiana | 22105 | 3985 | 94 |
474143 | 474143 | 2020-08-27 | Tangipahoa | Louisiana | 22105 | 3965 | 91 |
470911 | 470911 | 2020-08-26 | Tangipahoa | Louisiana | 22105 | 3956 | 90 |
467682 | 467682 | 2020-08-25 | Tangipahoa | Louisiana | 22105 | 3939 | 90 |
464453 | 464453 | 2020-08-24 | Tangipahoa | Louisiana | 22105 | 3959 | 88 |
461222 | 461222 | 2020-08-23 | Tangipahoa | Louisiana | 22105 | 3934 | 88 |
457995 | 457995 | 2020-08-22 | Tangipahoa | Louisiana | 22105 | 3899 | 88 |
454767 | 454767 | 2020-08-21 | Tangipahoa | Louisiana | 22105 | 3899 | 88 |
451539 | 451539 | 2020-08-20 | Tangipahoa | Louisiana | 22105 | 3868 | 87 |
448311 | 448311 | 2020-08-19 | Tangipahoa | Louisiana | 22105 | 3826 | 87 |
445084 | 445084 | 2020-08-18 | Tangipahoa | Louisiana | 22105 | 3798 | 85 |
441858 | 441858 | 2020-08-17 | Tangipahoa | Louisiana | 22105 | 3756 | 83 |
438631 | 438631 | 2020-08-16 | Tangipahoa | Louisiana | 22105 | 3710 | 83 |
435406 | 435406 | 2020-08-15 | Tangipahoa | Louisiana | 22105 | 3664 | 80 |
432181 | 432181 | 2020-08-14 | Tangipahoa | Louisiana | 22105 | 3664 | 80 |
428953 | 428953 | 2020-08-13 | Tangipahoa | Louisiana | 22105 | 3619 | 78 |
425729 | 425729 | 2020-08-12 | Tangipahoa | Louisiana | 22105 | 3570 | 78 |
422508 | 422508 | 2020-08-11 | Tangipahoa | Louisiana | 22105 | 3540 | 78 |
419286 | 419286 | 2020-08-10 | Tangipahoa | Louisiana | 22105 | 3498 | 77 |
416065 | 416065 | 2020-08-09 | Tangipahoa | Louisiana | 22105 | 3477 | 75 |
412845 | 412845 | 2020-08-08 | Tangipahoa | Louisiana | 22105 | 3397 | 72 |
409625 | 409625 | 2020-08-07 | Tangipahoa | Louisiana | 22105 | 3397 | 72 |
406405 | 406405 | 2020-08-06 | Tangipahoa | Louisiana | 22105 | 3332 | 69 |
403187 | 403187 | 2020-08-05 | Tangipahoa | Louisiana | 22105 | 3291 | 69 |
399970 | 399970 | 2020-08-04 | Tangipahoa | Louisiana | 22105 | 3223 | 63 |
396755 | 396755 | 2020-08-03 | Tangipahoa | Louisiana | 22105 | 3159 | 63 |
393539 | 393539 | 2020-08-02 | Tangipahoa | Louisiana | 22105 | 3137 | 63 |
390322 | 390322 | 2020-08-01 | Tangipahoa | Louisiana | 22105 | 3037 | 62 |
387105 | 387105 | 2020-07-31 | Tangipahoa | Louisiana | 22105 | 3037 | 62 |
383887 | 383887 | 2020-07-30 | Tangipahoa | Louisiana | 22105 | 3001 | 61 |
380670 | 380670 | 2020-07-29 | Tangipahoa | Louisiana | 22105 | 2955 | 58 |
377453 | 377453 | 2020-07-28 | Tangipahoa | Louisiana | 22105 | 2916 | 58 |
374238 | 374238 | 2020-07-27 | Tangipahoa | Louisiana | 22105 | 2895 | 56 |
371026 | 371026 | 2020-07-26 | Tangipahoa | Louisiana | 22105 | 2777 | 56 |
367816 | 367816 | 2020-07-25 | Tangipahoa | Louisiana | 22105 | 2692 | 54 |
364609 | 364609 | 2020-07-24 | Tangipahoa | Louisiana | 22105 | 2692 | 54 |
361402 | 361402 | 2020-07-23 | Tangipahoa | Louisiana | 22105 | 2624 | 53 |
358197 | 358197 | 2020-07-22 | Tangipahoa | Louisiana | 22105 | 2536 | 53 |
354994 | 354994 | 2020-07-21 | Tangipahoa | Louisiana | 22105 | 2464 | 47 |
351792 | 351792 | 2020-07-20 | Tangipahoa | Louisiana | 22105 | 2447 | 47 |
348592 | 348592 | 2020-07-19 | Tangipahoa | Louisiana | 22105 | 2300 | 47 |
345391 | 345391 | 2020-07-18 | Tangipahoa | Louisiana | 22105 | 2217 | 46 |
342191 | 342191 | 2020-07-17 | Tangipahoa | Louisiana | 22105 | 2217 | 46 |
338995 | 338995 | 2020-07-16 | Tangipahoa | Louisiana | 22105 | 2142 | 46 |
335799 | 335799 | 2020-07-15 | Tangipahoa | Louisiana | 22105 | 2081 | 45 |
332606 | 332606 | 2020-07-14 | Tangipahoa | Louisiana | 22105 | 2020 | 44 |
329419 | 329419 | 2020-07-13 | Tangipahoa | Louisiana | 22105 | 1914 | 44 |
326233 | 326233 | 2020-07-12 | Tangipahoa | Louisiana | 22105 | 1894 | 44 |
323050 | 323050 | 2020-07-11 | Tangipahoa | Louisiana | 22105 | 1874 | 44 |
319871 | 319871 | 2020-07-10 | Tangipahoa | Louisiana | 22105 | 1802 | 44 |
316696 | 316696 | 2020-07-09 | Tangipahoa | Louisiana | 22105 | 1742 | 43 |
313522 | 313522 | 2020-07-08 | Tangipahoa | Louisiana | 22105 | 1689 | 43 |
310352 | 310352 | 2020-07-07 | Tangipahoa | Louisiana | 22105 | 1624 | 43 |
307184 | 307184 | 2020-07-06 | Tangipahoa | Louisiana | 22105 | 1541 | 43 |
304017 | 304017 | 2020-07-05 | Tangipahoa | Louisiana | 22105 | 1513 | 43 |
300853 | 300853 | 2020-07-04 | Tangipahoa | Louisiana | 22105 | 1462 | 43 |
297691 | 297691 | 2020-07-03 | Tangipahoa | Louisiana | 22105 | 1462 | 43 |
294533 | 294533 | 2020-07-02 | Tangipahoa | Louisiana | 22105 | 1394 | 43 |
291379 | 291379 | 2020-07-01 | Tangipahoa | Louisiana | 22105 | 1353 | 43 |
288228 | 288228 | 2020-06-30 | Tangipahoa | Louisiana | 22105 | 1304 | 43 |
285079 | 285079 | 2020-06-29 | Tangipahoa | Louisiana | 22105 | 1295 | 43 |
281933 | 281933 | 2020-06-28 | Tangipahoa | Louisiana | 22105 | 1273 | 43 |
278785 | 278785 | 2020-06-27 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
275637 | 275637 | 2020-06-26 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
272494 | 272494 | 2020-06-25 | Tangipahoa | Louisiana | 22105 | 1218 | 43 |
269358 | 269358 | 2020-06-24 | Tangipahoa | Louisiana | 22105 | 1184 | 43 |
266225 | 266225 | 2020-06-23 | Tangipahoa | Louisiana | 22105 | 1163 | 42 |
263098 | 263098 | 2020-06-22 | Tangipahoa | Louisiana | 22105 | 1123 | 42 |
259969 | 259969 | 2020-06-21 | Tangipahoa | Louisiana | 22105 | 1120 | 42 |
256843 | 256843 | 2020-06-20 | Tangipahoa | Louisiana | 22105 | 1112 | 42 |
253723 | 253723 | 2020-06-19 | Tangipahoa | Louisiana | 22105 | 1078 | 42 |
250608 | 250608 | 2020-06-18 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
247496 | 247496 | 2020-06-17 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
244383 | 244383 | 2020-06-16 | Tangipahoa | Louisiana | 22105 | 1062 | 42 |
241272 | 241272 | 2020-06-15 | Tangipahoa | Louisiana | 22105 | 1048 | 42 |
238163 | 238163 | 2020-06-14 | Tangipahoa | Louisiana | 22105 | 1042 | 42 |
235056 | 235056 | 2020-06-13 | Tangipahoa | Louisiana | 22105 | 1039 | 42 |
231951 | 231951 | 2020-06-12 | Tangipahoa | Louisiana | 22105 | 1001 | 42 |
228847 | 228847 | 2020-06-11 | Tangipahoa | Louisiana | 22105 | 984 | 42 |
225745 | 225745 | 2020-06-10 | Tangipahoa | Louisiana | 22105 | 973 | 41 |
222649 | 222649 | 2020-06-09 | Tangipahoa | Louisiana | 22105 | 965 | 39 |
219554 | 219554 | 2020-06-08 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
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);