ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37069 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 |
---|---|---|---|---|---|---|---|
536353 | 536353 | 2020-09-15 | Franklin | North Carolina | 37069 | 1156 | 30 |
533117 | 533117 | 2020-09-14 | Franklin | North Carolina | 37069 | 1151 | 30 |
529882 | 529882 | 2020-09-13 | Franklin | North Carolina | 37069 | 1143 | 30 |
526645 | 526645 | 2020-09-12 | Franklin | North Carolina | 37069 | 1137 | 30 |
523409 | 523409 | 2020-09-11 | Franklin | North Carolina | 37069 | 1133 | 30 |
520173 | 520173 | 2020-09-10 | Franklin | North Carolina | 37069 | 1128 | 30 |
516937 | 516937 | 2020-09-09 | Franklin | North Carolina | 37069 | 1123 | 30 |
513702 | 513702 | 2020-09-08 | Franklin | North Carolina | 37069 | 1120 | 30 |
510469 | 510469 | 2020-09-07 | Franklin | North Carolina | 37069 | 1116 | 30 |
507236 | 507236 | 2020-09-06 | Franklin | North Carolina | 37069 | 1109 | 30 |
504004 | 504004 | 2020-09-05 | Franklin | North Carolina | 37069 | 1105 | 30 |
500770 | 500770 | 2020-09-04 | Franklin | North Carolina | 37069 | 1097 | 29 |
497536 | 497536 | 2020-09-03 | Franklin | North Carolina | 37069 | 1084 | 29 |
494303 | 494303 | 2020-09-02 | Franklin | North Carolina | 37069 | 1078 | 29 |
491069 | 491069 | 2020-09-01 | Franklin | North Carolina | 37069 | 1063 | 29 |
487836 | 487836 | 2020-08-31 | Franklin | North Carolina | 37069 | 1056 | 29 |
484603 | 484603 | 2020-08-30 | Franklin | North Carolina | 37069 | 1050 | 29 |
481368 | 481368 | 2020-08-29 | Franklin | North Carolina | 37069 | 1041 | 29 |
478135 | 478135 | 2020-08-28 | Franklin | North Carolina | 37069 | 1026 | 29 |
474902 | 474902 | 2020-08-27 | Franklin | North Carolina | 37069 | 1008 | 28 |
471668 | 471668 | 2020-08-26 | Franklin | North Carolina | 37069 | 996 | 28 |
468436 | 468436 | 2020-08-25 | Franklin | North Carolina | 37069 | 984 | 28 |
465208 | 465208 | 2020-08-24 | Franklin | North Carolina | 37069 | 976 | 28 |
461979 | 461979 | 2020-08-23 | Franklin | North Carolina | 37069 | 973 | 28 |
458751 | 458751 | 2020-08-22 | Franklin | North Carolina | 37069 | 965 | 28 |
455523 | 455523 | 2020-08-21 | Franklin | North Carolina | 37069 | 962 | 28 |
452295 | 452295 | 2020-08-20 | Franklin | North Carolina | 37069 | 956 | 28 |
449067 | 449067 | 2020-08-19 | Franklin | North Carolina | 37069 | 942 | 28 |
445839 | 445839 | 2020-08-18 | Franklin | North Carolina | 37069 | 934 | 28 |
442613 | 442613 | 2020-08-17 | Franklin | North Carolina | 37069 | 932 | 26 |
439386 | 439386 | 2020-08-16 | Franklin | North Carolina | 37069 | 929 | 26 |
436161 | 436161 | 2020-08-15 | Franklin | North Carolina | 37069 | 921 | 26 |
432935 | 432935 | 2020-08-14 | Franklin | North Carolina | 37069 | 915 | 26 |
429709 | 429709 | 2020-08-13 | Franklin | North Carolina | 37069 | 905 | 26 |
426484 | 426484 | 2020-08-12 | Franklin | North Carolina | 37069 | 891 | 26 |
423261 | 423261 | 2020-08-11 | Franklin | North Carolina | 37069 | 872 | 26 |
420038 | 420038 | 2020-08-10 | Franklin | North Carolina | 37069 | 871 | 26 |
416818 | 416818 | 2020-08-09 | Franklin | North Carolina | 37069 | 866 | 26 |
413597 | 413597 | 2020-08-08 | Franklin | North Carolina | 37069 | 860 | 26 |
410377 | 410377 | 2020-08-07 | Franklin | North Carolina | 37069 | 846 | 25 |
407157 | 407157 | 2020-08-06 | Franklin | North Carolina | 37069 | 828 | 25 |
403938 | 403938 | 2020-08-05 | Franklin | North Carolina | 37069 | 811 | 25 |
400720 | 400720 | 2020-08-04 | Franklin | North Carolina | 37069 | 805 | 25 |
397505 | 397505 | 2020-08-03 | Franklin | North Carolina | 37069 | 797 | 25 |
394288 | 394288 | 2020-08-02 | Franklin | North Carolina | 37069 | 783 | 25 |
391072 | 391072 | 2020-08-01 | Franklin | North Carolina | 37069 | 774 | 25 |
387855 | 387855 | 2020-07-31 | Franklin | North Carolina | 37069 | 762 | 25 |
384638 | 384638 | 2020-07-30 | Franklin | North Carolina | 37069 | 747 | 25 |
381420 | 381420 | 2020-07-29 | Franklin | North Carolina | 37069 | 731 | 25 |
378203 | 378203 | 2020-07-28 | Franklin | North Carolina | 37069 | 723 | 25 |
374987 | 374987 | 2020-07-27 | Franklin | North Carolina | 37069 | 705 | 25 |
371775 | 371775 | 2020-07-26 | Franklin | North Carolina | 37069 | 693 | 25 |
368563 | 368563 | 2020-07-25 | Franklin | North Carolina | 37069 | 682 | 25 |
365354 | 365354 | 2020-07-24 | Franklin | North Carolina | 37069 | 667 | 24 |
362148 | 362148 | 2020-07-23 | Franklin | North Carolina | 37069 | 648 | 23 |
358942 | 358942 | 2020-07-22 | Franklin | North Carolina | 37069 | 641 | 23 |
355738 | 355738 | 2020-07-21 | Franklin | North Carolina | 37069 | 611 | 23 |
352535 | 352535 | 2020-07-20 | Franklin | North Carolina | 37069 | 598 | 23 |
349332 | 349332 | 2020-07-19 | Franklin | North Carolina | 37069 | 591 | 23 |
346131 | 346131 | 2020-07-18 | Franklin | North Carolina | 37069 | 578 | 23 |
342932 | 342932 | 2020-07-17 | Franklin | North Carolina | 37069 | 560 | 23 |
339734 | 339734 | 2020-07-16 | Franklin | North Carolina | 37069 | 542 | 22 |
336538 | 336538 | 2020-07-15 | Franklin | North Carolina | 37069 | 533 | 22 |
333344 | 333344 | 2020-07-14 | Franklin | North Carolina | 37069 | 518 | 22 |
330154 | 330154 | 2020-07-13 | Franklin | North Carolina | 37069 | 504 | 21 |
326967 | 326967 | 2020-07-12 | Franklin | North Carolina | 37069 | 480 | 21 |
323783 | 323783 | 2020-07-11 | Franklin | North Carolina | 37069 | 478 | 21 |
320603 | 320603 | 2020-07-10 | Franklin | North Carolina | 37069 | 441 | 21 |
317426 | 317426 | 2020-07-09 | Franklin | North Carolina | 37069 | 435 | 21 |
314252 | 314252 | 2020-07-08 | Franklin | North Carolina | 37069 | 413 | 21 |
311081 | 311081 | 2020-07-07 | Franklin | North Carolina | 37069 | 403 | 21 |
307913 | 307913 | 2020-07-06 | Franklin | North Carolina | 37069 | 388 | 21 |
304746 | 304746 | 2020-07-05 | Franklin | North Carolina | 37069 | 381 | 21 |
301583 | 301583 | 2020-07-04 | Franklin | North Carolina | 37069 | 377 | 21 |
298420 | 298420 | 2020-07-03 | Franklin | North Carolina | 37069 | 376 | 21 |
295260 | 295260 | 2020-07-02 | Franklin | North Carolina | 37069 | 371 | 21 |
292105 | 292105 | 2020-07-01 | Franklin | North Carolina | 37069 | 357 | 21 |
288953 | 288953 | 2020-06-30 | Franklin | North Carolina | 37069 | 345 | 21 |
285803 | 285803 | 2020-06-29 | Franklin | North Carolina | 37069 | 338 | 21 |
282658 | 282658 | 2020-06-28 | Franklin | North Carolina | 37069 | 332 | 21 |
279512 | 279512 | 2020-06-27 | Franklin | North Carolina | 37069 | 326 | 21 |
276364 | 276364 | 2020-06-26 | Franklin | North Carolina | 37069 | 309 | 21 |
273218 | 273218 | 2020-06-25 | Franklin | North Carolina | 37069 | 301 | 21 |
270079 | 270079 | 2020-06-24 | Franklin | North Carolina | 37069 | 295 | 21 |
266945 | 266945 | 2020-06-23 | Franklin | North Carolina | 37069 | 287 | 21 |
263817 | 263817 | 2020-06-22 | Franklin | North Carolina | 37069 | 284 | 21 |
260689 | 260689 | 2020-06-21 | Franklin | North Carolina | 37069 | 280 | 21 |
257562 | 257562 | 2020-06-20 | Franklin | North Carolina | 37069 | 264 | 21 |
254439 | 254439 | 2020-06-19 | Franklin | North Carolina | 37069 | 259 | 21 |
251324 | 251324 | 2020-06-18 | Franklin | North Carolina | 37069 | 244 | 21 |
248209 | 248209 | 2020-06-17 | Franklin | North Carolina | 37069 | 237 | 21 |
245096 | 245096 | 2020-06-16 | Franklin | North Carolina | 37069 | 232 | 21 |
241984 | 241984 | 2020-06-15 | Franklin | North Carolina | 37069 | 231 | 21 |
238875 | 238875 | 2020-06-14 | Franklin | North Carolina | 37069 | 230 | 21 |
235767 | 235767 | 2020-06-13 | Franklin | North Carolina | 37069 | 221 | 21 |
232662 | 232662 | 2020-06-12 | Franklin | North Carolina | 37069 | 209 | 21 |
229557 | 229557 | 2020-06-11 | Franklin | North Carolina | 37069 | 202 | 21 |
226453 | 226453 | 2020-06-10 | Franklin | North Carolina | 37069 | 197 | 21 |
223353 | 223353 | 2020-06-09 | Franklin | North Carolina | 37069 | 193 | 21 |
220259 | 220259 | 2020-06-08 | Franklin | North Carolina | 37069 | 190 | 21 |
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);