ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37129 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 |
---|---|---|---|---|---|---|---|
536383 | 536383 | 2020-09-15 | New Hanover | North Carolina | 37129 | 3710 | 26 |
533147 | 533147 | 2020-09-14 | New Hanover | North Carolina | 37129 | 3679 | 25 |
529912 | 529912 | 2020-09-13 | New Hanover | North Carolina | 37129 | 3655 | 25 |
526675 | 526675 | 2020-09-12 | New Hanover | North Carolina | 37129 | 3609 | 25 |
523439 | 523439 | 2020-09-11 | New Hanover | North Carolina | 37129 | 3572 | 25 |
520203 | 520203 | 2020-09-10 | New Hanover | North Carolina | 37129 | 3548 | 24 |
516967 | 516967 | 2020-09-09 | New Hanover | North Carolina | 37129 | 3488 | 24 |
513732 | 513732 | 2020-09-08 | New Hanover | North Carolina | 37129 | 3461 | 24 |
510499 | 510499 | 2020-09-07 | New Hanover | North Carolina | 37129 | 3413 | 24 |
507266 | 507266 | 2020-09-06 | New Hanover | North Carolina | 37129 | 3360 | 24 |
504034 | 504034 | 2020-09-05 | New Hanover | North Carolina | 37129 | 3317 | 24 |
500800 | 500800 | 2020-09-04 | New Hanover | North Carolina | 37129 | 3281 | 23 |
497566 | 497566 | 2020-09-03 | New Hanover | North Carolina | 37129 | 3214 | 23 |
494333 | 494333 | 2020-09-02 | New Hanover | North Carolina | 37129 | 3154 | 23 |
491099 | 491099 | 2020-09-01 | New Hanover | North Carolina | 37129 | 3122 | 21 |
487866 | 487866 | 2020-08-31 | New Hanover | North Carolina | 37129 | 3031 | 21 |
484633 | 484633 | 2020-08-30 | New Hanover | North Carolina | 37129 | 3004 | 21 |
481398 | 481398 | 2020-08-29 | New Hanover | North Carolina | 37129 | 2976 | 21 |
478165 | 478165 | 2020-08-28 | New Hanover | North Carolina | 37129 | 2917 | 21 |
474932 | 474932 | 2020-08-27 | New Hanover | North Carolina | 37129 | 2903 | 21 |
471698 | 471698 | 2020-08-26 | New Hanover | North Carolina | 37129 | 2884 | 21 |
468466 | 468466 | 2020-08-25 | New Hanover | North Carolina | 37129 | 2865 | 21 |
465238 | 465238 | 2020-08-24 | New Hanover | North Carolina | 37129 | 2846 | 21 |
462009 | 462009 | 2020-08-23 | New Hanover | North Carolina | 37129 | 2840 | 21 |
458781 | 458781 | 2020-08-22 | New Hanover | North Carolina | 37129 | 2827 | 21 |
455553 | 455553 | 2020-08-21 | New Hanover | North Carolina | 37129 | 2803 | 21 |
452325 | 452325 | 2020-08-20 | New Hanover | North Carolina | 37129 | 2770 | 21 |
449097 | 449097 | 2020-08-19 | New Hanover | North Carolina | 37129 | 2736 | 21 |
445869 | 445869 | 2020-08-18 | New Hanover | North Carolina | 37129 | 2729 | 21 |
442643 | 442643 | 2020-08-17 | New Hanover | North Carolina | 37129 | 2710 | 21 |
439416 | 439416 | 2020-08-16 | New Hanover | North Carolina | 37129 | 2704 | 21 |
436191 | 436191 | 2020-08-15 | New Hanover | North Carolina | 37129 | 2692 | 21 |
432965 | 432965 | 2020-08-14 | New Hanover | North Carolina | 37129 | 2666 | 21 |
429739 | 429739 | 2020-08-13 | New Hanover | North Carolina | 37129 | 2644 | 21 |
426514 | 426514 | 2020-08-12 | New Hanover | North Carolina | 37129 | 2617 | 20 |
423291 | 423291 | 2020-08-11 | New Hanover | North Carolina | 37129 | 2578 | 20 |
420068 | 420068 | 2020-08-10 | New Hanover | North Carolina | 37129 | 2544 | 20 |
416848 | 416848 | 2020-08-09 | New Hanover | North Carolina | 37129 | 2531 | 20 |
413627 | 413627 | 2020-08-08 | New Hanover | North Carolina | 37129 | 2513 | 20 |
410407 | 410407 | 2020-08-07 | New Hanover | North Carolina | 37129 | 2467 | 20 |
407187 | 407187 | 2020-08-06 | New Hanover | North Carolina | 37129 | 2451 | 20 |
403968 | 403968 | 2020-08-05 | New Hanover | North Carolina | 37129 | 2419 | 20 |
400750 | 400750 | 2020-08-04 | New Hanover | North Carolina | 37129 | 2397 | 19 |
397535 | 397535 | 2020-08-03 | New Hanover | North Carolina | 37129 | 2358 | 19 |
394318 | 394318 | 2020-08-02 | New Hanover | North Carolina | 37129 | 2337 | 19 |
391102 | 391102 | 2020-08-01 | New Hanover | North Carolina | 37129 | 2322 | 19 |
387885 | 387885 | 2020-07-31 | New Hanover | North Carolina | 37129 | 2285 | 19 |
384668 | 384668 | 2020-07-30 | New Hanover | North Carolina | 37129 | 2254 | 18 |
381450 | 381450 | 2020-07-29 | New Hanover | North Carolina | 37129 | 2198 | 18 |
378233 | 378233 | 2020-07-28 | New Hanover | North Carolina | 37129 | 2160 | 17 |
375017 | 375017 | 2020-07-27 | New Hanover | North Carolina | 37129 | 2119 | 15 |
371805 | 371805 | 2020-07-26 | New Hanover | North Carolina | 37129 | 2086 | 15 |
368593 | 368593 | 2020-07-25 | New Hanover | North Carolina | 37129 | 2052 | 15 |
365384 | 365384 | 2020-07-24 | New Hanover | North Carolina | 37129 | 2011 | 14 |
362178 | 362178 | 2020-07-23 | New Hanover | North Carolina | 37129 | 1969 | 14 |
358972 | 358972 | 2020-07-22 | New Hanover | North Carolina | 37129 | 1932 | 14 |
355768 | 355768 | 2020-07-21 | New Hanover | North Carolina | 37129 | 1889 | 14 |
352565 | 352565 | 2020-07-20 | New Hanover | North Carolina | 37129 | 1792 | 11 |
349362 | 349362 | 2020-07-19 | New Hanover | North Carolina | 37129 | 1779 | 11 |
346161 | 346161 | 2020-07-18 | New Hanover | North Carolina | 37129 | 1752 | 11 |
342962 | 342962 | 2020-07-17 | New Hanover | North Carolina | 37129 | 1712 | 9 |
339764 | 339764 | 2020-07-16 | New Hanover | North Carolina | 37129 | 1652 | 8 |
336568 | 336568 | 2020-07-15 | New Hanover | North Carolina | 37129 | 1594 | 8 |
333374 | 333374 | 2020-07-14 | New Hanover | North Carolina | 37129 | 1560 | 8 |
330184 | 330184 | 2020-07-13 | New Hanover | North Carolina | 37129 | 1484 | 7 |
326997 | 326997 | 2020-07-12 | New Hanover | North Carolina | 37129 | 1451 | 7 |
323813 | 323813 | 2020-07-11 | New Hanover | North Carolina | 37129 | 1438 | 8 |
320633 | 320633 | 2020-07-10 | New Hanover | North Carolina | 37129 | 1342 | 7 |
317456 | 317456 | 2020-07-09 | New Hanover | North Carolina | 37129 | 1304 | 7 |
314282 | 314282 | 2020-07-08 | New Hanover | North Carolina | 37129 | 1242 | 7 |
311111 | 311111 | 2020-07-07 | New Hanover | North Carolina | 37129 | 1161 | 7 |
307943 | 307943 | 2020-07-06 | New Hanover | North Carolina | 37129 | 1138 | 7 |
304776 | 304776 | 2020-07-05 | New Hanover | North Carolina | 37129 | 1118 | 7 |
301613 | 301613 | 2020-07-04 | New Hanover | North Carolina | 37129 | 1095 | 7 |
298450 | 298450 | 2020-07-03 | New Hanover | North Carolina | 37129 | 1063 | 7 |
295290 | 295290 | 2020-07-02 | New Hanover | North Carolina | 37129 | 982 | 6 |
292135 | 292135 | 2020-07-01 | New Hanover | North Carolina | 37129 | 923 | 5 |
288983 | 288983 | 2020-06-30 | New Hanover | North Carolina | 37129 | 897 | 5 |
285833 | 285833 | 2020-06-29 | New Hanover | North Carolina | 37129 | 840 | 5 |
282688 | 282688 | 2020-06-28 | New Hanover | North Carolina | 37129 | 810 | 5 |
279542 | 279542 | 2020-06-27 | New Hanover | North Carolina | 37129 | 750 | 5 |
276394 | 276394 | 2020-06-26 | New Hanover | North Carolina | 37129 | 717 | 5 |
273248 | 273248 | 2020-06-25 | New Hanover | North Carolina | 37129 | 673 | 5 |
270109 | 270109 | 2020-06-24 | New Hanover | North Carolina | 37129 | 626 | 5 |
266975 | 266975 | 2020-06-23 | New Hanover | North Carolina | 37129 | 587 | 5 |
263847 | 263847 | 2020-06-22 | New Hanover | North Carolina | 37129 | 563 | 5 |
260719 | 260719 | 2020-06-21 | New Hanover | North Carolina | 37129 | 557 | 5 |
257592 | 257592 | 2020-06-20 | New Hanover | North Carolina | 37129 | 535 | 5 |
254469 | 254469 | 2020-06-19 | New Hanover | North Carolina | 37129 | 489 | 5 |
251354 | 251354 | 2020-06-18 | New Hanover | North Carolina | 37129 | 449 | 5 |
248239 | 248239 | 2020-06-17 | New Hanover | North Carolina | 37129 | 414 | 5 |
245126 | 245126 | 2020-06-16 | New Hanover | North Carolina | 37129 | 405 | 5 |
242014 | 242014 | 2020-06-15 | New Hanover | North Carolina | 37129 | 385 | 5 |
238905 | 238905 | 2020-06-14 | New Hanover | North Carolina | 37129 | 356 | 5 |
235797 | 235797 | 2020-06-13 | New Hanover | North Carolina | 37129 | 334 | 5 |
232692 | 232692 | 2020-06-12 | New Hanover | North Carolina | 37129 | 311 | 5 |
229587 | 229587 | 2020-06-11 | New Hanover | North Carolina | 37129 | 291 | 5 |
226483 | 226483 | 2020-06-10 | New Hanover | North Carolina | 37129 | 281 | 5 |
223383 | 223383 | 2020-06-09 | New Hanover | North Carolina | 37129 | 269 | 5 |
220289 | 220289 | 2020-06-08 | New Hanover | North Carolina | 37129 | 263 | 5 |
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);