ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37101 and state = "North Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
257578 | 257578 | 2020-06-20 | Johnston | North Carolina | 37101 | 1058 | 26 |
260705 | 260705 | 2020-06-21 | Johnston | North Carolina | 37101 | 1111 | 26 |
263833 | 263833 | 2020-06-22 | Johnston | North Carolina | 37101 | 1178 | 28 |
266961 | 266961 | 2020-06-23 | Johnston | North Carolina | 37101 | 1208 | 29 |
270095 | 270095 | 2020-06-24 | Johnston | North Carolina | 37101 | 1248 | 29 |
273234 | 273234 | 2020-06-25 | Johnston | North Carolina | 37101 | 1284 | 29 |
276380 | 276380 | 2020-06-26 | Johnston | North Carolina | 37101 | 1344 | 29 |
279528 | 279528 | 2020-06-27 | Johnston | North Carolina | 37101 | 1346 | 29 |
282674 | 282674 | 2020-06-28 | Johnston | North Carolina | 37101 | 1393 | 29 |
285819 | 285819 | 2020-06-29 | Johnston | North Carolina | 37101 | 1475 | 31 |
288969 | 288969 | 2020-06-30 | Johnston | North Carolina | 37101 | 1541 | 32 |
292121 | 292121 | 2020-07-01 | Johnston | North Carolina | 37101 | 1565 | 32 |
295276 | 295276 | 2020-07-02 | Johnston | North Carolina | 37101 | 1634 | 33 |
298436 | 298436 | 2020-07-03 | Johnston | North Carolina | 37101 | 1641 | 33 |
301599 | 301599 | 2020-07-04 | Johnston | North Carolina | 37101 | 1685 | 33 |
304762 | 304762 | 2020-07-05 | Johnston | North Carolina | 37101 | 1715 | 33 |
307929 | 307929 | 2020-07-06 | Johnston | North Carolina | 37101 | 1786 | 33 |
311097 | 311097 | 2020-07-07 | Johnston | North Carolina | 37101 | 1821 | 33 |
314268 | 314268 | 2020-07-08 | Johnston | North Carolina | 37101 | 1862 | 34 |
317442 | 317442 | 2020-07-09 | Johnston | North Carolina | 37101 | 1891 | 35 |
320619 | 320619 | 2020-07-10 | Johnston | North Carolina | 37101 | 1934 | 35 |
323799 | 323799 | 2020-07-11 | Johnston | North Carolina | 37101 | 1980 | 35 |
326983 | 326983 | 2020-07-12 | Johnston | North Carolina | 37101 | 2044 | 35 |
330170 | 330170 | 2020-07-13 | Johnston | North Carolina | 37101 | 2091 | 38 |
333360 | 333360 | 2020-07-14 | Johnston | North Carolina | 37101 | 2160 | 38 |
336554 | 336554 | 2020-07-15 | Johnston | North Carolina | 37101 | 2218 | 38 |
339750 | 339750 | 2020-07-16 | Johnston | North Carolina | 37101 | 2255 | 38 |
342948 | 342948 | 2020-07-17 | Johnston | North Carolina | 37101 | 2295 | 39 |
346147 | 346147 | 2020-07-18 | Johnston | North Carolina | 37101 | 2349 | 39 |
349348 | 349348 | 2020-07-19 | Johnston | North Carolina | 37101 | 2386 | 39 |
352551 | 352551 | 2020-07-20 | Johnston | North Carolina | 37101 | 2406 | 41 |
355754 | 355754 | 2020-07-21 | Johnston | North Carolina | 37101 | 2437 | 41 |
358958 | 358958 | 2020-07-22 | Johnston | North Carolina | 37101 | 2490 | 42 |
362164 | 362164 | 2020-07-23 | Johnston | North Carolina | 37101 | 2522 | 42 |
365370 | 365370 | 2020-07-24 | Johnston | North Carolina | 37101 | 2559 | 42 |
368579 | 368579 | 2020-07-25 | Johnston | North Carolina | 37101 | 2595 | 43 |
371791 | 371791 | 2020-07-26 | Johnston | North Carolina | 37101 | 2620 | 43 |
375003 | 375003 | 2020-07-27 | Johnston | North Carolina | 37101 | 2692 | 43 |
378219 | 378219 | 2020-07-28 | Johnston | North Carolina | 37101 | 2788 | 44 |
381436 | 381436 | 2020-07-29 | Johnston | North Carolina | 37101 | 2844 | 44 |
384654 | 384654 | 2020-07-30 | Johnston | North Carolina | 37101 | 2899 | 44 |
387871 | 387871 | 2020-07-31 | Johnston | North Carolina | 37101 | 2964 | 44 |
391088 | 391088 | 2020-08-01 | Johnston | North Carolina | 37101 | 3000 | 44 |
394304 | 394304 | 2020-08-02 | Johnston | North Carolina | 37101 | 3057 | 44 |
397521 | 397521 | 2020-08-03 | Johnston | North Carolina | 37101 | 3085 | 44 |
400736 | 400736 | 2020-08-04 | Johnston | North Carolina | 37101 | 3117 | 44 |
403954 | 403954 | 2020-08-05 | Johnston | North Carolina | 37101 | 3148 | 46 |
407173 | 407173 | 2020-08-06 | Johnston | North Carolina | 37101 | 3182 | 46 |
410393 | 410393 | 2020-08-07 | Johnston | North Carolina | 37101 | 3252 | 46 |
413613 | 413613 | 2020-08-08 | Johnston | North Carolina | 37101 | 3275 | 46 |
416834 | 416834 | 2020-08-09 | Johnston | North Carolina | 37101 | 3304 | 46 |
420054 | 420054 | 2020-08-10 | Johnston | North Carolina | 37101 | 3322 | 47 |
423277 | 423277 | 2020-08-11 | Johnston | North Carolina | 37101 | 3338 | 47 |
426500 | 426500 | 2020-08-12 | Johnston | North Carolina | 37101 | 3381 | 47 |
429725 | 429725 | 2020-08-13 | Johnston | North Carolina | 37101 | 3407 | 47 |
432951 | 432951 | 2020-08-14 | Johnston | North Carolina | 37101 | 3426 | 47 |
436177 | 436177 | 2020-08-15 | Johnston | North Carolina | 37101 | 3426 | 47 |
439402 | 439402 | 2020-08-16 | Johnston | North Carolina | 37101 | 3435 | 47 |
442629 | 442629 | 2020-08-17 | Johnston | North Carolina | 37101 | 3466 | 49 |
445855 | 445855 | 2020-08-18 | Johnston | North Carolina | 37101 | 3479 | 49 |
449083 | 449083 | 2020-08-19 | Johnston | North Carolina | 37101 | 3525 | 50 |
452311 | 452311 | 2020-08-20 | Johnston | North Carolina | 37101 | 3555 | 50 |
455539 | 455539 | 2020-08-21 | Johnston | North Carolina | 37101 | 3589 | 50 |
458767 | 458767 | 2020-08-22 | Johnston | North Carolina | 37101 | 3589 | 50 |
461995 | 461995 | 2020-08-23 | Johnston | North Carolina | 37101 | 3595 | 50 |
465224 | 465224 | 2020-08-24 | Johnston | North Carolina | 37101 | 3658 | 50 |
468452 | 468452 | 2020-08-25 | Johnston | North Carolina | 37101 | 3710 | 50 |
471684 | 471684 | 2020-08-26 | Johnston | North Carolina | 37101 | 3754 | 50 |
474918 | 474918 | 2020-08-27 | Johnston | North Carolina | 37101 | 3790 | 50 |
478151 | 478151 | 2020-08-28 | Johnston | North Carolina | 37101 | 3806 | 50 |
481384 | 481384 | 2020-08-29 | Johnston | North Carolina | 37101 | 3806 | 50 |
484619 | 484619 | 2020-08-30 | Johnston | North Carolina | 37101 | 3806 | 50 |
487852 | 487852 | 2020-08-31 | Johnston | North Carolina | 37101 | 3888 | 52 |
491085 | 491085 | 2020-09-01 | Johnston | North Carolina | 37101 | 3928 | 52 |
494319 | 494319 | 2020-09-02 | Johnston | North Carolina | 37101 | 3960 | 52 |
497552 | 497552 | 2020-09-03 | Johnston | North Carolina | 37101 | 4016 | 52 |
500786 | 500786 | 2020-09-04 | Johnston | North Carolina | 37101 | 4034 | 52 |
504020 | 504020 | 2020-09-05 | Johnston | North Carolina | 37101 | 4034 | 52 |
507252 | 507252 | 2020-09-06 | Johnston | North Carolina | 37101 | 4034 | 52 |
510485 | 510485 | 2020-09-07 | Johnston | North Carolina | 37101 | 4034 | 52 |
513718 | 513718 | 2020-09-08 | Johnston | North Carolina | 37101 | 4109 | 52 |
516953 | 516953 | 2020-09-09 | Johnston | North Carolina | 37101 | 4120 | 54 |
520189 | 520189 | 2020-09-10 | Johnston | North Carolina | 37101 | 4144 | 54 |
523425 | 523425 | 2020-09-11 | Johnston | North Carolina | 37101 | 4167 | 54 |
526661 | 526661 | 2020-09-12 | Johnston | North Carolina | 37101 | 4167 | 54 |
529898 | 529898 | 2020-09-13 | Johnston | North Carolina | 37101 | 4167 | 54 |
533133 | 533133 | 2020-09-14 | Johnston | North Carolina | 37101 | 4209 | 54 |
536369 | 536369 | 2020-09-15 | Johnston | North Carolina | 37101 | 4227 | 54 |
539606 | 539606 | 2020-09-16 | Johnston | North Carolina | 37101 | 4257 | 54 |
542842 | 542842 | 2020-09-17 | Johnston | North Carolina | 37101 | 4281 | 54 |
546079 | 546079 | 2020-09-18 | Johnston | North Carolina | 37101 | 4317 | 55 |
549318 | 549318 | 2020-09-19 | Johnston | North Carolina | 37101 | 4317 | 55 |
552557 | 552557 | 2020-09-20 | Johnston | North Carolina | 37101 | 4317 | 55 |
555794 | 555794 | 2020-09-21 | Johnston | North Carolina | 37101 | 4367 | 55 |
559031 | 559031 | 2020-09-22 | Johnston | North Carolina | 37101 | 4392 | 55 |
562268 | 562268 | 2020-09-23 | Johnston | North Carolina | 37101 | 4430 | 56 |
565509 | 565509 | 2020-09-24 | Johnston | North Carolina | 37101 | 4452 | 56 |
568750 | 568750 | 2020-09-25 | Johnston | North Carolina | 37101 | 4477 | 56 |
571992 | 571992 | 2020-09-26 | Johnston | North Carolina | 37101 | 4480 | 56 |
575236 | 575236 | 2020-09-27 | Johnston | North Carolina | 37101 | 4521 | 56 |
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);