ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 37037 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 |
---|---|---|---|---|---|---|---|
536337 | 536337 | 2020-09-15 | Chatham | North Carolina | 37037 | 1577 | 57 |
533101 | 533101 | 2020-09-14 | Chatham | North Carolina | 37037 | 1572 | 57 |
529866 | 529866 | 2020-09-13 | Chatham | North Carolina | 37037 | 1568 | 57 |
526629 | 526629 | 2020-09-12 | Chatham | North Carolina | 37037 | 1562 | 57 |
523393 | 523393 | 2020-09-11 | Chatham | North Carolina | 37037 | 1562 | 56 |
520157 | 520157 | 2020-09-10 | Chatham | North Carolina | 37037 | 1556 | 56 |
516921 | 516921 | 2020-09-09 | Chatham | North Carolina | 37037 | 1549 | 56 |
513686 | 513686 | 2020-09-08 | Chatham | North Carolina | 37037 | 1545 | 56 |
510453 | 510453 | 2020-09-07 | Chatham | North Carolina | 37037 | 1541 | 56 |
507220 | 507220 | 2020-09-06 | Chatham | North Carolina | 37037 | 1543 | 56 |
503988 | 503988 | 2020-09-05 | Chatham | North Carolina | 37037 | 1534 | 56 |
500754 | 500754 | 2020-09-04 | Chatham | North Carolina | 37037 | 1522 | 56 |
497520 | 497520 | 2020-09-03 | Chatham | North Carolina | 37037 | 1514 | 56 |
494287 | 494287 | 2020-09-02 | Chatham | North Carolina | 37037 | 1506 | 56 |
491053 | 491053 | 2020-09-01 | Chatham | North Carolina | 37037 | 1494 | 56 |
487820 | 487820 | 2020-08-31 | Chatham | North Carolina | 37037 | 1482 | 56 |
484587 | 484587 | 2020-08-30 | Chatham | North Carolina | 37037 | 1480 | 56 |
481352 | 481352 | 2020-08-29 | Chatham | North Carolina | 37037 | 1468 | 56 |
478119 | 478119 | 2020-08-28 | Chatham | North Carolina | 37037 | 1458 | 56 |
474886 | 474886 | 2020-08-27 | Chatham | North Carolina | 37037 | 1452 | 56 |
471652 | 471652 | 2020-08-26 | Chatham | North Carolina | 37037 | 1443 | 56 |
468420 | 468420 | 2020-08-25 | Chatham | North Carolina | 37037 | 1435 | 56 |
465192 | 465192 | 2020-08-24 | Chatham | North Carolina | 37037 | 1433 | 56 |
461963 | 461963 | 2020-08-23 | Chatham | North Carolina | 37037 | 1422 | 56 |
458735 | 458735 | 2020-08-22 | Chatham | North Carolina | 37037 | 1404 | 56 |
455507 | 455507 | 2020-08-21 | Chatham | North Carolina | 37037 | 1396 | 55 |
452279 | 452279 | 2020-08-20 | Chatham | North Carolina | 37037 | 1380 | 55 |
449051 | 449051 | 2020-08-19 | Chatham | North Carolina | 37037 | 1377 | 55 |
445823 | 445823 | 2020-08-18 | Chatham | North Carolina | 37037 | 1372 | 55 |
442597 | 442597 | 2020-08-17 | Chatham | North Carolina | 37037 | 1363 | 55 |
439370 | 439370 | 2020-08-16 | Chatham | North Carolina | 37037 | 1353 | 55 |
436145 | 436145 | 2020-08-15 | Chatham | North Carolina | 37037 | 1338 | 55 |
432919 | 432919 | 2020-08-14 | Chatham | North Carolina | 37037 | 1332 | 55 |
429693 | 429693 | 2020-08-13 | Chatham | North Carolina | 37037 | 1323 | 55 |
426468 | 426468 | 2020-08-12 | Chatham | North Carolina | 37037 | 1308 | 55 |
423245 | 423245 | 2020-08-11 | Chatham | North Carolina | 37037 | 1305 | 55 |
420022 | 420022 | 2020-08-10 | Chatham | North Carolina | 37037 | 1305 | 52 |
416802 | 416802 | 2020-08-09 | Chatham | North Carolina | 37037 | 1300 | 52 |
413581 | 413581 | 2020-08-08 | Chatham | North Carolina | 37037 | 1295 | 52 |
410361 | 410361 | 2020-08-07 | Chatham | North Carolina | 37037 | 1290 | 52 |
407141 | 407141 | 2020-08-06 | Chatham | North Carolina | 37037 | 1274 | 52 |
403922 | 403922 | 2020-08-05 | Chatham | North Carolina | 37037 | 1261 | 51 |
400704 | 400704 | 2020-08-04 | Chatham | North Carolina | 37037 | 1255 | 50 |
397489 | 397489 | 2020-08-03 | Chatham | North Carolina | 37037 | 1245 | 50 |
394272 | 394272 | 2020-08-02 | Chatham | North Carolina | 37037 | 1234 | 50 |
391056 | 391056 | 2020-08-01 | Chatham | North Carolina | 37037 | 1220 | 50 |
387839 | 387839 | 2020-07-31 | Chatham | North Carolina | 37037 | 1208 | 50 |
384622 | 384622 | 2020-07-30 | Chatham | North Carolina | 37037 | 1200 | 49 |
381404 | 381404 | 2020-07-29 | Chatham | North Carolina | 37037 | 1193 | 49 |
378187 | 378187 | 2020-07-28 | Chatham | North Carolina | 37037 | 1188 | 49 |
374971 | 374971 | 2020-07-27 | Chatham | North Carolina | 37037 | 1181 | 49 |
371759 | 371759 | 2020-07-26 | Chatham | North Carolina | 37037 | 1175 | 49 |
368547 | 368547 | 2020-07-25 | Chatham | North Carolina | 37037 | 1162 | 49 |
365338 | 365338 | 2020-07-24 | Chatham | North Carolina | 37037 | 1144 | 47 |
362132 | 362132 | 2020-07-23 | Chatham | North Carolina | 37037 | 1128 | 47 |
358926 | 358926 | 2020-07-22 | Chatham | North Carolina | 37037 | 1124 | 47 |
355722 | 355722 | 2020-07-21 | Chatham | North Carolina | 37037 | 1116 | 47 |
352519 | 352519 | 2020-07-20 | Chatham | North Carolina | 37037 | 1109 | 47 |
349316 | 349316 | 2020-07-19 | Chatham | North Carolina | 37037 | 1106 | 47 |
346115 | 346115 | 2020-07-18 | Chatham | North Carolina | 37037 | 1100 | 47 |
342916 | 342916 | 2020-07-17 | Chatham | North Carolina | 37037 | 1088 | 47 |
339718 | 339718 | 2020-07-16 | Chatham | North Carolina | 37037 | 1076 | 46 |
336522 | 336522 | 2020-07-15 | Chatham | North Carolina | 37037 | 1072 | 46 |
333328 | 333328 | 2020-07-14 | Chatham | North Carolina | 37037 | 1067 | 46 |
330138 | 330138 | 2020-07-13 | Chatham | North Carolina | 37037 | 1061 | 45 |
326951 | 326951 | 2020-07-12 | Chatham | North Carolina | 37037 | 1052 | 45 |
323767 | 323767 | 2020-07-11 | Chatham | North Carolina | 37037 | 1041 | 45 |
320587 | 320587 | 2020-07-10 | Chatham | North Carolina | 37037 | 1035 | 44 |
317410 | 317410 | 2020-07-09 | Chatham | North Carolina | 37037 | 1009 | 44 |
314236 | 314236 | 2020-07-08 | Chatham | North Carolina | 37037 | 1001 | 43 |
311065 | 311065 | 2020-07-07 | Chatham | North Carolina | 37037 | 999 | 43 |
307897 | 307897 | 2020-07-06 | Chatham | North Carolina | 37037 | 994 | 43 |
304730 | 304730 | 2020-07-05 | Chatham | North Carolina | 37037 | 990 | 43 |
301567 | 301567 | 2020-07-04 | Chatham | North Carolina | 37037 | 984 | 43 |
298404 | 298404 | 2020-07-03 | Chatham | North Carolina | 37037 | 975 | 43 |
295244 | 295244 | 2020-07-02 | Chatham | North Carolina | 37037 | 964 | 43 |
292089 | 292089 | 2020-07-01 | Chatham | North Carolina | 37037 | 956 | 43 |
288937 | 288937 | 2020-06-30 | Chatham | North Carolina | 37037 | 950 | 43 |
285787 | 285787 | 2020-06-29 | Chatham | North Carolina | 37037 | 947 | 42 |
282642 | 282642 | 2020-06-28 | Chatham | North Carolina | 37037 | 936 | 42 |
279496 | 279496 | 2020-06-27 | Chatham | North Carolina | 37037 | 924 | 42 |
276348 | 276348 | 2020-06-26 | Chatham | North Carolina | 37037 | 916 | 42 |
273202 | 273202 | 2020-06-25 | Chatham | North Carolina | 37037 | 910 | 42 |
270063 | 270063 | 2020-06-24 | Chatham | North Carolina | 37037 | 901 | 42 |
266929 | 266929 | 2020-06-23 | Chatham | North Carolina | 37037 | 890 | 42 |
263801 | 263801 | 2020-06-22 | Chatham | North Carolina | 37037 | 881 | 39 |
260673 | 260673 | 2020-06-21 | Chatham | North Carolina | 37037 | 882 | 39 |
257546 | 257546 | 2020-06-20 | Chatham | North Carolina | 37037 | 860 | 39 |
254423 | 254423 | 2020-06-19 | Chatham | North Carolina | 37037 | 848 | 39 |
251308 | 251308 | 2020-06-18 | Chatham | North Carolina | 37037 | 841 | 39 |
248193 | 248193 | 2020-06-17 | Chatham | North Carolina | 37037 | 821 | 39 |
245080 | 245080 | 2020-06-16 | Chatham | North Carolina | 37037 | 813 | 39 |
241968 | 241968 | 2020-06-15 | Chatham | North Carolina | 37037 | 808 | 37 |
238859 | 238859 | 2020-06-14 | Chatham | North Carolina | 37037 | 808 | 37 |
235751 | 235751 | 2020-06-13 | Chatham | North Carolina | 37037 | 784 | 37 |
232646 | 232646 | 2020-06-12 | Chatham | North Carolina | 37037 | 780 | 37 |
229541 | 229541 | 2020-06-11 | Chatham | North Carolina | 37037 | 759 | 37 |
226437 | 226437 | 2020-06-10 | Chatham | North Carolina | 37037 | 749 | 37 |
223337 | 223337 | 2020-06-09 | Chatham | North Carolina | 37037 | 745 | 37 |
220243 | 220243 | 2020-06-08 | Chatham | North Carolina | 37037 | 733 | 36 |
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);