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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536369 | 536369 | 2020-09-15 | Johnston | North Carolina | 37101 | 4227 | 54 |
533133 | 533133 | 2020-09-14 | Johnston | North Carolina | 37101 | 4209 | 54 |
529898 | 529898 | 2020-09-13 | Johnston | North Carolina | 37101 | 4167 | 54 |
526661 | 526661 | 2020-09-12 | Johnston | North Carolina | 37101 | 4167 | 54 |
523425 | 523425 | 2020-09-11 | Johnston | North Carolina | 37101 | 4167 | 54 |
520189 | 520189 | 2020-09-10 | Johnston | North Carolina | 37101 | 4144 | 54 |
516953 | 516953 | 2020-09-09 | Johnston | North Carolina | 37101 | 4120 | 54 |
513718 | 513718 | 2020-09-08 | Johnston | North Carolina | 37101 | 4109 | 52 |
510485 | 510485 | 2020-09-07 | Johnston | North Carolina | 37101 | 4034 | 52 |
507252 | 507252 | 2020-09-06 | Johnston | North Carolina | 37101 | 4034 | 52 |
504020 | 504020 | 2020-09-05 | Johnston | North Carolina | 37101 | 4034 | 52 |
500786 | 500786 | 2020-09-04 | Johnston | North Carolina | 37101 | 4034 | 52 |
497552 | 497552 | 2020-09-03 | Johnston | North Carolina | 37101 | 4016 | 52 |
494319 | 494319 | 2020-09-02 | Johnston | North Carolina | 37101 | 3960 | 52 |
491085 | 491085 | 2020-09-01 | Johnston | North Carolina | 37101 | 3928 | 52 |
487852 | 487852 | 2020-08-31 | Johnston | North Carolina | 37101 | 3888 | 52 |
484619 | 484619 | 2020-08-30 | Johnston | North Carolina | 37101 | 3806 | 50 |
481384 | 481384 | 2020-08-29 | Johnston | North Carolina | 37101 | 3806 | 50 |
478151 | 478151 | 2020-08-28 | Johnston | North Carolina | 37101 | 3806 | 50 |
474918 | 474918 | 2020-08-27 | Johnston | North Carolina | 37101 | 3790 | 50 |
471684 | 471684 | 2020-08-26 | Johnston | North Carolina | 37101 | 3754 | 50 |
468452 | 468452 | 2020-08-25 | Johnston | North Carolina | 37101 | 3710 | 50 |
465224 | 465224 | 2020-08-24 | Johnston | North Carolina | 37101 | 3658 | 50 |
461995 | 461995 | 2020-08-23 | Johnston | North Carolina | 37101 | 3595 | 50 |
458767 | 458767 | 2020-08-22 | Johnston | North Carolina | 37101 | 3589 | 50 |
455539 | 455539 | 2020-08-21 | Johnston | North Carolina | 37101 | 3589 | 50 |
452311 | 452311 | 2020-08-20 | Johnston | North Carolina | 37101 | 3555 | 50 |
449083 | 449083 | 2020-08-19 | Johnston | North Carolina | 37101 | 3525 | 50 |
445855 | 445855 | 2020-08-18 | Johnston | North Carolina | 37101 | 3479 | 49 |
442629 | 442629 | 2020-08-17 | Johnston | North Carolina | 37101 | 3466 | 49 |
439402 | 439402 | 2020-08-16 | Johnston | North Carolina | 37101 | 3435 | 47 |
436177 | 436177 | 2020-08-15 | Johnston | North Carolina | 37101 | 3426 | 47 |
432951 | 432951 | 2020-08-14 | Johnston | North Carolina | 37101 | 3426 | 47 |
429725 | 429725 | 2020-08-13 | Johnston | North Carolina | 37101 | 3407 | 47 |
426500 | 426500 | 2020-08-12 | Johnston | North Carolina | 37101 | 3381 | 47 |
423277 | 423277 | 2020-08-11 | Johnston | North Carolina | 37101 | 3338 | 47 |
420054 | 420054 | 2020-08-10 | Johnston | North Carolina | 37101 | 3322 | 47 |
416834 | 416834 | 2020-08-09 | Johnston | North Carolina | 37101 | 3304 | 46 |
413613 | 413613 | 2020-08-08 | Johnston | North Carolina | 37101 | 3275 | 46 |
410393 | 410393 | 2020-08-07 | Johnston | North Carolina | 37101 | 3252 | 46 |
407173 | 407173 | 2020-08-06 | Johnston | North Carolina | 37101 | 3182 | 46 |
403954 | 403954 | 2020-08-05 | Johnston | North Carolina | 37101 | 3148 | 46 |
400736 | 400736 | 2020-08-04 | Johnston | North Carolina | 37101 | 3117 | 44 |
397521 | 397521 | 2020-08-03 | Johnston | North Carolina | 37101 | 3085 | 44 |
394304 | 394304 | 2020-08-02 | Johnston | North Carolina | 37101 | 3057 | 44 |
391088 | 391088 | 2020-08-01 | Johnston | North Carolina | 37101 | 3000 | 44 |
387871 | 387871 | 2020-07-31 | Johnston | North Carolina | 37101 | 2964 | 44 |
384654 | 384654 | 2020-07-30 | Johnston | North Carolina | 37101 | 2899 | 44 |
381436 | 381436 | 2020-07-29 | Johnston | North Carolina | 37101 | 2844 | 44 |
378219 | 378219 | 2020-07-28 | Johnston | North Carolina | 37101 | 2788 | 44 |
375003 | 375003 | 2020-07-27 | Johnston | North Carolina | 37101 | 2692 | 43 |
371791 | 371791 | 2020-07-26 | Johnston | North Carolina | 37101 | 2620 | 43 |
368579 | 368579 | 2020-07-25 | Johnston | North Carolina | 37101 | 2595 | 43 |
365370 | 365370 | 2020-07-24 | Johnston | North Carolina | 37101 | 2559 | 42 |
362164 | 362164 | 2020-07-23 | Johnston | North Carolina | 37101 | 2522 | 42 |
358958 | 358958 | 2020-07-22 | Johnston | North Carolina | 37101 | 2490 | 42 |
355754 | 355754 | 2020-07-21 | Johnston | North Carolina | 37101 | 2437 | 41 |
352551 | 352551 | 2020-07-20 | Johnston | North Carolina | 37101 | 2406 | 41 |
349348 | 349348 | 2020-07-19 | Johnston | North Carolina | 37101 | 2386 | 39 |
346147 | 346147 | 2020-07-18 | Johnston | North Carolina | 37101 | 2349 | 39 |
342948 | 342948 | 2020-07-17 | Johnston | North Carolina | 37101 | 2295 | 39 |
339750 | 339750 | 2020-07-16 | Johnston | North Carolina | 37101 | 2255 | 38 |
336554 | 336554 | 2020-07-15 | Johnston | North Carolina | 37101 | 2218 | 38 |
333360 | 333360 | 2020-07-14 | Johnston | North Carolina | 37101 | 2160 | 38 |
330170 | 330170 | 2020-07-13 | Johnston | North Carolina | 37101 | 2091 | 38 |
326983 | 326983 | 2020-07-12 | Johnston | North Carolina | 37101 | 2044 | 35 |
323799 | 323799 | 2020-07-11 | Johnston | North Carolina | 37101 | 1980 | 35 |
320619 | 320619 | 2020-07-10 | Johnston | North Carolina | 37101 | 1934 | 35 |
317442 | 317442 | 2020-07-09 | Johnston | North Carolina | 37101 | 1891 | 35 |
314268 | 314268 | 2020-07-08 | Johnston | North Carolina | 37101 | 1862 | 34 |
311097 | 311097 | 2020-07-07 | Johnston | North Carolina | 37101 | 1821 | 33 |
307929 | 307929 | 2020-07-06 | Johnston | North Carolina | 37101 | 1786 | 33 |
304762 | 304762 | 2020-07-05 | Johnston | North Carolina | 37101 | 1715 | 33 |
301599 | 301599 | 2020-07-04 | Johnston | North Carolina | 37101 | 1685 | 33 |
298436 | 298436 | 2020-07-03 | Johnston | North Carolina | 37101 | 1641 | 33 |
295276 | 295276 | 2020-07-02 | Johnston | North Carolina | 37101 | 1634 | 33 |
292121 | 292121 | 2020-07-01 | Johnston | North Carolina | 37101 | 1565 | 32 |
288969 | 288969 | 2020-06-30 | Johnston | North Carolina | 37101 | 1541 | 32 |
285819 | 285819 | 2020-06-29 | Johnston | North Carolina | 37101 | 1475 | 31 |
282674 | 282674 | 2020-06-28 | Johnston | North Carolina | 37101 | 1393 | 29 |
279528 | 279528 | 2020-06-27 | Johnston | North Carolina | 37101 | 1346 | 29 |
276380 | 276380 | 2020-06-26 | Johnston | North Carolina | 37101 | 1344 | 29 |
273234 | 273234 | 2020-06-25 | Johnston | North Carolina | 37101 | 1284 | 29 |
270095 | 270095 | 2020-06-24 | Johnston | North Carolina | 37101 | 1248 | 29 |
266961 | 266961 | 2020-06-23 | Johnston | North Carolina | 37101 | 1208 | 29 |
263833 | 263833 | 2020-06-22 | Johnston | North Carolina | 37101 | 1178 | 28 |
260705 | 260705 | 2020-06-21 | Johnston | North Carolina | 37101 | 1111 | 26 |
257578 | 257578 | 2020-06-20 | Johnston | North Carolina | 37101 | 1058 | 26 |
254455 | 254455 | 2020-06-19 | Johnston | North Carolina | 37101 | 1037 | 26 |
251340 | 251340 | 2020-06-18 | Johnston | North Carolina | 37101 | 1000 | 26 |
248225 | 248225 | 2020-06-17 | Johnston | North Carolina | 37101 | 972 | 26 |
245112 | 245112 | 2020-06-16 | Johnston | North Carolina | 37101 | 935 | 25 |
242000 | 242000 | 2020-06-15 | Johnston | North Carolina | 37101 | 903 | 25 |
238891 | 238891 | 2020-06-14 | Johnston | North Carolina | 37101 | 849 | 25 |
235783 | 235783 | 2020-06-13 | Johnston | North Carolina | 37101 | 804 | 25 |
232678 | 232678 | 2020-06-12 | Johnston | North Carolina | 37101 | 804 | 25 |
229573 | 229573 | 2020-06-11 | Johnston | North Carolina | 37101 | 699 | 24 |
226469 | 226469 | 2020-06-10 | Johnston | North Carolina | 37101 | 677 | 23 |
223369 | 223369 | 2020-06-09 | Johnston | North Carolina | 37101 | 669 | 23 |
220275 | 220275 | 2020-06-08 | Johnston | North Carolina | 37101 | 648 | 23 |
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);