ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37067 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 |
---|---|---|---|---|---|---|---|
533116 | 533116 | 2020-09-14 | Forsyth | North Carolina | 37067 | 6634 | 86 |
529881 | 529881 | 2020-09-13 | Forsyth | North Carolina | 37067 | 6617 | 86 |
526644 | 526644 | 2020-09-12 | Forsyth | North Carolina | 37067 | 6579 | 86 |
523408 | 523408 | 2020-09-11 | Forsyth | North Carolina | 37067 | 6543 | 84 |
520172 | 520172 | 2020-09-10 | Forsyth | North Carolina | 37067 | 6511 | 84 |
516936 | 516936 | 2020-09-09 | Forsyth | North Carolina | 37067 | 6481 | 84 |
513701 | 513701 | 2020-09-08 | Forsyth | North Carolina | 37067 | 6457 | 82 |
510468 | 510468 | 2020-09-07 | Forsyth | North Carolina | 37067 | 6432 | 82 |
507235 | 507235 | 2020-09-06 | Forsyth | North Carolina | 37067 | 6404 | 82 |
504003 | 504003 | 2020-09-05 | Forsyth | North Carolina | 37067 | 6374 | 82 |
500769 | 500769 | 2020-09-04 | Forsyth | North Carolina | 37067 | 6335 | 82 |
497535 | 497535 | 2020-09-03 | Forsyth | North Carolina | 37067 | 6287 | 82 |
494302 | 494302 | 2020-09-02 | Forsyth | North Carolina | 37067 | 6266 | 80 |
491068 | 491068 | 2020-09-01 | Forsyth | North Carolina | 37067 | 6220 | 76 |
487835 | 487835 | 2020-08-31 | Forsyth | North Carolina | 37067 | 6160 | 74 |
484602 | 484602 | 2020-08-30 | Forsyth | North Carolina | 37067 | 6141 | 74 |
481367 | 481367 | 2020-08-29 | Forsyth | North Carolina | 37067 | 6119 | 74 |
478134 | 478134 | 2020-08-28 | Forsyth | North Carolina | 37067 | 6014 | 71 |
474901 | 474901 | 2020-08-27 | Forsyth | North Carolina | 37067 | 5984 | 70 |
471667 | 471667 | 2020-08-26 | Forsyth | North Carolina | 37067 | 5952 | 70 |
468435 | 468435 | 2020-08-25 | Forsyth | North Carolina | 37067 | 5915 | 69 |
465207 | 465207 | 2020-08-24 | Forsyth | North Carolina | 37067 | 5876 | 66 |
461978 | 461978 | 2020-08-23 | Forsyth | North Carolina | 37067 | 5824 | 66 |
458750 | 458750 | 2020-08-22 | Forsyth | North Carolina | 37067 | 5790 | 66 |
455522 | 455522 | 2020-08-21 | Forsyth | North Carolina | 37067 | 5740 | 66 |
452294 | 452294 | 2020-08-20 | Forsyth | North Carolina | 37067 | 5681 | 63 |
449066 | 449066 | 2020-08-19 | Forsyth | North Carolina | 37067 | 5620 | 62 |
445838 | 445838 | 2020-08-18 | Forsyth | North Carolina | 37067 | 5601 | 60 |
442612 | 442612 | 2020-08-17 | Forsyth | North Carolina | 37067 | 5561 | 56 |
439385 | 439385 | 2020-08-16 | Forsyth | North Carolina | 37067 | 5552 | 56 |
436160 | 436160 | 2020-08-15 | Forsyth | North Carolina | 37067 | 5513 | 56 |
432934 | 432934 | 2020-08-14 | Forsyth | North Carolina | 37067 | 5477 | 56 |
429708 | 429708 | 2020-08-13 | Forsyth | North Carolina | 37067 | 5440 | 53 |
426483 | 426483 | 2020-08-12 | Forsyth | North Carolina | 37067 | 5381 | 53 |
423260 | 423260 | 2020-08-11 | Forsyth | North Carolina | 37067 | 5317 | 52 |
420037 | 420037 | 2020-08-10 | Forsyth | North Carolina | 37067 | 5286 | 52 |
416817 | 416817 | 2020-08-09 | Forsyth | North Carolina | 37067 | 5273 | 52 |
413596 | 413596 | 2020-08-08 | Forsyth | North Carolina | 37067 | 5213 | 52 |
410376 | 410376 | 2020-08-07 | Forsyth | North Carolina | 37067 | 5148 | 52 |
407156 | 407156 | 2020-08-06 | Forsyth | North Carolina | 37067 | 5091 | 51 |
403937 | 403937 | 2020-08-05 | Forsyth | North Carolina | 37067 | 5028 | 51 |
400719 | 400719 | 2020-08-04 | Forsyth | North Carolina | 37067 | 5007 | 49 |
397504 | 397504 | 2020-08-03 | Forsyth | North Carolina | 37067 | 4955 | 48 |
394287 | 394287 | 2020-08-02 | Forsyth | North Carolina | 37067 | 4925 | 48 |
391071 | 391071 | 2020-08-01 | Forsyth | North Carolina | 37067 | 4883 | 48 |
387854 | 387854 | 2020-07-31 | Forsyth | North Carolina | 37067 | 4833 | 48 |
384637 | 384637 | 2020-07-30 | Forsyth | North Carolina | 37067 | 4791 | 48 |
381419 | 381419 | 2020-07-29 | Forsyth | North Carolina | 37067 | 4703 | 49 |
378202 | 378202 | 2020-07-28 | Forsyth | North Carolina | 37067 | 4654 | 44 |
374986 | 374986 | 2020-07-27 | Forsyth | North Carolina | 37067 | 4607 | 41 |
371774 | 371774 | 2020-07-26 | Forsyth | North Carolina | 37067 | 4556 | 41 |
368562 | 368562 | 2020-07-25 | Forsyth | North Carolina | 37067 | 4515 | 41 |
365353 | 365353 | 2020-07-24 | Forsyth | North Carolina | 37067 | 4470 | 41 |
362147 | 362147 | 2020-07-23 | Forsyth | North Carolina | 37067 | 4402 | 41 |
358941 | 358941 | 2020-07-22 | Forsyth | North Carolina | 37067 | 4343 | 41 |
355737 | 355737 | 2020-07-21 | Forsyth | North Carolina | 37067 | 4297 | 41 |
352534 | 352534 | 2020-07-20 | Forsyth | North Carolina | 37067 | 4220 | 41 |
349331 | 349331 | 2020-07-19 | Forsyth | North Carolina | 37067 | 4196 | 41 |
346130 | 346130 | 2020-07-18 | Forsyth | North Carolina | 37067 | 4122 | 40 |
342931 | 342931 | 2020-07-17 | Forsyth | North Carolina | 37067 | 4008 | 40 |
339733 | 339733 | 2020-07-16 | Forsyth | North Carolina | 37067 | 3946 | 40 |
336537 | 336537 | 2020-07-15 | Forsyth | North Carolina | 37067 | 3850 | 40 |
333343 | 333343 | 2020-07-14 | Forsyth | North Carolina | 37067 | 3785 | 40 |
330153 | 330153 | 2020-07-13 | Forsyth | North Carolina | 37067 | 3731 | 40 |
326966 | 326966 | 2020-07-12 | Forsyth | North Carolina | 37067 | 3675 | 40 |
323782 | 323782 | 2020-07-11 | Forsyth | North Carolina | 37067 | 3622 | 39 |
320602 | 320602 | 2020-07-10 | Forsyth | North Carolina | 37067 | 3580 | 39 |
317425 | 317425 | 2020-07-09 | Forsyth | North Carolina | 37067 | 3525 | 37 |
314251 | 314251 | 2020-07-08 | Forsyth | North Carolina | 37067 | 3450 | 37 |
311080 | 311080 | 2020-07-07 | Forsyth | North Carolina | 37067 | 3423 | 37 |
307912 | 307912 | 2020-07-06 | Forsyth | North Carolina | 37067 | 3353 | 37 |
304745 | 304745 | 2020-07-05 | Forsyth | North Carolina | 37067 | 3290 | 37 |
301582 | 301582 | 2020-07-04 | Forsyth | North Carolina | 37067 | 3233 | 37 |
298419 | 298419 | 2020-07-03 | Forsyth | North Carolina | 37067 | 3185 | 37 |
295259 | 295259 | 2020-07-02 | Forsyth | North Carolina | 37067 | 3132 | 37 |
292104 | 292104 | 2020-07-01 | Forsyth | North Carolina | 37067 | 3077 | 35 |
288952 | 288952 | 2020-06-30 | Forsyth | North Carolina | 37067 | 2996 | 34 |
285802 | 285802 | 2020-06-29 | Forsyth | North Carolina | 37067 | 2978 | 34 |
282657 | 282657 | 2020-06-28 | Forsyth | North Carolina | 37067 | 2935 | 34 |
279511 | 279511 | 2020-06-27 | Forsyth | North Carolina | 37067 | 2871 | 34 |
276363 | 276363 | 2020-06-26 | Forsyth | North Carolina | 37067 | 2788 | 33 |
273217 | 273217 | 2020-06-25 | Forsyth | North Carolina | 37067 | 2715 | 31 |
270078 | 270078 | 2020-06-24 | Forsyth | North Carolina | 37067 | 2679 | 31 |
266944 | 266944 | 2020-06-23 | Forsyth | North Carolina | 37067 | 2615 | 29 |
263816 | 263816 | 2020-06-22 | Forsyth | North Carolina | 37067 | 2575 | 28 |
260688 | 260688 | 2020-06-21 | Forsyth | North Carolina | 37067 | 2524 | 28 |
257561 | 257561 | 2020-06-20 | Forsyth | North Carolina | 37067 | 2497 | 28 |
254438 | 254438 | 2020-06-19 | Forsyth | North Carolina | 37067 | 2463 | 27 |
251323 | 251323 | 2020-06-18 | Forsyth | North Carolina | 37067 | 2372 | 27 |
248208 | 248208 | 2020-06-17 | Forsyth | North Carolina | 37067 | 2333 | 26 |
245095 | 245095 | 2020-06-16 | Forsyth | North Carolina | 37067 | 2283 | 25 |
241983 | 241983 | 2020-06-15 | Forsyth | North Carolina | 37067 | 2250 | 25 |
238874 | 238874 | 2020-06-14 | Forsyth | North Carolina | 37067 | 2204 | 25 |
235766 | 235766 | 2020-06-13 | Forsyth | North Carolina | 37067 | 2128 | 25 |
232661 | 232661 | 2020-06-12 | Forsyth | North Carolina | 37067 | 2051 | 25 |
229556 | 229556 | 2020-06-11 | Forsyth | North Carolina | 37067 | 1967 | 25 |
226452 | 226452 | 2020-06-10 | Forsyth | North Carolina | 37067 | 1910 | 18 |
223352 | 223352 | 2020-06-09 | Forsyth | North Carolina | 37067 | 1874 | 18 |
220258 | 220258 | 2020-06-08 | Forsyth | North Carolina | 37067 | 1816 | 17 |
217166 | 217166 | 2020-06-07 | Forsyth | North Carolina | 37067 | 1774 | 17 |
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);