ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 15003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500128 | 2500128 | 2022-05-13 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2496870 | 2496870 | 2022-05-12 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2493612 | 2493612 | 2022-05-11 | Honolulu | Hawaii | 15003 | 178469 | 1063 |
2490354 | 2490354 | 2022-05-10 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2487097 | 2487097 | 2022-05-09 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2483839 | 2483839 | 2022-05-08 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2480581 | 2480581 | 2022-05-07 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2477323 | 2477323 | 2022-05-06 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2474065 | 2474065 | 2022-05-05 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2470808 | 2470808 | 2022-05-04 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2467552 | 2467552 | 2022-05-03 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2464297 | 2464297 | 2022-05-02 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2461041 | 2461041 | 2022-05-01 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2457785 | 2457785 | 2022-04-30 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2454529 | 2454529 | 2022-04-29 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2451273 | 2451273 | 2022-04-28 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2448017 | 2448017 | 2022-04-27 | Honolulu | Hawaii | 15003 | 171763 | 1052 |
2444761 | 2444761 | 2022-04-26 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2441505 | 2441505 | 2022-04-25 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2438249 | 2438249 | 2022-04-24 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2434993 | 2434993 | 2022-04-23 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2431737 | 2431737 | 2022-04-22 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2428481 | 2428481 | 2022-04-21 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2425225 | 2425225 | 2022-04-20 | Honolulu | Hawaii | 15003 | 169656 | 1043 |
2421969 | 2421969 | 2022-04-19 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2418713 | 2418713 | 2022-04-18 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2415457 | 2415457 | 2022-04-17 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2412201 | 2412201 | 2022-04-16 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2408945 | 2408945 | 2022-04-15 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2405689 | 2405689 | 2022-04-14 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2402434 | 2402434 | 2022-04-13 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2399179 | 2399179 | 2022-04-12 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2395924 | 2395924 | 2022-04-11 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2392668 | 2392668 | 2022-04-10 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2389412 | 2389412 | 2022-04-09 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2386157 | 2386157 | 2022-04-08 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2382902 | 2382902 | 2022-04-07 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2379647 | 2379647 | 2022-04-06 | Honolulu | Hawaii | 15003 | 167503 | 1022 |
2376393 | 2376393 | 2022-04-05 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2373141 | 2373141 | 2022-04-04 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2369888 | 2369888 | 2022-04-03 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2366635 | 2366635 | 2022-04-02 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2363382 | 2363382 | 2022-04-01 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2360128 | 2360128 | 2022-03-31 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2356874 | 2356874 | 2022-03-30 | Honolulu | Hawaii | 15003 | 166620 | 1019 |
2353621 | 2353621 | 2022-03-29 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2350369 | 2350369 | 2022-03-28 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2347116 | 2347116 | 2022-03-27 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2343863 | 2343863 | 2022-03-26 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2340610 | 2340610 | 2022-03-25 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2337357 | 2337357 | 2022-03-24 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2334103 | 2334103 | 2022-03-23 | Honolulu | Hawaii | 15003 | 165789 | 1013 |
2330849 | 2330849 | 2022-03-22 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2327597 | 2327597 | 2022-03-21 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2324344 | 2324344 | 2022-03-20 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2321090 | 2321090 | 2022-03-19 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2317836 | 2317836 | 2022-03-18 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2314583 | 2314583 | 2022-03-17 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2311330 | 2311330 | 2022-03-16 | Honolulu | Hawaii | 15003 | 165272 | 1009 |
2308077 | 2308077 | 2022-03-15 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2304826 | 2304826 | 2022-03-14 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2301574 | 2301574 | 2022-03-13 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2298322 | 2298322 | 2022-03-12 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2295070 | 2295070 | 2022-03-11 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2291818 | 2291818 | 2022-03-10 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2288566 | 2288566 | 2022-03-09 | Honolulu | Hawaii | 15003 | 164664 | 998 |
2285315 | 2285315 | 2022-03-08 | Honolulu | Hawaii | 15003 | 164576 | 998 |
2282063 | 2282063 | 2022-03-07 | Honolulu | Hawaii | 15003 | 164525 | 998 |
2278810 | 2278810 | 2022-03-06 | Honolulu | Hawaii | 15003 | 164472 | 993 |
2275557 | 2275557 | 2022-03-05 | Honolulu | Hawaii | 15003 | 164348 | 993 |
2272304 | 2272304 | 2022-03-04 | Honolulu | Hawaii | 15003 | 164227 | 993 |
2269052 | 2269052 | 2022-03-03 | Honolulu | Hawaii | 15003 | 164088 | 990 |
2265799 | 2265799 | 2022-03-02 | Honolulu | Hawaii | 15003 | 163890 | 987 |
2262548 | 2262548 | 2022-03-01 | Honolulu | Hawaii | 15003 | 163807 | 982 |
2259297 | 2259297 | 2022-02-28 | Honolulu | Hawaii | 15003 | 163733 | 982 |
2256046 | 2256046 | 2022-02-27 | Honolulu | Hawaii | 15003 | 163668 | 982 |
2252795 | 2252795 | 2022-02-26 | Honolulu | Hawaii | 15003 | 163535 | 978 |
2249544 | 2249544 | 2022-02-25 | Honolulu | Hawaii | 15003 | 163306 | 970 |
2246293 | 2246293 | 2022-02-24 | Honolulu | Hawaii | 15003 | 163111 | 962 |
2243042 | 2243042 | 2022-02-23 | Honolulu | Hawaii | 15003 | 162910 | 957 |
2239791 | 2239791 | 2022-02-22 | Honolulu | Hawaii | 15003 | 162819 | 957 |
2236540 | 2236540 | 2022-02-21 | Honolulu | Hawaii | 15003 | 162723 | 957 |
2233289 | 2233289 | 2022-02-20 | Honolulu | Hawaii | 15003 | 162617 | 957 |
2230038 | 2230038 | 2022-02-19 | Honolulu | Hawaii | 15003 | 162422 | 954 |
2226787 | 2226787 | 2022-02-18 | Honolulu | Hawaii | 15003 | 162202 | 950 |
2223536 | 2223536 | 2022-02-17 | Honolulu | Hawaii | 15003 | 161942 | 948 |
2220285 | 2220285 | 2022-02-16 | Honolulu | Hawaii | 15003 | 161589 | 935 |
2217034 | 2217034 | 2022-02-15 | Honolulu | Hawaii | 15003 | 161436 | 929 |
2213783 | 2213783 | 2022-02-14 | Honolulu | Hawaii | 15003 | 161243 | 929 |
2210531 | 2210531 | 2022-02-13 | Honolulu | Hawaii | 15003 | 161015 | 929 |
2207278 | 2207278 | 2022-02-12 | Honolulu | Hawaii | 15003 | 160728 | 926 |
2204025 | 2204025 | 2022-02-11 | Honolulu | Hawaii | 15003 | 160390 | 919 |
2200772 | 2200772 | 2022-02-10 | Honolulu | Hawaii | 15003 | 159976 | 913 |
2197518 | 2197518 | 2022-02-09 | Honolulu | Hawaii | 15003 | 159161 | 910 |
2194264 | 2194264 | 2022-02-08 | Honolulu | Hawaii | 15003 | 158838 | 906 |
2191010 | 2191010 | 2022-02-07 | Honolulu | Hawaii | 15003 | 158481 | 906 |
2187757 | 2187757 | 2022-02-06 | Honolulu | Hawaii | 15003 | 157993 | 906 |
2184504 | 2184504 | 2022-02-05 | Honolulu | Hawaii | 15003 | 157456 | 902 |
2181252 | 2181252 | 2022-02-04 | Honolulu | Hawaii | 15003 | 156706 | 890 |
2178001 | 2178001 | 2022-02-03 | Honolulu | Hawaii | 15003 | 156007 | 882 |
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);