ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Union" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501575 | 2501575 | 2022-05-13 | Union | North Carolina | 37179 | 62697 | 490 |
2498317 | 2498317 | 2022-05-12 | Union | North Carolina | 37179 | 62697 | 490 |
2495059 | 2495059 | 2022-05-11 | Union | North Carolina | 37179 | 62697 | 490 |
2491801 | 2491801 | 2022-05-10 | Union | North Carolina | 37179 | 62328 | 489 |
2488543 | 2488543 | 2022-05-09 | Union | North Carolina | 37179 | 62328 | 489 |
2485286 | 2485286 | 2022-05-08 | Union | North Carolina | 37179 | 62328 | 489 |
2482028 | 2482028 | 2022-05-07 | Union | North Carolina | 37179 | 62328 | 489 |
2478770 | 2478770 | 2022-05-06 | Union | North Carolina | 37179 | 62328 | 489 |
2475512 | 2475512 | 2022-05-05 | Union | North Carolina | 37179 | 62328 | 489 |
2472255 | 2472255 | 2022-05-04 | Union | North Carolina | 37179 | 62328 | 489 |
2468999 | 2468999 | 2022-05-03 | Union | North Carolina | 37179 | 61999 | 481 |
2465743 | 2465743 | 2022-05-02 | Union | North Carolina | 37179 | 61999 | 481 |
2462488 | 2462488 | 2022-05-01 | Union | North Carolina | 37179 | 61999 | 481 |
2459232 | 2459232 | 2022-04-30 | Union | North Carolina | 37179 | 61999 | 481 |
2455976 | 2455976 | 2022-04-29 | Union | North Carolina | 37179 | 61999 | 481 |
2452720 | 2452720 | 2022-04-28 | Union | North Carolina | 37179 | 61999 | 481 |
2449464 | 2449464 | 2022-04-27 | Union | North Carolina | 37179 | 61999 | 481 |
2446207 | 2446207 | 2022-04-26 | Union | North Carolina | 37179 | 61794 | 480 |
2442952 | 2442952 | 2022-04-25 | Union | North Carolina | 37179 | 61794 | 480 |
2439696 | 2439696 | 2022-04-24 | Union | North Carolina | 37179 | 61794 | 480 |
2436440 | 2436440 | 2022-04-23 | Union | North Carolina | 37179 | 61794 | 480 |
2433184 | 2433184 | 2022-04-22 | Union | North Carolina | 37179 | 61794 | 480 |
2429928 | 2429928 | 2022-04-21 | Union | North Carolina | 37179 | 61794 | 480 |
2426672 | 2426672 | 2022-04-20 | Union | North Carolina | 37179 | 61794 | 480 |
2423416 | 2423416 | 2022-04-19 | Union | North Carolina | 37179 | 61637 | 479 |
2420159 | 2420159 | 2022-04-18 | Union | North Carolina | 37179 | 61637 | 479 |
2416904 | 2416904 | 2022-04-17 | Union | North Carolina | 37179 | 61637 | 479 |
2413648 | 2413648 | 2022-04-16 | Union | North Carolina | 37179 | 61637 | 479 |
2410392 | 2410392 | 2022-04-15 | Union | North Carolina | 37179 | 61637 | 479 |
2407136 | 2407136 | 2022-04-14 | Union | North Carolina | 37179 | 61637 | 479 |
2403880 | 2403880 | 2022-04-13 | Union | North Carolina | 37179 | 61637 | 479 |
2400625 | 2400625 | 2022-04-12 | Union | North Carolina | 37179 | 61557 | 479 |
2397370 | 2397370 | 2022-04-11 | Union | North Carolina | 37179 | 61557 | 479 |
2394115 | 2394115 | 2022-04-10 | Union | North Carolina | 37179 | 61557 | 479 |
2390859 | 2390859 | 2022-04-09 | Union | North Carolina | 37179 | 61557 | 479 |
2387603 | 2387603 | 2022-04-08 | Union | North Carolina | 37179 | 61557 | 479 |
2384348 | 2384348 | 2022-04-07 | Union | North Carolina | 37179 | 61557 | 479 |
2381093 | 2381093 | 2022-04-06 | Union | North Carolina | 37179 | 61557 | 479 |
2377838 | 2377838 | 2022-04-05 | Union | North Carolina | 37179 | 61542 | 479 |
2374585 | 2374585 | 2022-04-04 | Union | North Carolina | 37179 | 61537 | 479 |
2371333 | 2371333 | 2022-04-03 | Union | North Carolina | 37179 | 61516 | 479 |
2368080 | 2368080 | 2022-04-02 | Union | North Carolina | 37179 | 61516 | 479 |
2364827 | 2364827 | 2022-04-01 | Union | North Carolina | 37179 | 61516 | 479 |
2361573 | 2361573 | 2022-03-31 | Union | North Carolina | 37179 | 61503 | 479 |
2358319 | 2358319 | 2022-03-30 | Union | North Carolina | 37179 | 61492 | 479 |
2355065 | 2355065 | 2022-03-29 | Union | North Carolina | 37179 | 61479 | 479 |
2351812 | 2351812 | 2022-03-28 | Union | North Carolina | 37179 | 61471 | 478 |
2348560 | 2348560 | 2022-03-27 | Union | North Carolina | 37179 | 61441 | 478 |
2345307 | 2345307 | 2022-03-26 | Union | North Carolina | 37179 | 61441 | 478 |
2342054 | 2342054 | 2022-03-25 | Union | North Carolina | 37179 | 61441 | 478 |
2338801 | 2338801 | 2022-03-24 | Union | North Carolina | 37179 | 61428 | 478 |
2335547 | 2335547 | 2022-03-23 | Union | North Carolina | 37179 | 61405 | 478 |
2332293 | 2332293 | 2022-03-22 | Union | North Carolina | 37179 | 61363 | 478 |
2329040 | 2329040 | 2022-03-21 | Union | North Carolina | 37179 | 61356 | 478 |
2325788 | 2325788 | 2022-03-20 | Union | North Carolina | 37179 | 61385 | 479 |
2322535 | 2322535 | 2022-03-19 | Union | North Carolina | 37179 | 61385 | 479 |
2319281 | 2319281 | 2022-03-18 | Union | North Carolina | 37179 | 61385 | 479 |
2316027 | 2316027 | 2022-03-17 | Union | North Carolina | 37179 | 61385 | 479 |
2312774 | 2312774 | 2022-03-16 | Union | North Carolina | 37179 | 61361 | 478 |
2309521 | 2309521 | 2022-03-15 | Union | North Carolina | 37179 | 61382 | 478 |
2306268 | 2306268 | 2022-03-14 | Union | North Carolina | 37179 | 61397 | 478 |
2303017 | 2303017 | 2022-03-13 | Union | North Carolina | 37179 | 61339 | 476 |
2299765 | 2299765 | 2022-03-12 | Union | North Carolina | 37179 | 61339 | 476 |
2296513 | 2296513 | 2022-03-11 | Union | North Carolina | 37179 | 61339 | 476 |
2293261 | 2293261 | 2022-03-10 | Union | North Carolina | 37179 | 61324 | 476 |
2290009 | 2290009 | 2022-03-09 | Union | North Carolina | 37179 | 61292 | 476 |
2286757 | 2286757 | 2022-03-08 | Union | North Carolina | 37179 | 61272 | 475 |
2283505 | 2283505 | 2022-03-07 | Union | North Carolina | 37179 | 61254 | 474 |
2280253 | 2280253 | 2022-03-06 | Union | North Carolina | 37179 | 61182 | 473 |
2277000 | 2277000 | 2022-03-05 | Union | North Carolina | 37179 | 61182 | 473 |
2273747 | 2273747 | 2022-03-04 | Union | North Carolina | 37179 | 61182 | 473 |
2270494 | 2270494 | 2022-03-03 | Union | North Carolina | 37179 | 61147 | 473 |
2267242 | 2267242 | 2022-03-02 | Union | North Carolina | 37179 | 61089 | 473 |
2263990 | 2263990 | 2022-03-01 | Union | North Carolina | 37179 | 61043 | 470 |
2260739 | 2260739 | 2022-02-28 | Union | North Carolina | 37179 | 61020 | 468 |
2257488 | 2257488 | 2022-02-27 | Union | North Carolina | 37179 | 60916 | 466 |
2254237 | 2254237 | 2022-02-26 | Union | North Carolina | 37179 | 60916 | 466 |
2250986 | 2250986 | 2022-02-25 | Union | North Carolina | 37179 | 60916 | 466 |
2247735 | 2247735 | 2022-02-24 | Union | North Carolina | 37179 | 60863 | 464 |
2244484 | 2244484 | 2022-02-23 | Union | North Carolina | 37179 | 60775 | 464 |
2241233 | 2241233 | 2022-02-22 | Union | North Carolina | 37179 | 60686 | 460 |
2237982 | 2237982 | 2022-02-21 | Union | North Carolina | 37179 | 60630 | 455 |
2234731 | 2234731 | 2022-02-20 | Union | North Carolina | 37179 | 60450 | 452 |
2231480 | 2231480 | 2022-02-19 | Union | North Carolina | 37179 | 60450 | 452 |
2228229 | 2228229 | 2022-02-18 | Union | North Carolina | 37179 | 60450 | 452 |
2224978 | 2224978 | 2022-02-17 | Union | North Carolina | 37179 | 60340 | 452 |
2221727 | 2221727 | 2022-02-16 | Union | North Carolina | 37179 | 60227 | 449 |
2218476 | 2218476 | 2022-02-15 | Union | North Carolina | 37179 | 60011 | 445 |
2215225 | 2215225 | 2022-02-14 | Union | North Carolina | 37179 | 59958 | 445 |
2211974 | 2211974 | 2022-02-13 | Union | North Carolina | 37179 | 59707 | 444 |
2208721 | 2208721 | 2022-02-12 | Union | North Carolina | 37179 | 59707 | 444 |
2205468 | 2205468 | 2022-02-11 | Union | North Carolina | 37179 | 59707 | 444 |
2202215 | 2202215 | 2022-02-10 | Union | North Carolina | 37179 | 59575 | 439 |
2198961 | 2198961 | 2022-02-09 | Union | North Carolina | 37179 | 59399 | 436 |
2195707 | 2195707 | 2022-02-08 | Union | North Carolina | 37179 | 59170 | 430 |
2192453 | 2192453 | 2022-02-07 | Union | North Carolina | 37179 | 59101 | 428 |
2189199 | 2189199 | 2022-02-06 | Union | North Carolina | 37179 | 58635 | 426 |
2185946 | 2185946 | 2022-02-05 | Union | North Carolina | 37179 | 58635 | 426 |
2182694 | 2182694 | 2022-02-04 | Union | North Carolina | 37179 | 58635 | 426 |
2179442 | 2179442 | 2022-02-03 | Union | North Carolina | 37179 | 58415 | 426 |
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);