ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Calcasieu" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535550 | 535550 | 2020-09-15 | Calcasieu | Louisiana | 22019 | 7632 | 203 |
532315 | 532315 | 2020-09-14 | Calcasieu | Louisiana | 22019 | 7632 | 202 |
529078 | 529078 | 2020-09-13 | Calcasieu | Louisiana | 22019 | 7623 | 200 |
525842 | 525842 | 2020-09-12 | Calcasieu | Louisiana | 22019 | 7592 | 198 |
522606 | 522606 | 2020-09-11 | Calcasieu | Louisiana | 22019 | 7592 | 198 |
519369 | 519369 | 2020-09-10 | Calcasieu | Louisiana | 22019 | 7580 | 197 |
516134 | 516134 | 2020-09-09 | Calcasieu | Louisiana | 22019 | 7549 | 196 |
512901 | 512901 | 2020-09-08 | Calcasieu | Louisiana | 22019 | 7487 | 194 |
509669 | 509669 | 2020-09-07 | Calcasieu | Louisiana | 22019 | 7476 | 194 |
506436 | 506436 | 2020-09-06 | Calcasieu | Louisiana | 22019 | 7474 | 194 |
503202 | 503202 | 2020-09-05 | Calcasieu | Louisiana | 22019 | 7465 | 193 |
499969 | 499969 | 2020-09-04 | Calcasieu | Louisiana | 22019 | 7465 | 193 |
496735 | 496735 | 2020-09-03 | Calcasieu | Louisiana | 22019 | 7438 | 192 |
493502 | 493502 | 2020-09-02 | Calcasieu | Louisiana | 22019 | 7442 | 192 |
490268 | 490268 | 2020-09-01 | Calcasieu | Louisiana | 22019 | 7445 | 190 |
487035 | 487035 | 2020-08-31 | Calcasieu | Louisiana | 22019 | 7441 | 182 |
483800 | 483800 | 2020-08-30 | Calcasieu | Louisiana | 22019 | 7439 | 182 |
480566 | 480566 | 2020-08-29 | Calcasieu | Louisiana | 22019 | 7298 | 182 |
477333 | 477333 | 2020-08-28 | Calcasieu | Louisiana | 22019 | 7298 | 182 |
474100 | 474100 | 2020-08-27 | Calcasieu | Louisiana | 22019 | 7285 | 181 |
470868 | 470868 | 2020-08-26 | Calcasieu | Louisiana | 22019 | 7269 | 179 |
467639 | 467639 | 2020-08-25 | Calcasieu | Louisiana | 22019 | 7256 | 178 |
464410 | 464410 | 2020-08-24 | Calcasieu | Louisiana | 22019 | 7284 | 178 |
461179 | 461179 | 2020-08-23 | Calcasieu | Louisiana | 22019 | 7277 | 178 |
457952 | 457952 | 2020-08-22 | Calcasieu | Louisiana | 22019 | 7235 | 166 |
454724 | 454724 | 2020-08-21 | Calcasieu | Louisiana | 22019 | 7235 | 166 |
451496 | 451496 | 2020-08-20 | Calcasieu | Louisiana | 22019 | 7194 | 160 |
448268 | 448268 | 2020-08-19 | Calcasieu | Louisiana | 22019 | 7154 | 158 |
445041 | 445041 | 2020-08-18 | Calcasieu | Louisiana | 22019 | 7093 | 157 |
441815 | 441815 | 2020-08-17 | Calcasieu | Louisiana | 22019 | 7045 | 157 |
438588 | 438588 | 2020-08-16 | Calcasieu | Louisiana | 22019 | 7044 | 156 |
435363 | 435363 | 2020-08-15 | Calcasieu | Louisiana | 22019 | 7013 | 154 |
432138 | 432138 | 2020-08-14 | Calcasieu | Louisiana | 22019 | 7013 | 154 |
428910 | 428910 | 2020-08-13 | Calcasieu | Louisiana | 22019 | 6960 | 154 |
425686 | 425686 | 2020-08-12 | Calcasieu | Louisiana | 22019 | 6924 | 147 |
422465 | 422465 | 2020-08-11 | Calcasieu | Louisiana | 22019 | 6862 | 146 |
419243 | 419243 | 2020-08-10 | Calcasieu | Louisiana | 22019 | 6815 | 146 |
416022 | 416022 | 2020-08-09 | Calcasieu | Louisiana | 22019 | 6815 | 146 |
412802 | 412802 | 2020-08-08 | Calcasieu | Louisiana | 22019 | 6752 | 146 |
409582 | 409582 | 2020-08-07 | Calcasieu | Louisiana | 22019 | 6752 | 146 |
406362 | 406362 | 2020-08-06 | Calcasieu | Louisiana | 22019 | 6695 | 130 |
403144 | 403144 | 2020-08-05 | Calcasieu | Louisiana | 22019 | 6641 | 127 |
399927 | 399927 | 2020-08-04 | Calcasieu | Louisiana | 22019 | 6594 | 127 |
396712 | 396712 | 2020-08-03 | Calcasieu | Louisiana | 22019 | 6527 | 127 |
393496 | 393496 | 2020-08-02 | Calcasieu | Louisiana | 22019 | 6440 | 127 |
390279 | 390279 | 2020-08-01 | Calcasieu | Louisiana | 22019 | 6278 | 121 |
387062 | 387062 | 2020-07-31 | Calcasieu | Louisiana | 22019 | 6278 | 121 |
383844 | 383844 | 2020-07-30 | Calcasieu | Louisiana | 22019 | 5913 | 117 |
380627 | 380627 | 2020-07-29 | Calcasieu | Louisiana | 22019 | 5810 | 116 |
377410 | 377410 | 2020-07-28 | Calcasieu | Louisiana | 22019 | 5709 | 107 |
374195 | 374195 | 2020-07-27 | Calcasieu | Louisiana | 22019 | 5626 | 107 |
370983 | 370983 | 2020-07-26 | Calcasieu | Louisiana | 22019 | 5459 | 96 |
367773 | 367773 | 2020-07-25 | Calcasieu | Louisiana | 22019 | 5127 | 92 |
364566 | 364566 | 2020-07-24 | Calcasieu | Louisiana | 22019 | 5127 | 92 |
361359 | 361359 | 2020-07-23 | Calcasieu | Louisiana | 22019 | 4995 | 92 |
358154 | 358154 | 2020-07-22 | Calcasieu | Louisiana | 22019 | 4742 | 92 |
354951 | 354951 | 2020-07-21 | Calcasieu | Louisiana | 22019 | 4578 | 91 |
351749 | 351749 | 2020-07-20 | Calcasieu | Louisiana | 22019 | 4481 | 84 |
348549 | 348549 | 2020-07-19 | Calcasieu | Louisiana | 22019 | 4231 | 80 |
345348 | 345348 | 2020-07-18 | Calcasieu | Louisiana | 22019 | 4028 | 75 |
342148 | 342148 | 2020-07-17 | Calcasieu | Louisiana | 22019 | 4028 | 75 |
338952 | 338952 | 2020-07-16 | Calcasieu | Louisiana | 22019 | 3864 | 75 |
335756 | 335756 | 2020-07-15 | Calcasieu | Louisiana | 22019 | 3705 | 74 |
332563 | 332563 | 2020-07-14 | Calcasieu | Louisiana | 22019 | 3435 | 72 |
329376 | 329376 | 2020-07-13 | Calcasieu | Louisiana | 22019 | 3236 | 71 |
326190 | 326190 | 2020-07-12 | Calcasieu | Louisiana | 22019 | 3127 | 71 |
323007 | 323007 | 2020-07-11 | Calcasieu | Louisiana | 22019 | 3061 | 70 |
319828 | 319828 | 2020-07-10 | Calcasieu | Louisiana | 22019 | 2975 | 63 |
316653 | 316653 | 2020-07-09 | Calcasieu | Louisiana | 22019 | 2797 | 63 |
313479 | 313479 | 2020-07-08 | Calcasieu | Louisiana | 22019 | 2701 | 62 |
310309 | 310309 | 2020-07-07 | Calcasieu | Louisiana | 22019 | 2408 | 59 |
307141 | 307141 | 2020-07-06 | Calcasieu | Louisiana | 22019 | 2289 | 59 |
303974 | 303974 | 2020-07-05 | Calcasieu | Louisiana | 22019 | 2153 | 59 |
300810 | 300810 | 2020-07-04 | Calcasieu | Louisiana | 22019 | 2000 | 59 |
297648 | 297648 | 2020-07-03 | Calcasieu | Louisiana | 22019 | 2000 | 59 |
294490 | 294490 | 2020-07-02 | Calcasieu | Louisiana | 22019 | 1852 | 59 |
291336 | 291336 | 2020-07-01 | Calcasieu | Louisiana | 22019 | 1729 | 59 |
288185 | 288185 | 2020-06-30 | Calcasieu | Louisiana | 22019 | 1300 | 59 |
285036 | 285036 | 2020-06-29 | Calcasieu | Louisiana | 22019 | 1257 | 54 |
281890 | 281890 | 2020-06-28 | Calcasieu | Louisiana | 22019 | 1205 | 54 |
278742 | 278742 | 2020-06-27 | Calcasieu | Louisiana | 22019 | 1138 | 54 |
275594 | 275594 | 2020-06-26 | Calcasieu | Louisiana | 22019 | 1138 | 54 |
272451 | 272451 | 2020-06-25 | Calcasieu | Louisiana | 22019 | 1061 | 54 |
269315 | 269315 | 2020-06-24 | Calcasieu | Louisiana | 22019 | 1010 | 54 |
266182 | 266182 | 2020-06-23 | Calcasieu | Louisiana | 22019 | 971 | 53 |
263055 | 263055 | 2020-06-22 | Calcasieu | Louisiana | 22019 | 921 | 53 |
259926 | 259926 | 2020-06-21 | Calcasieu | Louisiana | 22019 | 888 | 53 |
256800 | 256800 | 2020-06-20 | Calcasieu | Louisiana | 22019 | 876 | 53 |
253680 | 253680 | 2020-06-19 | Calcasieu | Louisiana | 22019 | 831 | 52 |
250565 | 250565 | 2020-06-18 | Calcasieu | Louisiana | 22019 | 824 | 52 |
247453 | 247453 | 2020-06-17 | Calcasieu | Louisiana | 22019 | 824 | 52 |
244340 | 244340 | 2020-06-16 | Calcasieu | Louisiana | 22019 | 789 | 51 |
241229 | 241229 | 2020-06-15 | Calcasieu | Louisiana | 22019 | 772 | 51 |
238120 | 238120 | 2020-06-14 | Calcasieu | Louisiana | 22019 | 755 | 51 |
235013 | 235013 | 2020-06-13 | Calcasieu | Louisiana | 22019 | 741 | 51 |
231908 | 231908 | 2020-06-12 | Calcasieu | Louisiana | 22019 | 701 | 51 |
228804 | 228804 | 2020-06-11 | Calcasieu | Louisiana | 22019 | 684 | 51 |
225702 | 225702 | 2020-06-10 | Calcasieu | Louisiana | 22019 | 673 | 51 |
222606 | 222606 | 2020-06-09 | Calcasieu | Louisiana | 22019 | 661 | 51 |
219511 | 219511 | 2020-06-08 | Calcasieu | Louisiana | 22019 | 642 | 51 |
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);