ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,594 rows where county = "Hillsborough" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337154 | 2337154 | 2022-03-24 | Hillsborough | Florida | 12057 | 372580 | 3704 |
2338593 | 2338593 | 2022-03-24 | Hillsborough | New Hampshire | 33011 | 96514 | 892 |
2333900 | 2333900 | 2022-03-23 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2335339 | 2335339 | 2022-03-23 | Hillsborough | New Hampshire | 33011 | 96490 | 891 |
2330646 | 2330646 | 2022-03-22 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2332085 | 2332085 | 2022-03-22 | Hillsborough | New Hampshire | 33011 | 96408 | 891 |
2327394 | 2327394 | 2022-03-21 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2328832 | 2328832 | 2022-03-21 | Hillsborough | New Hampshire | 33011 | 96391 | 890 |
2324141 | 2324141 | 2022-03-20 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2325580 | 2325580 | 2022-03-20 | Hillsborough | New Hampshire | 33011 | 96311 | 890 |
2320887 | 2320887 | 2022-03-19 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2322326 | 2322326 | 2022-03-19 | Hillsborough | New Hampshire | 33011 | 96311 | 890 |
2317633 | 2317633 | 2022-03-18 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2319072 | 2319072 | 2022-03-18 | Hillsborough | New Hampshire | 33011 | 96311 | 890 |
2314380 | 2314380 | 2022-03-17 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2315819 | 2315819 | 2022-03-17 | Hillsborough | New Hampshire | 33011 | 96268 | 889 |
2311127 | 2311127 | 2022-03-16 | Hillsborough | Florida | 12057 | 372580 | 3641 |
2312566 | 2312566 | 2022-03-16 | Hillsborough | New Hampshire | 33011 | 96228 | 889 |
2307874 | 2307874 | 2022-03-15 | Hillsborough | Florida | 12057 | 372580 | 3581 |
2309313 | 2309313 | 2022-03-15 | Hillsborough | New Hampshire | 33011 | 96197 | 887 |
2304623 | 2304623 | 2022-03-14 | Hillsborough | Florida | 12057 | 372580 | 3581 |
2306060 | 2306060 | 2022-03-14 | Hillsborough | New Hampshire | 33011 | 96184 | 887 |
2301371 | 2301371 | 2022-03-13 | Hillsborough | Florida | 12057 | 372580 | 3581 |
2302809 | 2302809 | 2022-03-13 | Hillsborough | New Hampshire | 33011 | 96105 | 886 |
2298119 | 2298119 | 2022-03-12 | Hillsborough | Florida | 12057 | 372580 | 3581 |
2299557 | 2299557 | 2022-03-12 | Hillsborough | New Hampshire | 33011 | 96105 | 886 |
2294867 | 2294867 | 2022-03-11 | Hillsborough | Florida | 12057 | 372580 | 3581 |
2296305 | 2296305 | 2022-03-11 | Hillsborough | New Hampshire | 33011 | 96105 | 886 |
2291615 | 2291615 | 2022-03-10 | Hillsborough | Florida | 12057 | 371919 | 3581 |
2293053 | 2293053 | 2022-03-10 | Hillsborough | New Hampshire | 33011 | 96074 | 885 |
2288363 | 2288363 | 2022-03-09 | Hillsborough | Florida | 12057 | 371919 | 3581 |
2289801 | 2289801 | 2022-03-09 | Hillsborough | New Hampshire | 33011 | 96047 | 884 |
2285112 | 2285112 | 2022-03-08 | Hillsborough | Florida | 12057 | 371919 | 3478 |
2286549 | 2286549 | 2022-03-08 | Hillsborough | New Hampshire | 33011 | 96010 | 884 |
2281860 | 2281860 | 2022-03-07 | Hillsborough | Florida | 12057 | 371919 | 3478 |
2283297 | 2283297 | 2022-03-07 | Hillsborough | New Hampshire | 33011 | 95986 | 883 |
2278607 | 2278607 | 2022-03-06 | Hillsborough | Florida | 12057 | 371919 | 3478 |
2280044 | 2280044 | 2022-03-06 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2275354 | 2275354 | 2022-03-05 | Hillsborough | Florida | 12057 | 371919 | 3478 |
2276791 | 2276791 | 2022-03-05 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2272101 | 2272101 | 2022-03-04 | Hillsborough | Florida | 12057 | 371919 | 3478 |
2273538 | 2273538 | 2022-03-04 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2268849 | 2268849 | 2022-03-03 | Hillsborough | Florida | 12057 | 371068 | 3478 |
2270286 | 2270286 | 2022-03-03 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2265596 | 2265596 | 2022-03-02 | Hillsborough | Florida | 12057 | 371068 | 3478 |
2267033 | 2267033 | 2022-03-02 | Hillsborough | New Hampshire | 33011 | 95759 | 877 |
2262345 | 2262345 | 2022-03-01 | Hillsborough | Florida | 12057 | 371068 | 3383 |
2263782 | 2263782 | 2022-03-01 | Hillsborough | New Hampshire | 33011 | 95717 | 873 |
2259094 | 2259094 | 2022-02-28 | Hillsborough | Florida | 12057 | 371068 | 3383 |
2260531 | 2260531 | 2022-02-28 | Hillsborough | New Hampshire | 33011 | 95620 | 872 |
2255843 | 2255843 | 2022-02-27 | Hillsborough | Florida | 12057 | 371068 | 3383 |
2257280 | 2257280 | 2022-02-27 | Hillsborough | New Hampshire | 33011 | 95499 | 872 |
2252592 | 2252592 | 2022-02-26 | Hillsborough | Florida | 12057 | 371068 | 3383 |
2254029 | 2254029 | 2022-02-26 | Hillsborough | New Hampshire | 33011 | 95499 | 872 |
2249341 | 2249341 | 2022-02-25 | Hillsborough | Florida | 12057 | 371068 | 3383 |
2250778 | 2250778 | 2022-02-25 | Hillsborough | New Hampshire | 33011 | 95499 | 872 |
2246090 | 2246090 | 2022-02-24 | Hillsborough | Florida | 12057 | 368092 | 3383 |
2247527 | 2247527 | 2022-02-24 | Hillsborough | New Hampshire | 33011 | 95249 | 871 |
2242839 | 2242839 | 2022-02-23 | Hillsborough | Florida | 12057 | 368092 | 3383 |
2244276 | 2244276 | 2022-02-23 | Hillsborough | New Hampshire | 33011 | 94937 | 870 |
2239588 | 2239588 | 2022-02-22 | Hillsborough | Florida | 12057 | 368092 | 3353 |
2241025 | 2241025 | 2022-02-22 | Hillsborough | New Hampshire | 33011 | 94353 | 863 |
2236337 | 2236337 | 2022-02-21 | Hillsborough | Florida | 12057 | 368092 | 3353 |
2237774 | 2237774 | 2022-02-21 | Hillsborough | New Hampshire | 33011 | 94353 | 863 |
2233086 | 2233086 | 2022-02-20 | Hillsborough | Florida | 12057 | 368092 | 3353 |
2234523 | 2234523 | 2022-02-20 | Hillsborough | New Hampshire | 33011 | 94353 | 863 |
2229835 | 2229835 | 2022-02-19 | Hillsborough | Florida | 12057 | 368092 | 3353 |
2231272 | 2231272 | 2022-02-19 | Hillsborough | New Hampshire | 33011 | 94353 | 863 |
2226584 | 2226584 | 2022-02-18 | Hillsborough | Florida | 12057 | 368092 | 3353 |
2228021 | 2228021 | 2022-02-18 | Hillsborough | New Hampshire | 33011 | 94353 | 863 |
2223333 | 2223333 | 2022-02-17 | Hillsborough | Florida | 12057 | 363767 | 3353 |
2224770 | 2224770 | 2022-02-17 | Hillsborough | New Hampshire | 33011 | 93952 | 861 |
2220082 | 2220082 | 2022-02-16 | Hillsborough | Florida | 12057 | 363767 | 3353 |
2221519 | 2221519 | 2022-02-16 | Hillsborough | New Hampshire | 33011 | 93764 | 861 |
2216831 | 2216831 | 2022-02-15 | Hillsborough | Florida | 12057 | 363767 | 3315 |
2218268 | 2218268 | 2022-02-15 | Hillsborough | New Hampshire | 33011 | 93670 | 858 |
2213580 | 2213580 | 2022-02-14 | Hillsborough | Florida | 12057 | 363767 | 3315 |
2215017 | 2215017 | 2022-02-14 | Hillsborough | New Hampshire | 33011 | 92948 | 853 |
2210328 | 2210328 | 2022-02-13 | Hillsborough | Florida | 12057 | 363767 | 3315 |
2211765 | 2211765 | 2022-02-13 | Hillsborough | New Hampshire | 33011 | 92948 | 853 |
2207075 | 2207075 | 2022-02-12 | Hillsborough | Florida | 12057 | 363767 | 3315 |
2208512 | 2208512 | 2022-02-12 | Hillsborough | New Hampshire | 33011 | 92948 | 853 |
2203822 | 2203822 | 2022-02-11 | Hillsborough | Florida | 12057 | 363767 | 3315 |
2205259 | 2205259 | 2022-02-11 | Hillsborough | New Hampshire | 33011 | 92948 | 853 |
2200569 | 2200569 | 2022-02-10 | Hillsborough | Florida | 12057 | 355347 | 3315 |
2202006 | 2202006 | 2022-02-10 | Hillsborough | New Hampshire | 33011 | 92642 | 852 |
2197315 | 2197315 | 2022-02-09 | Hillsborough | Florida | 12057 | 355347 | 3315 |
2198752 | 2198752 | 2022-02-09 | Hillsborough | New Hampshire | 33011 | 92393 | 851 |
2194061 | 2194061 | 2022-02-08 | Hillsborough | Florida | 12057 | 355347 | 3275 |
2195498 | 2195498 | 2022-02-08 | Hillsborough | New Hampshire | 33011 | 92089 | 848 |
2190807 | 2190807 | 2022-02-07 | Hillsborough | Florida | 12057 | 355347 | 3275 |
2192244 | 2192244 | 2022-02-07 | Hillsborough | New Hampshire | 33011 | 91955 | 844 |
2187554 | 2187554 | 2022-02-06 | Hillsborough | Florida | 12057 | 355347 | 3275 |
2188991 | 2188991 | 2022-02-06 | Hillsborough | New Hampshire | 33011 | 91228 | 838 |
2184301 | 2184301 | 2022-02-05 | Hillsborough | Florida | 12057 | 355347 | 3275 |
2185738 | 2185738 | 2022-02-05 | Hillsborough | New Hampshire | 33011 | 91228 | 838 |
2181049 | 2181049 | 2022-02-04 | Hillsborough | Florida | 12057 | 355347 | 3275 |
2182486 | 2182486 | 2022-02-04 | Hillsborough | New Hampshire | 33011 | 91228 | 838 |
2177798 | 2177798 | 2022-02-03 | Hillsborough | Florida | 12057 | 346778 | 3275 |
2179234 | 2179234 | 2022-02-03 | Hillsborough | New Hampshire | 33011 | 90820 | 838 |
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);