ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Transylvania" 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 |
---|---|---|---|---|---|---|---|
2501573 | 2501573 | 2022-05-13 | Transylvania | North Carolina | 37175 | 6199 | 75 |
2498315 | 2498315 | 2022-05-12 | Transylvania | North Carolina | 37175 | 6199 | 75 |
2495057 | 2495057 | 2022-05-11 | Transylvania | North Carolina | 37175 | 6199 | 75 |
2491799 | 2491799 | 2022-05-10 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2488541 | 2488541 | 2022-05-09 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2485284 | 2485284 | 2022-05-08 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2482026 | 2482026 | 2022-05-07 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2478768 | 2478768 | 2022-05-06 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2475510 | 2475510 | 2022-05-05 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2472253 | 2472253 | 2022-05-04 | Transylvania | North Carolina | 37175 | 6178 | 77 |
2468997 | 2468997 | 2022-05-03 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2465741 | 2465741 | 2022-05-02 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2462486 | 2462486 | 2022-05-01 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2459230 | 2459230 | 2022-04-30 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2455974 | 2455974 | 2022-04-29 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2452718 | 2452718 | 2022-04-28 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2449462 | 2449462 | 2022-04-27 | Transylvania | North Carolina | 37175 | 6160 | 72 |
2446205 | 2446205 | 2022-04-26 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2442950 | 2442950 | 2022-04-25 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2439694 | 2439694 | 2022-04-24 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2436438 | 2436438 | 2022-04-23 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2433182 | 2433182 | 2022-04-22 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2429926 | 2429926 | 2022-04-21 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2426670 | 2426670 | 2022-04-20 | Transylvania | North Carolina | 37175 | 6141 | 72 |
2423414 | 2423414 | 2022-04-19 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2420157 | 2420157 | 2022-04-18 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2416902 | 2416902 | 2022-04-17 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2413646 | 2413646 | 2022-04-16 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2410390 | 2410390 | 2022-04-15 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2407134 | 2407134 | 2022-04-14 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2403878 | 2403878 | 2022-04-13 | Transylvania | North Carolina | 37175 | 6136 | 72 |
2400623 | 2400623 | 2022-04-12 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2397368 | 2397368 | 2022-04-11 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2394113 | 2394113 | 2022-04-10 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2390857 | 2390857 | 2022-04-09 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2387601 | 2387601 | 2022-04-08 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2384346 | 2384346 | 2022-04-07 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2381091 | 2381091 | 2022-04-06 | Transylvania | North Carolina | 37175 | 6120 | 71 |
2377836 | 2377836 | 2022-04-05 | Transylvania | North Carolina | 37175 | 6121 | 71 |
2374583 | 2374583 | 2022-04-04 | Transylvania | North Carolina | 37175 | 6121 | 71 |
2371331 | 2371331 | 2022-04-03 | Transylvania | North Carolina | 37175 | 6121 | 71 |
2368078 | 2368078 | 2022-04-02 | Transylvania | North Carolina | 37175 | 6121 | 71 |
2364825 | 2364825 | 2022-04-01 | Transylvania | North Carolina | 37175 | 6121 | 71 |
2361571 | 2361571 | 2022-03-31 | Transylvania | North Carolina | 37175 | 6119 | 71 |
2358317 | 2358317 | 2022-03-30 | Transylvania | North Carolina | 37175 | 6119 | 71 |
2355063 | 2355063 | 2022-03-29 | Transylvania | North Carolina | 37175 | 6118 | 71 |
2351810 | 2351810 | 2022-03-28 | Transylvania | North Carolina | 37175 | 6118 | 71 |
2348558 | 2348558 | 2022-03-27 | Transylvania | North Carolina | 37175 | 6115 | 71 |
2345305 | 2345305 | 2022-03-26 | Transylvania | North Carolina | 37175 | 6115 | 71 |
2342052 | 2342052 | 2022-03-25 | Transylvania | North Carolina | 37175 | 6115 | 71 |
2338799 | 2338799 | 2022-03-24 | Transylvania | North Carolina | 37175 | 6114 | 70 |
2335545 | 2335545 | 2022-03-23 | Transylvania | North Carolina | 37175 | 6109 | 69 |
2332291 | 2332291 | 2022-03-22 | Transylvania | North Carolina | 37175 | 6100 | 69 |
2329038 | 2329038 | 2022-03-21 | Transylvania | North Carolina | 37175 | 6099 | 69 |
2325786 | 2325786 | 2022-03-20 | Transylvania | North Carolina | 37175 | 6100 | 69 |
2322533 | 2322533 | 2022-03-19 | Transylvania | North Carolina | 37175 | 6100 | 69 |
2319279 | 2319279 | 2022-03-18 | Transylvania | North Carolina | 37175 | 6100 | 69 |
2316025 | 2316025 | 2022-03-17 | Transylvania | North Carolina | 37175 | 6099 | 69 |
2312772 | 2312772 | 2022-03-16 | Transylvania | North Carolina | 37175 | 6096 | 69 |
2309519 | 2309519 | 2022-03-15 | Transylvania | North Carolina | 37175 | 6089 | 69 |
2306266 | 2306266 | 2022-03-14 | Transylvania | North Carolina | 37175 | 6088 | 69 |
2303015 | 2303015 | 2022-03-13 | Transylvania | North Carolina | 37175 | 6089 | 69 |
2299763 | 2299763 | 2022-03-12 | Transylvania | North Carolina | 37175 | 6089 | 69 |
2296511 | 2296511 | 2022-03-11 | Transylvania | North Carolina | 37175 | 6089 | 69 |
2293259 | 2293259 | 2022-03-10 | Transylvania | North Carolina | 37175 | 6087 | 69 |
2290007 | 2290007 | 2022-03-09 | Transylvania | North Carolina | 37175 | 6081 | 69 |
2286755 | 2286755 | 2022-03-08 | Transylvania | North Carolina | 37175 | 6078 | 69 |
2283503 | 2283503 | 2022-03-07 | Transylvania | North Carolina | 37175 | 6076 | 68 |
2280251 | 2280251 | 2022-03-06 | Transylvania | North Carolina | 37175 | 6066 | 68 |
2276998 | 2276998 | 2022-03-05 | Transylvania | North Carolina | 37175 | 6066 | 68 |
2273745 | 2273745 | 2022-03-04 | Transylvania | North Carolina | 37175 | 6066 | 68 |
2270492 | 2270492 | 2022-03-03 | Transylvania | North Carolina | 37175 | 6063 | 68 |
2267240 | 2267240 | 2022-03-02 | Transylvania | North Carolina | 37175 | 6060 | 68 |
2263988 | 2263988 | 2022-03-01 | Transylvania | North Carolina | 37175 | 6055 | 68 |
2260737 | 2260737 | 2022-02-28 | Transylvania | North Carolina | 37175 | 6055 | 67 |
2257486 | 2257486 | 2022-02-27 | Transylvania | North Carolina | 37175 | 6042 | 67 |
2254235 | 2254235 | 2022-02-26 | Transylvania | North Carolina | 37175 | 6042 | 67 |
2250984 | 2250984 | 2022-02-25 | Transylvania | North Carolina | 37175 | 6042 | 67 |
2247733 | 2247733 | 2022-02-24 | Transylvania | North Carolina | 37175 | 6034 | 66 |
2244482 | 2244482 | 2022-02-23 | Transylvania | North Carolina | 37175 | 6028 | 66 |
2241231 | 2241231 | 2022-02-22 | Transylvania | North Carolina | 37175 | 6022 | 66 |
2237980 | 2237980 | 2022-02-21 | Transylvania | North Carolina | 37175 | 6015 | 66 |
2234729 | 2234729 | 2022-02-20 | Transylvania | North Carolina | 37175 | 5997 | 66 |
2231478 | 2231478 | 2022-02-19 | Transylvania | North Carolina | 37175 | 5997 | 66 |
2228227 | 2228227 | 2022-02-18 | Transylvania | North Carolina | 37175 | 5997 | 66 |
2224976 | 2224976 | 2022-02-17 | Transylvania | North Carolina | 37175 | 5986 | 65 |
2221725 | 2221725 | 2022-02-16 | Transylvania | North Carolina | 37175 | 5976 | 65 |
2218474 | 2218474 | 2022-02-15 | Transylvania | North Carolina | 37175 | 5962 | 65 |
2215223 | 2215223 | 2022-02-14 | Transylvania | North Carolina | 37175 | 5954 | 65 |
2211972 | 2211972 | 2022-02-13 | Transylvania | North Carolina | 37175 | 5902 | 64 |
2208719 | 2208719 | 2022-02-12 | Transylvania | North Carolina | 37175 | 5902 | 64 |
2205466 | 2205466 | 2022-02-11 | Transylvania | North Carolina | 37175 | 5902 | 64 |
2202213 | 2202213 | 2022-02-10 | Transylvania | North Carolina | 37175 | 5898 | 64 |
2198959 | 2198959 | 2022-02-09 | Transylvania | North Carolina | 37175 | 5886 | 62 |
2195705 | 2195705 | 2022-02-08 | Transylvania | North Carolina | 37175 | 5851 | 62 |
2192451 | 2192451 | 2022-02-07 | Transylvania | North Carolina | 37175 | 5838 | 62 |
2189197 | 2189197 | 2022-02-06 | Transylvania | North Carolina | 37175 | 5791 | 62 |
2185944 | 2185944 | 2022-02-05 | Transylvania | North Carolina | 37175 | 5791 | 62 |
2182692 | 2182692 | 2022-02-04 | Transylvania | North Carolina | 37175 | 5791 | 62 |
2179440 | 2179440 | 2022-02-03 | Transylvania | North Carolina | 37175 | 5769 | 62 |
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);