ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 37191 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 |
---|---|---|---|---|---|---|---|
536414 | 536414 | 2020-09-15 | Wayne | North Carolina | 37191 | 3046 | 62 |
533178 | 533178 | 2020-09-14 | Wayne | North Carolina | 37191 | 3032 | 62 |
529943 | 529943 | 2020-09-13 | Wayne | North Carolina | 37191 | 3026 | 62 |
526706 | 526706 | 2020-09-12 | Wayne | North Carolina | 37191 | 3002 | 62 |
523470 | 523470 | 2020-09-11 | Wayne | North Carolina | 37191 | 2981 | 62 |
520234 | 520234 | 2020-09-10 | Wayne | North Carolina | 37191 | 2970 | 61 |
516998 | 516998 | 2020-09-09 | Wayne | North Carolina | 37191 | 2946 | 60 |
513763 | 513763 | 2020-09-08 | Wayne | North Carolina | 37191 | 2931 | 57 |
510530 | 510530 | 2020-09-07 | Wayne | North Carolina | 37191 | 2926 | 57 |
507297 | 507297 | 2020-09-06 | Wayne | North Carolina | 37191 | 2916 | 57 |
504065 | 504065 | 2020-09-05 | Wayne | North Carolina | 37191 | 2902 | 57 |
500831 | 500831 | 2020-09-04 | Wayne | North Carolina | 37191 | 2883 | 56 |
497597 | 497597 | 2020-09-03 | Wayne | North Carolina | 37191 | 2859 | 56 |
494364 | 494364 | 2020-09-02 | Wayne | North Carolina | 37191 | 2841 | 55 |
491130 | 491130 | 2020-09-01 | Wayne | North Carolina | 37191 | 2830 | 53 |
487897 | 487897 | 2020-08-31 | Wayne | North Carolina | 37191 | 2820 | 51 |
484664 | 484664 | 2020-08-30 | Wayne | North Carolina | 37191 | 2812 | 51 |
481429 | 481429 | 2020-08-29 | Wayne | North Carolina | 37191 | 2799 | 51 |
478196 | 478196 | 2020-08-28 | Wayne | North Carolina | 37191 | 2767 | 51 |
474963 | 474963 | 2020-08-27 | Wayne | North Carolina | 37191 | 2751 | 51 |
471729 | 471729 | 2020-08-26 | Wayne | North Carolina | 37191 | 2717 | 51 |
468497 | 468497 | 2020-08-25 | Wayne | North Carolina | 37191 | 2712 | 50 |
465269 | 465269 | 2020-08-24 | Wayne | North Carolina | 37191 | 2681 | 46 |
462040 | 462040 | 2020-08-23 | Wayne | North Carolina | 37191 | 2672 | 46 |
458812 | 458812 | 2020-08-22 | Wayne | North Carolina | 37191 | 2660 | 46 |
455584 | 455584 | 2020-08-21 | Wayne | North Carolina | 37191 | 2634 | 44 |
452356 | 452356 | 2020-08-20 | Wayne | North Carolina | 37191 | 2618 | 44 |
449128 | 449128 | 2020-08-19 | Wayne | North Carolina | 37191 | 2583 | 44 |
445900 | 445900 | 2020-08-18 | Wayne | North Carolina | 37191 | 2555 | 43 |
442674 | 442674 | 2020-08-17 | Wayne | North Carolina | 37191 | 2532 | 42 |
439447 | 439447 | 2020-08-16 | Wayne | North Carolina | 37191 | 2527 | 42 |
436222 | 436222 | 2020-08-15 | Wayne | North Carolina | 37191 | 2515 | 42 |
432996 | 432996 | 2020-08-14 | Wayne | North Carolina | 37191 | 2485 | 42 |
429770 | 429770 | 2020-08-13 | Wayne | North Carolina | 37191 | 2463 | 42 |
426545 | 426545 | 2020-08-12 | Wayne | North Carolina | 37191 | 2445 | 42 |
423322 | 423322 | 2020-08-11 | Wayne | North Carolina | 37191 | 2435 | 42 |
420099 | 420099 | 2020-08-10 | Wayne | North Carolina | 37191 | 2424 | 42 |
416879 | 416879 | 2020-08-09 | Wayne | North Carolina | 37191 | 2412 | 42 |
413658 | 413658 | 2020-08-08 | Wayne | North Carolina | 37191 | 2395 | 42 |
410438 | 410438 | 2020-08-07 | Wayne | North Carolina | 37191 | 2373 | 40 |
407218 | 407218 | 2020-08-06 | Wayne | North Carolina | 37191 | 2361 | 40 |
403999 | 403999 | 2020-08-05 | Wayne | North Carolina | 37191 | 2335 | 40 |
400781 | 400781 | 2020-08-04 | Wayne | North Carolina | 37191 | 2330 | 37 |
397566 | 397566 | 2020-08-03 | Wayne | North Carolina | 37191 | 2328 | 37 |
394349 | 394349 | 2020-08-02 | Wayne | North Carolina | 37191 | 2312 | 37 |
391133 | 391133 | 2020-08-01 | Wayne | North Carolina | 37191 | 2299 | 37 |
387916 | 387916 | 2020-07-31 | Wayne | North Carolina | 37191 | 2282 | 37 |
384699 | 384699 | 2020-07-30 | Wayne | North Carolina | 37191 | 2262 | 37 |
381481 | 381481 | 2020-07-29 | Wayne | North Carolina | 37191 | 2249 | 36 |
378264 | 378264 | 2020-07-28 | Wayne | North Carolina | 37191 | 2233 | 36 |
375048 | 375048 | 2020-07-27 | Wayne | North Carolina | 37191 | 2215 | 36 |
371836 | 371836 | 2020-07-26 | Wayne | North Carolina | 37191 | 2207 | 36 |
368624 | 368624 | 2020-07-25 | Wayne | North Carolina | 37191 | 2195 | 36 |
365415 | 365415 | 2020-07-24 | Wayne | North Carolina | 37191 | 2179 | 36 |
362209 | 362209 | 2020-07-23 | Wayne | North Carolina | 37191 | 2155 | 35 |
359003 | 359003 | 2020-07-22 | Wayne | North Carolina | 37191 | 2142 | 35 |
355799 | 355799 | 2020-07-21 | Wayne | North Carolina | 37191 | 2123 | 35 |
352596 | 352596 | 2020-07-20 | Wayne | North Carolina | 37191 | 2103 | 34 |
349393 | 349393 | 2020-07-19 | Wayne | North Carolina | 37191 | 2100 | 34 |
346192 | 346192 | 2020-07-18 | Wayne | North Carolina | 37191 | 2082 | 34 |
342993 | 342993 | 2020-07-17 | Wayne | North Carolina | 37191 | 2071 | 34 |
339795 | 339795 | 2020-07-16 | Wayne | North Carolina | 37191 | 2055 | 34 |
336599 | 336599 | 2020-07-15 | Wayne | North Carolina | 37191 | 2039 | 34 |
333405 | 333405 | 2020-07-14 | Wayne | North Carolina | 37191 | 2021 | 32 |
330215 | 330215 | 2020-07-13 | Wayne | North Carolina | 37191 | 2006 | 30 |
327028 | 327028 | 2020-07-12 | Wayne | North Carolina | 37191 | 1990 | 30 |
323844 | 323844 | 2020-07-11 | Wayne | North Carolina | 37191 | 1980 | 30 |
320664 | 320664 | 2020-07-10 | Wayne | North Carolina | 37191 | 1964 | 30 |
317487 | 317487 | 2020-07-09 | Wayne | North Carolina | 37191 | 1942 | 30 |
314313 | 314313 | 2020-07-08 | Wayne | North Carolina | 37191 | 1935 | 30 |
311142 | 311142 | 2020-07-07 | Wayne | North Carolina | 37191 | 1926 | 29 |
307974 | 307974 | 2020-07-06 | Wayne | North Carolina | 37191 | 1913 | 28 |
304807 | 304807 | 2020-07-05 | Wayne | North Carolina | 37191 | 1897 | 28 |
301644 | 301644 | 2020-07-04 | Wayne | North Carolina | 37191 | 1879 | 28 |
298481 | 298481 | 2020-07-03 | Wayne | North Carolina | 37191 | 1864 | 28 |
295321 | 295321 | 2020-07-02 | Wayne | North Carolina | 37191 | 1847 | 28 |
292166 | 292166 | 2020-07-01 | Wayne | North Carolina | 37191 | 1822 | 28 |
289014 | 289014 | 2020-06-30 | Wayne | North Carolina | 37191 | 1802 | 26 |
285864 | 285864 | 2020-06-29 | Wayne | North Carolina | 37191 | 1795 | 25 |
282719 | 282719 | 2020-06-28 | Wayne | North Carolina | 37191 | 1767 | 25 |
279573 | 279573 | 2020-06-27 | Wayne | North Carolina | 37191 | 1740 | 25 |
276425 | 276425 | 2020-06-26 | Wayne | North Carolina | 37191 | 1724 | 24 |
273279 | 273279 | 2020-06-25 | Wayne | North Carolina | 37191 | 1712 | 24 |
270140 | 270140 | 2020-06-24 | Wayne | North Carolina | 37191 | 1703 | 24 |
267006 | 267006 | 2020-06-23 | Wayne | North Carolina | 37191 | 1673 | 23 |
263878 | 263878 | 2020-06-22 | Wayne | North Carolina | 37191 | 1658 | 23 |
260750 | 260750 | 2020-06-21 | Wayne | North Carolina | 37191 | 1643 | 23 |
257623 | 257623 | 2020-06-20 | Wayne | North Carolina | 37191 | 1622 | 22 |
254500 | 254500 | 2020-06-19 | Wayne | North Carolina | 37191 | 1587 | 21 |
251385 | 251385 | 2020-06-18 | Wayne | North Carolina | 37191 | 1565 | 20 |
248270 | 248270 | 2020-06-17 | Wayne | North Carolina | 37191 | 1540 | 20 |
245157 | 245157 | 2020-06-16 | Wayne | North Carolina | 37191 | 1535 | 20 |
242045 | 242045 | 2020-06-15 | Wayne | North Carolina | 37191 | 1533 | 20 |
238936 | 238936 | 2020-06-14 | Wayne | North Carolina | 37191 | 1512 | 20 |
235828 | 235828 | 2020-06-13 | Wayne | North Carolina | 37191 | 1467 | 20 |
232723 | 232723 | 2020-06-12 | Wayne | North Carolina | 37191 | 1448 | 20 |
229618 | 229618 | 2020-06-11 | Wayne | North Carolina | 37191 | 1403 | 20 |
226514 | 226514 | 2020-06-10 | Wayne | North Carolina | 37191 | 1367 | 20 |
223414 | 223414 | 2020-06-09 | Wayne | North Carolina | 37191 | 1337 | 20 |
220320 | 220320 | 2020-06-08 | Wayne | North Carolina | 37191 | 1335 | 20 |
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);