ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22009 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535545 | 535545 | 2020-09-15 | Avoyelles | Louisiana | 22009 | 1431 | 49 |
532310 | 532310 | 2020-09-14 | Avoyelles | Louisiana | 22009 | 1426 | 49 |
529073 | 529073 | 2020-09-13 | Avoyelles | Louisiana | 22009 | 1419 | 49 |
525837 | 525837 | 2020-09-12 | Avoyelles | Louisiana | 22009 | 1398 | 49 |
522601 | 522601 | 2020-09-11 | Avoyelles | Louisiana | 22009 | 1398 | 49 |
519364 | 519364 | 2020-09-10 | Avoyelles | Louisiana | 22009 | 1399 | 47 |
516129 | 516129 | 2020-09-09 | Avoyelles | Louisiana | 22009 | 1396 | 47 |
512896 | 512896 | 2020-09-08 | Avoyelles | Louisiana | 22009 | 1335 | 47 |
509664 | 509664 | 2020-09-07 | Avoyelles | Louisiana | 22009 | 1331 | 47 |
506431 | 506431 | 2020-09-06 | Avoyelles | Louisiana | 22009 | 1327 | 47 |
503197 | 503197 | 2020-09-05 | Avoyelles | Louisiana | 22009 | 1320 | 46 |
499964 | 499964 | 2020-09-04 | Avoyelles | Louisiana | 22009 | 1320 | 46 |
496730 | 496730 | 2020-09-03 | Avoyelles | Louisiana | 22009 | 1305 | 46 |
493497 | 493497 | 2020-09-02 | Avoyelles | Louisiana | 22009 | 1303 | 46 |
490263 | 490263 | 2020-09-01 | Avoyelles | Louisiana | 22009 | 1294 | 45 |
487030 | 487030 | 2020-08-31 | Avoyelles | Louisiana | 22009 | 1285 | 45 |
483795 | 483795 | 2020-08-30 | Avoyelles | Louisiana | 22009 | 1279 | 44 |
480561 | 480561 | 2020-08-29 | Avoyelles | Louisiana | 22009 | 1268 | 43 |
477328 | 477328 | 2020-08-28 | Avoyelles | Louisiana | 22009 | 1268 | 43 |
474095 | 474095 | 2020-08-27 | Avoyelles | Louisiana | 22009 | 1261 | 43 |
470863 | 470863 | 2020-08-26 | Avoyelles | Louisiana | 22009 | 1255 | 43 |
467634 | 467634 | 2020-08-25 | Avoyelles | Louisiana | 22009 | 1248 | 43 |
464405 | 464405 | 2020-08-24 | Avoyelles | Louisiana | 22009 | 1218 | 43 |
461174 | 461174 | 2020-08-23 | Avoyelles | Louisiana | 22009 | 1211 | 42 |
457947 | 457947 | 2020-08-22 | Avoyelles | Louisiana | 22009 | 1196 | 40 |
454719 | 454719 | 2020-08-21 | Avoyelles | Louisiana | 22009 | 1196 | 40 |
451491 | 451491 | 2020-08-20 | Avoyelles | Louisiana | 22009 | 1178 | 40 |
448263 | 448263 | 2020-08-19 | Avoyelles | Louisiana | 22009 | 1172 | 40 |
445036 | 445036 | 2020-08-18 | Avoyelles | Louisiana | 22009 | 1157 | 38 |
441810 | 441810 | 2020-08-17 | Avoyelles | Louisiana | 22009 | 1149 | 37 |
438583 | 438583 | 2020-08-16 | Avoyelles | Louisiana | 22009 | 1143 | 37 |
435358 | 435358 | 2020-08-15 | Avoyelles | Louisiana | 22009 | 1138 | 36 |
432133 | 432133 | 2020-08-14 | Avoyelles | Louisiana | 22009 | 1138 | 36 |
428905 | 428905 | 2020-08-13 | Avoyelles | Louisiana | 22009 | 1128 | 34 |
425681 | 425681 | 2020-08-12 | Avoyelles | Louisiana | 22009 | 1107 | 34 |
422460 | 422460 | 2020-08-11 | Avoyelles | Louisiana | 22009 | 1096 | 32 |
419238 | 419238 | 2020-08-10 | Avoyelles | Louisiana | 22009 | 1070 | 32 |
416017 | 416017 | 2020-08-09 | Avoyelles | Louisiana | 22009 | 1070 | 32 |
412797 | 412797 | 2020-08-08 | Avoyelles | Louisiana | 22009 | 1021 | 31 |
409577 | 409577 | 2020-08-07 | Avoyelles | Louisiana | 22009 | 1021 | 31 |
406357 | 406357 | 2020-08-06 | Avoyelles | Louisiana | 22009 | 1002 | 29 |
403139 | 403139 | 2020-08-05 | Avoyelles | Louisiana | 22009 | 987 | 29 |
399922 | 399922 | 2020-08-04 | Avoyelles | Louisiana | 22009 | 981 | 27 |
396707 | 396707 | 2020-08-03 | Avoyelles | Louisiana | 22009 | 951 | 27 |
393491 | 393491 | 2020-08-02 | Avoyelles | Louisiana | 22009 | 939 | 27 |
390274 | 390274 | 2020-08-01 | Avoyelles | Louisiana | 22009 | 907 | 26 |
387057 | 387057 | 2020-07-31 | Avoyelles | Louisiana | 22009 | 907 | 26 |
383839 | 383839 | 2020-07-30 | Avoyelles | Louisiana | 22009 | 895 | 26 |
380622 | 380622 | 2020-07-29 | Avoyelles | Louisiana | 22009 | 867 | 26 |
377405 | 377405 | 2020-07-28 | Avoyelles | Louisiana | 22009 | 851 | 24 |
374190 | 374190 | 2020-07-27 | Avoyelles | Louisiana | 22009 | 842 | 24 |
370978 | 370978 | 2020-07-26 | Avoyelles | Louisiana | 22009 | 827 | 24 |
367768 | 367768 | 2020-07-25 | Avoyelles | Louisiana | 22009 | 781 | 23 |
364561 | 364561 | 2020-07-24 | Avoyelles | Louisiana | 22009 | 781 | 23 |
361354 | 361354 | 2020-07-23 | Avoyelles | Louisiana | 22009 | 754 | 23 |
358149 | 358149 | 2020-07-22 | Avoyelles | Louisiana | 22009 | 741 | 23 |
354946 | 354946 | 2020-07-21 | Avoyelles | Louisiana | 22009 | 699 | 20 |
351744 | 351744 | 2020-07-20 | Avoyelles | Louisiana | 22009 | 655 | 20 |
348544 | 348544 | 2020-07-19 | Avoyelles | Louisiana | 22009 | 619 | 20 |
345343 | 345343 | 2020-07-18 | Avoyelles | Louisiana | 22009 | 588 | 18 |
342143 | 342143 | 2020-07-17 | Avoyelles | Louisiana | 22009 | 588 | 18 |
338947 | 338947 | 2020-07-16 | Avoyelles | Louisiana | 22009 | 565 | 17 |
335751 | 335751 | 2020-07-15 | Avoyelles | Louisiana | 22009 | 549 | 17 |
332558 | 332558 | 2020-07-14 | Avoyelles | Louisiana | 22009 | 512 | 17 |
329371 | 329371 | 2020-07-13 | Avoyelles | Louisiana | 22009 | 489 | 17 |
326185 | 326185 | 2020-07-12 | Avoyelles | Louisiana | 22009 | 482 | 17 |
323002 | 323002 | 2020-07-11 | Avoyelles | Louisiana | 22009 | 475 | 16 |
319823 | 319823 | 2020-07-10 | Avoyelles | Louisiana | 22009 | 460 | 16 |
316648 | 316648 | 2020-07-09 | Avoyelles | Louisiana | 22009 | 447 | 16 |
313474 | 313474 | 2020-07-08 | Avoyelles | Louisiana | 22009 | 418 | 15 |
310304 | 310304 | 2020-07-07 | Avoyelles | Louisiana | 22009 | 402 | 15 |
307136 | 307136 | 2020-07-06 | Avoyelles | Louisiana | 22009 | 390 | 14 |
303969 | 303969 | 2020-07-05 | Avoyelles | Louisiana | 22009 | 386 | 14 |
300805 | 300805 | 2020-07-04 | Avoyelles | Louisiana | 22009 | 378 | 14 |
297643 | 297643 | 2020-07-03 | Avoyelles | Louisiana | 22009 | 378 | 14 |
294485 | 294485 | 2020-07-02 | Avoyelles | Louisiana | 22009 | 375 | 14 |
291331 | 291331 | 2020-07-01 | Avoyelles | Louisiana | 22009 | 341 | 14 |
288180 | 288180 | 2020-06-30 | Avoyelles | Louisiana | 22009 | 319 | 13 |
285031 | 285031 | 2020-06-29 | Avoyelles | Louisiana | 22009 | 309 | 11 |
281885 | 281885 | 2020-06-28 | Avoyelles | Louisiana | 22009 | 308 | 11 |
278737 | 278737 | 2020-06-27 | Avoyelles | Louisiana | 22009 | 294 | 11 |
275589 | 275589 | 2020-06-26 | Avoyelles | Louisiana | 22009 | 294 | 11 |
272446 | 272446 | 2020-06-25 | Avoyelles | Louisiana | 22009 | 277 | 11 |
269310 | 269310 | 2020-06-24 | Avoyelles | Louisiana | 22009 | 254 | 11 |
266177 | 266177 | 2020-06-23 | Avoyelles | Louisiana | 22009 | 238 | 11 |
263050 | 263050 | 2020-06-22 | Avoyelles | Louisiana | 22009 | 206 | 11 |
259921 | 259921 | 2020-06-21 | Avoyelles | Louisiana | 22009 | 204 | 11 |
256795 | 256795 | 2020-06-20 | Avoyelles | Louisiana | 22009 | 204 | 11 |
253675 | 253675 | 2020-06-19 | Avoyelles | Louisiana | 22009 | 200 | 10 |
250560 | 250560 | 2020-06-18 | Avoyelles | Louisiana | 22009 | 193 | 10 |
247448 | 247448 | 2020-06-17 | Avoyelles | Louisiana | 22009 | 193 | 10 |
244335 | 244335 | 2020-06-16 | Avoyelles | Louisiana | 22009 | 188 | 9 |
241224 | 241224 | 2020-06-15 | Avoyelles | Louisiana | 22009 | 188 | 9 |
238115 | 238115 | 2020-06-14 | Avoyelles | Louisiana | 22009 | 185 | 9 |
235008 | 235008 | 2020-06-13 | Avoyelles | Louisiana | 22009 | 184 | 9 |
231903 | 231903 | 2020-06-12 | Avoyelles | Louisiana | 22009 | 181 | 9 |
228799 | 228799 | 2020-06-11 | Avoyelles | Louisiana | 22009 | 178 | 9 |
225697 | 225697 | 2020-06-10 | Avoyelles | Louisiana | 22009 | 178 | 9 |
222601 | 222601 | 2020-06-09 | Avoyelles | Louisiana | 22009 | 175 | 9 |
219506 | 219506 | 2020-06-08 | Avoyelles | Louisiana | 22009 | 165 | 9 |
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);