ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28111 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
275932 | 275932 | 2020-06-26 | Perry | Mississippi | 28111 | 56 | 4 |
279080 | 279080 | 2020-06-27 | Perry | Mississippi | 28111 | 56 | 4 |
282228 | 282228 | 2020-06-28 | Perry | Mississippi | 28111 | 56 | 4 |
285373 | 285373 | 2020-06-29 | Perry | Mississippi | 28111 | 59 | 4 |
288523 | 288523 | 2020-06-30 | Perry | Mississippi | 28111 | 59 | 4 |
291674 | 291674 | 2020-07-01 | Perry | Mississippi | 28111 | 61 | 4 |
294828 | 294828 | 2020-07-02 | Perry | Mississippi | 28111 | 63 | 4 |
297986 | 297986 | 2020-07-03 | Perry | Mississippi | 28111 | 65 | 4 |
301149 | 301149 | 2020-07-04 | Perry | Mississippi | 28111 | 66 | 4 |
304313 | 304313 | 2020-07-05 | Perry | Mississippi | 28111 | 66 | 4 |
307480 | 307480 | 2020-07-06 | Perry | Mississippi | 28111 | 67 | 4 |
310648 | 310648 | 2020-07-07 | Perry | Mississippi | 28111 | 72 | 4 |
313818 | 313818 | 2020-07-08 | Perry | Mississippi | 28111 | 76 | 4 |
316992 | 316992 | 2020-07-09 | Perry | Mississippi | 28111 | 76 | 4 |
320167 | 320167 | 2020-07-10 | Perry | Mississippi | 28111 | 79 | 4 |
323346 | 323346 | 2020-07-11 | Perry | Mississippi | 28111 | 87 | 4 |
326529 | 326529 | 2020-07-12 | Perry | Mississippi | 28111 | 91 | 4 |
329715 | 329715 | 2020-07-13 | Perry | Mississippi | 28111 | 91 | 4 |
332902 | 332902 | 2020-07-14 | Perry | Mississippi | 28111 | 95 | 4 |
336095 | 336095 | 2020-07-15 | Perry | Mississippi | 28111 | 99 | 4 |
339291 | 339291 | 2020-07-16 | Perry | Mississippi | 28111 | 105 | 4 |
342487 | 342487 | 2020-07-17 | Perry | Mississippi | 28111 | 111 | 4 |
345687 | 345687 | 2020-07-18 | Perry | Mississippi | 28111 | 108 | 5 |
348888 | 348888 | 2020-07-19 | Perry | Mississippi | 28111 | 110 | 5 |
352088 | 352088 | 2020-07-20 | Perry | Mississippi | 28111 | 117 | 5 |
355290 | 355290 | 2020-07-21 | Perry | Mississippi | 28111 | 127 | 5 |
358493 | 358493 | 2020-07-22 | Perry | Mississippi | 28111 | 143 | 6 |
361698 | 361698 | 2020-07-23 | Perry | Mississippi | 28111 | 151 | 6 |
364905 | 364905 | 2020-07-24 | Perry | Mississippi | 28111 | 160 | 6 |
368113 | 368113 | 2020-07-25 | Perry | Mississippi | 28111 | 164 | 6 |
371323 | 371323 | 2020-07-26 | Perry | Mississippi | 28111 | 175 | 6 |
374535 | 374535 | 2020-07-27 | Perry | Mississippi | 28111 | 179 | 7 |
377750 | 377750 | 2020-07-28 | Perry | Mississippi | 28111 | 189 | 7 |
380967 | 380967 | 2020-07-29 | Perry | Mississippi | 28111 | 196 | 7 |
384184 | 384184 | 2020-07-30 | Perry | Mississippi | 28111 | 205 | 7 |
387402 | 387402 | 2020-07-31 | Perry | Mississippi | 28111 | 209 | 7 |
390619 | 390619 | 2020-08-01 | Perry | Mississippi | 28111 | 213 | 7 |
393836 | 393836 | 2020-08-02 | Perry | Mississippi | 28111 | 221 | 7 |
397052 | 397052 | 2020-08-03 | Perry | Mississippi | 28111 | 222 | 7 |
400266 | 400266 | 2020-08-04 | Perry | Mississippi | 28111 | 226 | 7 |
403483 | 403483 | 2020-08-05 | Perry | Mississippi | 28111 | 220 | 7 |
406701 | 406701 | 2020-08-06 | Perry | Mississippi | 28111 | 220 | 7 |
409921 | 409921 | 2020-08-07 | Perry | Mississippi | 28111 | 223 | 7 |
413141 | 413141 | 2020-08-08 | Perry | Mississippi | 28111 | 232 | 7 |
416361 | 416361 | 2020-08-09 | Perry | Mississippi | 28111 | 236 | 7 |
419582 | 419582 | 2020-08-10 | Perry | Mississippi | 28111 | 243 | 7 |
422804 | 422804 | 2020-08-11 | Perry | Mississippi | 28111 | 242 | 8 |
426026 | 426026 | 2020-08-12 | Perry | Mississippi | 28111 | 248 | 8 |
429250 | 429250 | 2020-08-13 | Perry | Mississippi | 28111 | 249 | 8 |
432477 | 432477 | 2020-08-14 | Perry | Mississippi | 28111 | 251 | 8 |
435703 | 435703 | 2020-08-15 | Perry | Mississippi | 28111 | 256 | 8 |
438928 | 438928 | 2020-08-16 | Perry | Mississippi | 28111 | 260 | 8 |
442155 | 442155 | 2020-08-17 | Perry | Mississippi | 28111 | 262 | 8 |
445381 | 445381 | 2020-08-18 | Perry | Mississippi | 28111 | 266 | 8 |
448607 | 448607 | 2020-08-19 | Perry | Mississippi | 28111 | 268 | 8 |
451835 | 451835 | 2020-08-20 | Perry | Mississippi | 28111 | 274 | 9 |
455063 | 455063 | 2020-08-21 | Perry | Mississippi | 28111 | 277 | 9 |
458291 | 458291 | 2020-08-22 | Perry | Mississippi | 28111 | 281 | 9 |
461518 | 461518 | 2020-08-23 | Perry | Mississippi | 28111 | 281 | 9 |
464749 | 464749 | 2020-08-24 | Perry | Mississippi | 28111 | 284 | 9 |
467978 | 467978 | 2020-08-25 | Perry | Mississippi | 28111 | 285 | 9 |
471208 | 471208 | 2020-08-26 | Perry | Mississippi | 28111 | 289 | 9 |
474440 | 474440 | 2020-08-27 | Perry | Mississippi | 28111 | 287 | 9 |
477673 | 477673 | 2020-08-28 | Perry | Mississippi | 28111 | 289 | 9 |
480905 | 480905 | 2020-08-29 | Perry | Mississippi | 28111 | 290 | 9 |
484140 | 484140 | 2020-08-30 | Perry | Mississippi | 28111 | 293 | 9 |
487374 | 487374 | 2020-08-31 | Perry | Mississippi | 28111 | 294 | 9 |
490607 | 490607 | 2020-09-01 | Perry | Mississippi | 28111 | 294 | 9 |
493841 | 493841 | 2020-09-02 | Perry | Mississippi | 28111 | 321 | 9 |
497074 | 497074 | 2020-09-03 | Perry | Mississippi | 28111 | 333 | 9 |
500308 | 500308 | 2020-09-04 | Perry | Mississippi | 28111 | 341 | 10 |
503542 | 503542 | 2020-09-05 | Perry | Mississippi | 28111 | 346 | 11 |
506775 | 506775 | 2020-09-06 | Perry | Mississippi | 28111 | 351 | 12 |
510008 | 510008 | 2020-09-07 | Perry | Mississippi | 28111 | 355 | 12 |
513240 | 513240 | 2020-09-08 | Perry | Mississippi | 28111 | 360 | 12 |
516474 | 516474 | 2020-09-09 | Perry | Mississippi | 28111 | 366 | 12 |
519709 | 519709 | 2020-09-10 | Perry | Mississippi | 28111 | 365 | 12 |
522946 | 522946 | 2020-09-11 | Perry | Mississippi | 28111 | 370 | 14 |
526182 | 526182 | 2020-09-12 | Perry | Mississippi | 28111 | 373 | 15 |
529418 | 529418 | 2020-09-13 | Perry | Mississippi | 28111 | 374 | 15 |
532654 | 532654 | 2020-09-14 | Perry | Mississippi | 28111 | 374 | 15 |
535889 | 535889 | 2020-09-15 | Perry | Mississippi | 28111 | 377 | 16 |
539126 | 539126 | 2020-09-16 | Perry | Mississippi | 28111 | 382 | 16 |
542362 | 542362 | 2020-09-17 | Perry | Mississippi | 28111 | 390 | 16 |
545599 | 545599 | 2020-09-18 | Perry | Mississippi | 28111 | 394 | 17 |
548837 | 548837 | 2020-09-19 | Perry | Mississippi | 28111 | 406 | 17 |
552076 | 552076 | 2020-09-20 | Perry | Mississippi | 28111 | 407 | 18 |
555314 | 555314 | 2020-09-21 | Perry | Mississippi | 28111 | 409 | 18 |
558551 | 558551 | 2020-09-22 | Perry | Mississippi | 28111 | 413 | 18 |
561788 | 561788 | 2020-09-23 | Perry | Mississippi | 28111 | 416 | 18 |
565028 | 565028 | 2020-09-24 | Perry | Mississippi | 28111 | 419 | 18 |
568268 | 568268 | 2020-09-25 | Perry | Mississippi | 28111 | 423 | 19 |
571510 | 571510 | 2020-09-26 | Perry | Mississippi | 28111 | 424 | 19 |
574753 | 574753 | 2020-09-27 | Perry | Mississippi | 28111 | 424 | 19 |
577994 | 577994 | 2020-09-28 | Perry | Mississippi | 28111 | 424 | 19 |
581235 | 581235 | 2020-09-29 | Perry | Mississippi | 28111 | 428 | 21 |
584476 | 584476 | 2020-09-30 | Perry | Mississippi | 28111 | 432 | 21 |
587716 | 587716 | 2020-10-01 | Perry | Mississippi | 28111 | 436 | 21 |
590957 | 590957 | 2020-10-02 | Perry | Mississippi | 28111 | 438 | 21 |
594198 | 594198 | 2020-10-03 | Perry | Mississippi | 28111 | 441 | 21 |
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);