ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Franklin" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535951 | 535951 | 2020-09-15 | Franklin | Missouri | 29071 | 1376 | 23 |
532716 | 532716 | 2020-09-14 | Franklin | Missouri | 29071 | 1347 | 23 |
529480 | 529480 | 2020-09-13 | Franklin | Missouri | 29071 | 1329 | 23 |
526244 | 526244 | 2020-09-12 | Franklin | Missouri | 29071 | 1282 | 23 |
523008 | 523008 | 2020-09-11 | Franklin | Missouri | 29071 | 1235 | 23 |
519771 | 519771 | 2020-09-10 | Franklin | Missouri | 29071 | 1223 | 22 |
516536 | 516536 | 2020-09-09 | Franklin | Missouri | 29071 | 1203 | 22 |
513302 | 513302 | 2020-09-08 | Franklin | Missouri | 29071 | 1178 | 22 |
510070 | 510070 | 2020-09-07 | Franklin | Missouri | 29071 | 1170 | 22 |
506837 | 506837 | 2020-09-06 | Franklin | Missouri | 29071 | 1157 | 22 |
503604 | 503604 | 2020-09-05 | Franklin | Missouri | 29071 | 1133 | 22 |
500370 | 500370 | 2020-09-04 | Franklin | Missouri | 29071 | 1110 | 22 |
497136 | 497136 | 2020-09-03 | Franklin | Missouri | 29071 | 1092 | 22 |
493903 | 493903 | 2020-09-02 | Franklin | Missouri | 29071 | 1055 | 22 |
490669 | 490669 | 2020-09-01 | Franklin | Missouri | 29071 | 1040 | 22 |
487436 | 487436 | 2020-08-31 | Franklin | Missouri | 29071 | 1025 | 22 |
484202 | 484202 | 2020-08-30 | Franklin | Missouri | 29071 | 1018 | 21 |
480967 | 480967 | 2020-08-29 | Franklin | Missouri | 29071 | 1002 | 20 |
477735 | 477735 | 2020-08-28 | Franklin | Missouri | 29071 | 981 | 19 |
474502 | 474502 | 2020-08-27 | Franklin | Missouri | 29071 | 943 | 19 |
471270 | 471270 | 2020-08-26 | Franklin | Missouri | 29071 | 922 | 19 |
468040 | 468040 | 2020-08-25 | Franklin | Missouri | 29071 | 889 | 19 |
464811 | 464811 | 2020-08-24 | Franklin | Missouri | 29071 | 877 | 19 |
461580 | 461580 | 2020-08-23 | Franklin | Missouri | 29071 | 863 | 19 |
458353 | 458353 | 2020-08-22 | Franklin | Missouri | 29071 | 844 | 19 |
455125 | 455125 | 2020-08-21 | Franklin | Missouri | 29071 | 818 | 19 |
451897 | 451897 | 2020-08-20 | Franklin | Missouri | 29071 | 806 | 19 |
448669 | 448669 | 2020-08-19 | Franklin | Missouri | 29071 | 791 | 19 |
445443 | 445443 | 2020-08-18 | Franklin | Missouri | 29071 | 778 | 19 |
442217 | 442217 | 2020-08-17 | Franklin | Missouri | 29071 | 762 | 19 |
438990 | 438990 | 2020-08-16 | Franklin | Missouri | 29071 | 742 | 19 |
435765 | 435765 | 2020-08-15 | Franklin | Missouri | 29071 | 729 | 19 |
432539 | 432539 | 2020-08-14 | Franklin | Missouri | 29071 | 704 | 18 |
429312 | 429312 | 2020-08-13 | Franklin | Missouri | 29071 | 680 | 18 |
426088 | 426088 | 2020-08-12 | Franklin | Missouri | 29071 | 669 | 18 |
422866 | 422866 | 2020-08-11 | Franklin | Missouri | 29071 | 642 | 18 |
419644 | 419644 | 2020-08-10 | Franklin | Missouri | 29071 | 631 | 18 |
416423 | 416423 | 2020-08-09 | Franklin | Missouri | 29071 | 618 | 18 |
413203 | 413203 | 2020-08-08 | Franklin | Missouri | 29071 | 590 | 18 |
409983 | 409983 | 2020-08-07 | Franklin | Missouri | 29071 | 590 | 18 |
406763 | 406763 | 2020-08-06 | Franklin | Missouri | 29071 | 586 | 18 |
403545 | 403545 | 2020-08-05 | Franklin | Missouri | 29071 | 566 | 18 |
400328 | 400328 | 2020-08-04 | Franklin | Missouri | 29071 | 554 | 18 |
397114 | 397114 | 2020-08-03 | Franklin | Missouri | 29071 | 542 | 18 |
393898 | 393898 | 2020-08-02 | Franklin | Missouri | 29071 | 519 | 18 |
390681 | 390681 | 2020-08-01 | Franklin | Missouri | 29071 | 516 | 18 |
387464 | 387464 | 2020-07-31 | Franklin | Missouri | 29071 | 509 | 18 |
384246 | 384246 | 2020-07-30 | Franklin | Missouri | 29071 | 490 | 18 |
381030 | 381030 | 2020-07-29 | Franklin | Missouri | 29071 | 484 | 18 |
377813 | 377813 | 2020-07-28 | Franklin | Missouri | 29071 | 469 | 18 |
374598 | 374598 | 2020-07-27 | Franklin | Missouri | 29071 | 451 | 18 |
371386 | 371386 | 2020-07-26 | Franklin | Missouri | 29071 | 447 | 18 |
368175 | 368175 | 2020-07-25 | Franklin | Missouri | 29071 | 443 | 18 |
364967 | 364967 | 2020-07-24 | Franklin | Missouri | 29071 | 424 | 18 |
361760 | 361760 | 2020-07-23 | Franklin | Missouri | 29071 | 408 | 18 |
358555 | 358555 | 2020-07-22 | Franklin | Missouri | 29071 | 394 | 18 |
355352 | 355352 | 2020-07-21 | Franklin | Missouri | 29071 | 382 | 18 |
352150 | 352150 | 2020-07-20 | Franklin | Missouri | 29071 | 360 | 18 |
348950 | 348950 | 2020-07-19 | Franklin | Missouri | 29071 | 354 | 18 |
345749 | 345749 | 2020-07-18 | Franklin | Missouri | 29071 | 348 | 18 |
342549 | 342549 | 2020-07-17 | Franklin | Missouri | 29071 | 337 | 18 |
339353 | 339353 | 2020-07-16 | Franklin | Missouri | 29071 | 324 | 18 |
336157 | 336157 | 2020-07-15 | Franklin | Missouri | 29071 | 317 | 18 |
332964 | 332964 | 2020-07-14 | Franklin | Missouri | 29071 | 305 | 18 |
329777 | 329777 | 2020-07-13 | Franklin | Missouri | 29071 | 283 | 18 |
326591 | 326591 | 2020-07-12 | Franklin | Missouri | 29071 | 279 | 18 |
323408 | 323408 | 2020-07-11 | Franklin | Missouri | 29071 | 273 | 18 |
320229 | 320229 | 2020-07-10 | Franklin | Missouri | 29071 | 264 | 18 |
317054 | 317054 | 2020-07-09 | Franklin | Missouri | 29071 | 248 | 18 |
313880 | 313880 | 2020-07-08 | Franklin | Missouri | 29071 | 235 | 18 |
310710 | 310710 | 2020-07-07 | Franklin | Missouri | 29071 | 231 | 18 |
307542 | 307542 | 2020-07-06 | Franklin | Missouri | 29071 | 227 | 18 |
304375 | 304375 | 2020-07-05 | Franklin | Missouri | 29071 | 217 | 18 |
301211 | 301211 | 2020-07-04 | Franklin | Missouri | 29071 | 217 | 18 |
298048 | 298048 | 2020-07-03 | Franklin | Missouri | 29071 | 217 | 18 |
294890 | 294890 | 2020-07-02 | Franklin | Missouri | 29071 | 213 | 18 |
291736 | 291736 | 2020-07-01 | Franklin | Missouri | 29071 | 208 | 18 |
288585 | 288585 | 2020-06-30 | Franklin | Missouri | 29071 | 206 | 18 |
285435 | 285435 | 2020-06-29 | Franklin | Missouri | 29071 | 207 | 18 |
282290 | 282290 | 2020-06-28 | Franklin | Missouri | 29071 | 206 | 18 |
279142 | 279142 | 2020-06-27 | Franklin | Missouri | 29071 | 204 | 18 |
275994 | 275994 | 2020-06-26 | Franklin | Missouri | 29071 | 202 | 18 |
272851 | 272851 | 2020-06-25 | Franklin | Missouri | 29071 | 201 | 18 |
269713 | 269713 | 2020-06-24 | Franklin | Missouri | 29071 | 192 | 18 |
266580 | 266580 | 2020-06-23 | Franklin | Missouri | 29071 | 193 | 18 |
263454 | 263454 | 2020-06-22 | Franklin | Missouri | 29071 | 191 | 18 |
260326 | 260326 | 2020-06-21 | Franklin | Missouri | 29071 | 188 | 18 |
257200 | 257200 | 2020-06-20 | Franklin | Missouri | 29071 | 188 | 18 |
254080 | 254080 | 2020-06-19 | Franklin | Missouri | 29071 | 180 | 18 |
250965 | 250965 | 2020-06-18 | Franklin | Missouri | 29071 | 178 | 18 |
247852 | 247852 | 2020-06-17 | Franklin | Missouri | 29071 | 173 | 18 |
244739 | 244739 | 2020-06-16 | Franklin | Missouri | 29071 | 172 | 18 |
241628 | 241628 | 2020-06-15 | Franklin | Missouri | 29071 | 168 | 18 |
238518 | 238518 | 2020-06-14 | Franklin | Missouri | 29071 | 166 | 18 |
235411 | 235411 | 2020-06-13 | Franklin | Missouri | 29071 | 166 | 18 |
232305 | 232305 | 2020-06-12 | Franklin | Missouri | 29071 | 166 | 18 |
229201 | 229201 | 2020-06-11 | Franklin | Missouri | 29071 | 164 | 18 |
226098 | 226098 | 2020-06-10 | Franklin | Missouri | 29071 | 155 | 18 |
223000 | 223000 | 2020-06-09 | Franklin | Missouri | 29071 | 156 | 18 |
219905 | 219905 | 2020-06-08 | Franklin | Missouri | 29071 | 153 | 18 |
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);