ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Tammany" and state = "Louisiana" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
259968 | 259968 | 2020-06-21 | St. Tammany | Louisiana | 22103 | 2017 | 170 |
263097 | 263097 | 2020-06-22 | St. Tammany | Louisiana | 22103 | 2043 | 172 |
266224 | 266224 | 2020-06-23 | St. Tammany | Louisiana | 22103 | 2096 | 172 |
269357 | 269357 | 2020-06-24 | St. Tammany | Louisiana | 22103 | 2131 | 172 |
272493 | 272493 | 2020-06-25 | St. Tammany | Louisiana | 22103 | 2166 | 172 |
275636 | 275636 | 2020-06-26 | St. Tammany | Louisiana | 22103 | 2211 | 173 |
278784 | 278784 | 2020-06-27 | St. Tammany | Louisiana | 22103 | 2211 | 173 |
281932 | 281932 | 2020-06-28 | St. Tammany | Louisiana | 22103 | 2288 | 174 |
285078 | 285078 | 2020-06-29 | St. Tammany | Louisiana | 22103 | 2327 | 175 |
288227 | 288227 | 2020-06-30 | St. Tammany | Louisiana | 22103 | 2308 | 175 |
291378 | 291378 | 2020-07-01 | St. Tammany | Louisiana | 22103 | 2371 | 175 |
294532 | 294532 | 2020-07-02 | St. Tammany | Louisiana | 22103 | 2440 | 175 |
297690 | 297690 | 2020-07-03 | St. Tammany | Louisiana | 22103 | 2509 | 178 |
300852 | 300852 | 2020-07-04 | St. Tammany | Louisiana | 22103 | 2509 | 178 |
304016 | 304016 | 2020-07-05 | St. Tammany | Louisiana | 22103 | 2615 | 178 |
307183 | 307183 | 2020-07-06 | St. Tammany | Louisiana | 22103 | 2657 | 179 |
310351 | 310351 | 2020-07-07 | St. Tammany | Louisiana | 22103 | 2738 | 181 |
313521 | 313521 | 2020-07-08 | St. Tammany | Louisiana | 22103 | 2844 | 181 |
316695 | 316695 | 2020-07-09 | St. Tammany | Louisiana | 22103 | 2908 | 183 |
319870 | 319870 | 2020-07-10 | St. Tammany | Louisiana | 22103 | 3004 | 184 |
323049 | 323049 | 2020-07-11 | St. Tammany | Louisiana | 22103 | 3101 | 185 |
326232 | 326232 | 2020-07-12 | St. Tammany | Louisiana | 22103 | 3169 | 187 |
329418 | 329418 | 2020-07-13 | St. Tammany | Louisiana | 22103 | 3257 | 187 |
332605 | 332605 | 2020-07-14 | St. Tammany | Louisiana | 22103 | 3342 | 187 |
335798 | 335798 | 2020-07-15 | St. Tammany | Louisiana | 22103 | 3395 | 187 |
338994 | 338994 | 2020-07-16 | St. Tammany | Louisiana | 22103 | 3474 | 188 |
342190 | 342190 | 2020-07-17 | St. Tammany | Louisiana | 22103 | 3569 | 188 |
345390 | 345390 | 2020-07-18 | St. Tammany | Louisiana | 22103 | 3569 | 188 |
348591 | 348591 | 2020-07-19 | St. Tammany | Louisiana | 22103 | 3699 | 189 |
351791 | 351791 | 2020-07-20 | St. Tammany | Louisiana | 22103 | 3790 | 189 |
354993 | 354993 | 2020-07-21 | St. Tammany | Louisiana | 22103 | 3859 | 189 |
358196 | 358196 | 2020-07-22 | St. Tammany | Louisiana | 22103 | 3954 | 190 |
361401 | 361401 | 2020-07-23 | St. Tammany | Louisiana | 22103 | 4022 | 190 |
364608 | 364608 | 2020-07-24 | St. Tammany | Louisiana | 22103 | 4136 | 191 |
367815 | 367815 | 2020-07-25 | St. Tammany | Louisiana | 22103 | 4136 | 191 |
371025 | 371025 | 2020-07-26 | St. Tammany | Louisiana | 22103 | 4285 | 194 |
374237 | 374237 | 2020-07-27 | St. Tammany | Louisiana | 22103 | 4375 | 195 |
377452 | 377452 | 2020-07-28 | St. Tammany | Louisiana | 22103 | 4409 | 198 |
380669 | 380669 | 2020-07-29 | St. Tammany | Louisiana | 22103 | 4487 | 200 |
383886 | 383886 | 2020-07-30 | St. Tammany | Louisiana | 22103 | 4568 | 201 |
387104 | 387104 | 2020-07-31 | St. Tammany | Louisiana | 22103 | 4621 | 201 |
390321 | 390321 | 2020-08-01 | St. Tammany | Louisiana | 22103 | 4621 | 201 |
393538 | 393538 | 2020-08-02 | St. Tammany | Louisiana | 22103 | 4759 | 203 |
396754 | 396754 | 2020-08-03 | St. Tammany | Louisiana | 22103 | 4808 | 203 |
399969 | 399969 | 2020-08-04 | St. Tammany | Louisiana | 22103 | 4884 | 206 |
403186 | 403186 | 2020-08-05 | St. Tammany | Louisiana | 22103 | 4939 | 208 |
406404 | 406404 | 2020-08-06 | St. Tammany | Louisiana | 22103 | 4993 | 208 |
409624 | 409624 | 2020-08-07 | St. Tammany | Louisiana | 22103 | 5086 | 211 |
412844 | 412844 | 2020-08-08 | St. Tammany | Louisiana | 22103 | 5086 | 211 |
416064 | 416064 | 2020-08-09 | St. Tammany | Louisiana | 22103 | 5229 | 214 |
419285 | 419285 | 2020-08-10 | St. Tammany | Louisiana | 22103 | 5266 | 214 |
422507 | 422507 | 2020-08-11 | St. Tammany | Louisiana | 22103 | 5323 | 215 |
425728 | 425728 | 2020-08-12 | St. Tammany | Louisiana | 22103 | 5364 | 216 |
428952 | 428952 | 2020-08-13 | St. Tammany | Louisiana | 22103 | 5429 | 217 |
432180 | 432180 | 2020-08-14 | St. Tammany | Louisiana | 22103 | 5480 | 218 |
435405 | 435405 | 2020-08-15 | St. Tammany | Louisiana | 22103 | 5480 | 218 |
438630 | 438630 | 2020-08-16 | St. Tammany | Louisiana | 22103 | 5552 | 220 |
441857 | 441857 | 2020-08-17 | St. Tammany | Louisiana | 22103 | 5600 | 221 |
445083 | 445083 | 2020-08-18 | St. Tammany | Louisiana | 22103 | 5626 | 221 |
448310 | 448310 | 2020-08-19 | St. Tammany | Louisiana | 22103 | 5658 | 221 |
451538 | 451538 | 2020-08-20 | St. Tammany | Louisiana | 22103 | 5717 | 221 |
454766 | 454766 | 2020-08-21 | St. Tammany | Louisiana | 22103 | 5760 | 226 |
457994 | 457994 | 2020-08-22 | St. Tammany | Louisiana | 22103 | 5760 | 226 |
461221 | 461221 | 2020-08-23 | St. Tammany | Louisiana | 22103 | 5815 | 226 |
464452 | 464452 | 2020-08-24 | St. Tammany | Louisiana | 22103 | 5841 | 226 |
467681 | 467681 | 2020-08-25 | St. Tammany | Louisiana | 22103 | 5859 | 226 |
470910 | 470910 | 2020-08-26 | St. Tammany | Louisiana | 22103 | 5892 | 231 |
474142 | 474142 | 2020-08-27 | St. Tammany | Louisiana | 22103 | 5917 | 235 |
477375 | 477375 | 2020-08-28 | St. Tammany | Louisiana | 22103 | 5940 | 236 |
480608 | 480608 | 2020-08-29 | St. Tammany | Louisiana | 22103 | 5940 | 236 |
483842 | 483842 | 2020-08-30 | St. Tammany | Louisiana | 22103 | 6037 | 236 |
487077 | 487077 | 2020-08-31 | St. Tammany | Louisiana | 22103 | 6053 | 237 |
490310 | 490310 | 2020-09-01 | St. Tammany | Louisiana | 22103 | 6087 | 239 |
493544 | 493544 | 2020-09-02 | St. Tammany | Louisiana | 22103 | 6148 | 240 |
496777 | 496777 | 2020-09-03 | St. Tammany | Louisiana | 22103 | 6220 | 242 |
500011 | 500011 | 2020-09-04 | St. Tammany | Louisiana | 22103 | 6267 | 242 |
503244 | 503244 | 2020-09-05 | St. Tammany | Louisiana | 22103 | 6267 | 242 |
506478 | 506478 | 2020-09-06 | St. Tammany | Louisiana | 22103 | 6361 | 245 |
509711 | 509711 | 2020-09-07 | St. Tammany | Louisiana | 22103 | 6373 | 245 |
512943 | 512943 | 2020-09-08 | St. Tammany | Louisiana | 22103 | 6402 | 245 |
516176 | 516176 | 2020-09-09 | St. Tammany | Louisiana | 22103 | 6489 | 245 |
519411 | 519411 | 2020-09-10 | St. Tammany | Louisiana | 22103 | 6521 | 245 |
522648 | 522648 | 2020-09-11 | St. Tammany | Louisiana | 22103 | 6578 | 246 |
525884 | 525884 | 2020-09-12 | St. Tammany | Louisiana | 22103 | 6578 | 246 |
529120 | 529120 | 2020-09-13 | St. Tammany | Louisiana | 22103 | 6637 | 246 |
532357 | 532357 | 2020-09-14 | St. Tammany | Louisiana | 22103 | 6670 | 247 |
535592 | 535592 | 2020-09-15 | St. Tammany | Louisiana | 22103 | 6676 | 250 |
538829 | 538829 | 2020-09-16 | St. Tammany | Louisiana | 22103 | 6719 | 250 |
542065 | 542065 | 2020-09-17 | St. Tammany | Louisiana | 22103 | 6735 | 250 |
545301 | 545301 | 2020-09-18 | St. Tammany | Louisiana | 22103 | 6779 | 250 |
548539 | 548539 | 2020-09-19 | St. Tammany | Louisiana | 22103 | 6779 | 250 |
551778 | 551778 | 2020-09-20 | St. Tammany | Louisiana | 22103 | 6814 | 251 |
555017 | 555017 | 2020-09-21 | St. Tammany | Louisiana | 22103 | 6828 | 251 |
558254 | 558254 | 2020-09-22 | St. Tammany | Louisiana | 22103 | 6842 | 251 |
561490 | 561490 | 2020-09-23 | St. Tammany | Louisiana | 22103 | 6858 | 251 |
564730 | 564730 | 2020-09-24 | St. Tammany | Louisiana | 22103 | 6886 | 251 |
567970 | 567970 | 2020-09-25 | St. Tammany | Louisiana | 22103 | 6907 | 252 |
571212 | 571212 | 2020-09-26 | St. Tammany | Louisiana | 22103 | 6907 | 252 |
574455 | 574455 | 2020-09-27 | St. Tammany | Louisiana | 22103 | 6941 | 253 |
577697 | 577697 | 2020-09-28 | St. Tammany | Louisiana | 22103 | 6955 | 253 |
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);