ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 15001 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 638 ✖
- 81 20
- 75 7
- 82 7
- 25982 7
- 26089 7
- 26142 7
- 26234 7
- 26341 7
- 26501 7
- 26651 7
- 27142 7
- 27707 7
- 117 6
- 74 5
- 1 4
- 5 4
- 70 4
- 83 4
- 86 4
- 87 4
- 115 4
- 41 3
- 73 3
- 85 3
- 114 3
- 2244 3
- 28425 3
- 3 2
- 15 2
- 18 2
- 22 2
- 23 2
- 64 2
- 69 2
- 76 2
- 77 2
- 93 2
- 107 2
- 116 2
- 122 2
- 123 2
- 131 2
- 709 2
- 1481 2
- 2264 2
- 2279 2
- 2795 2
- 2949 2
- 2968 2
- 3353 2
- 7 1
- 10 1
- 12 1
- 20 1
- 26 1
- 28 1
- 31 1
- 34 1
- 39 1
- 40 1
- 44 1
- 61 1
- 62 1
- 67 1
- 68 1
- 78 1
- 79 1
- 90 1
- 91 1
- 94 1
- 95 1
- 96 1
- 97 1
- 98 1
- 100 1
- 101 1
- 102 1
- 105 1
- 109 1
- 111 1
- 113 1
- 128 1
- 133 1
- 135 1
- 139 1
- 144 1
- 145 1
- 148 1
- 149 1
- 152 1
- 159 1
- 164 1
- 177 1
- 192 1
- 200 1
- 209 1
- 220 1
- 243 1
- 253 1
- 279 1
- 318 1
- 340 1
- 364 1
- 383 1
- 418 1
- 435 1
- 469 1
- 493 1
- 506 1
- 517 1
- 530 1
- 540 1
- 548 1
- 569 1
- 579 1
- 594 1
- 601 1
- 606 1
- 610 1
- 630 1
- 640 1
- 647 1
- 652 1
- 659 1
- 667 1
- 680 1
- 685 1
- 700 1
- 702 1
- 712 1
- 739 1
- 745 1
- 763 1
- 806 1
- 821 1
- 831 1
- 845 1
- 863 1
- 877 1
- 922 1
- 935 1
- 959 1
- 964 1
- 985 1
- 1003 1
- 1016 1
- 1037 1
- 1049 1
- 1063 1
- 1070 1
- 1094 1
- 1102 1
- 1131 1
- 1166 1
- 1182 1
- 1233 1
- 1242 1
- 1245 1
- 1250 1
- 1258 1
- 1270 1
- 1285 1
- 1311 1
- 1315 1
- 1322 1
- 1343 1
- 1367 1
- 1386 1
- 1397 1
- 1416 1
- 1420 1
- 1424 1
- 1447 1
- 1462 1
- 1469 1
- 1489 1
- 1495 1
- 1497 1
- 1509 1
- 1523 1
- 1538 1
- 1552 1
- 1562 1
- 1568 1
- 1569 1
- 1580 1
- 1587 1
- 1604 1
- 1608 1
- 1612 1
- 1618 1
- 1619 1
- 1626 1
- 1641 1
- 1654 1
- 1658 1
- 1665 1
- 1670 1
- 1682 1
- 1706 1
- 1708 1
- 1725 1
- 1735 1
- 1750 1
- 1760 1
- 1765 1
- 1780 1
- 1789 1
- 1810 1
- 1823 1
- 1836 1
- 1842 1
- 1855 1
- 1868 1
- 1877 1
- 1880 1
- 1883 1
- 1885 1
- 1892 1
- 1894 1
- 1908 1
- 1922 1
- 1942 1
- 1944 1
- 1948 1
- 1960 1
- 1968 1
- 1986 1
- 1997 1
- 2017 1
- 2029 1
- 2049 1
- 2053 1
- 2060 1
- 2073 1
- 2080 1
- 2091 1
- 2098 1
- 2107 1
- 2113 1
- 2117 1
- 2133 1
- 2140 1
- 2142 1
- 2149 1
- 2155 1
- 2156 1
- 2159 1
- 2166 1
- 2173 1
- 2180 1
- 2191 1
- 2198 1
- 2202 1
- 2206 1
- 2213 1
- 2215 1
- 2216 1
- 2223 1
- 2226 1
- 2229 1
- 2231 1
- 2234 1
- 2239 1
- 2241 1
- 2245 1
- 2252 1
- 2256 1
- 2258 1
- 2262 1
- 2266 1
- 2267 1
- 2268 1
- 2271 1
- 2275 1
- 2276 1
- 2283 1
- 2289 1
- 2297 1
- 2305 1
- 2315 1
- 2322 1
- 2327 1
- 2335 1
- 2354 1
- 2361 1
- 2365 1
- 2372 1
- 2380 1
- 2384 1
- 2391 1
- 2400 1
- 2409 1
- 2414 1
- 2423 1
- 2424 1
- 2431 1
- 2443 1
- 2456 1
- 2470 1
- 2485 1
- 2495 1
- 2501 1
- 2517 1
- 2525 1
- 2544 1
- 2553 1
- 2568 1
- 2582 1
- 2584 1
- 2589 1
- 2600 1
- 2611 1
- 2623 1
- 2629 1
- 2634 1
- 2639 1
- 2654 1
- 2668 1
- 2671 1
- 2682 1
- 2692 1
- 2694 1
- 2695 1
- 2701 1
- 2710 1
- 2715 1
- 2719 1
- 2725 1
- 2728 1
- 2733 1
- 2734 1
- 2738 1
- 2748 1
- 2756 1
- 2759 1
- 2763 1
- 2765 1
- 2767 1
- 2777 1
- 2781 1
- 2787 1
- 2798 1
- 2799 1
- 2806 1
- 2811 1
- 2814 1
- 2817 1
- 2823 1
- 2824 1
- 2834 1
- 2836 1
- 2839 1
- 2840 1
- 2848 1
- 2853 1
- 2855 1
- 2864 1
- 2870 1
- 2875 1
- 2886 1
- 2971 1
- 2996 1
- 3005 1
- 3040 1
- 3043 1
- 3045 1
- 3050 1
- 3060 1
- 3090 1
- 3136 1
- 3138 1
- 3142 1
- 3150 1
- 3151 1
- 3153 1
- 3162 1
- 3192 1
- 3205 1
- 3206 1
- 3211 1
- 3222 1
- 3228 1
- 3230 1
- 3238 1
- 3251 1
- 3253 1
- 3256 1
- 3265 1
- 3267 1
- 3274 1
- 3279 1
- 3287 1
- 3293 1
- 3295 1
- 3304 1
- 3312 1
- 3321 1
- 3341 1
- 3375 1
- 3381 1
- 3398 1
- 3425 1
- 3445 1
- 3463 1
- 3484 1
- 3499 1
- 3508 1
- 3558 1
- 3597 1
- 3641 1
- 3706 1
- 3740 1
- 3767 1
- 3785 1
- 3839 1
- 3950 1
- 4051 1
- 4150 1
- 4226 1
- 4290 1
- 4353 1
- 4484 1
- 4594 1
- 4695 1
- 4813 1
- 4880 1
- 4956 1
- 5035 1
- 5157 1
- 5308 1
- 5442 1
- 5589 1
- 5669 1
- 5753 1
- 5840 1
- 6003 1
- 6165 1
- 6291 1
- 6449 1
- 6556 1
- 6656 1
- 6740 1
- 6916 1
- 7100 1
- 7216 1
- 7430 1
- 7569 1
- 7634 1
- 7698 1
- 7867 1
- 7998 1
- 8126 1
- 8226 1
- 8345 1
- 8395 1
- 8490 1
- 8542 1
- 8682 1
- 8788 1
- 8899 1
- 8981 1
- 9022 1
- 9111 1
- 9207 1
- 9296 1
- 9375 1
- 9452 1
- 9511 1
- 9550 1
- 9588 1
- 9669 1
- 9737 1
- 9803 1
- 9857 1
- 9889 1
- 9913 1
- 9950 1
- 10006 1
- 10097 1
- 10144 1
- 10209 1
- 10249 1
- 10264 1
- 10298 1
- 10352 1
- 10391 1
- 10440 1
- 10474 1
- 10492 1
- 10498 1
- 10527 1
- 10573 1
- 10607 1
- 10645 1
- 10684 1
- 10713 1
- 10719 1
- 10751 1
- 10768 1
- 10802 1
- 10846 1
- 10886 1
- 10914 1
- 10933 1
- 10964 1
- 11002 1
- 11032 1
- 11064 1
- 11097 1
- 11109 1
- 11122 1
- 11143 1
- 11171 1
- 11193 1
- 11215 1
- 11241 1
- 11258 1
- 11279 1
- 11307 1
- 11334 1
- 11363 1
- 11373 1
- 11381 1
- 11406 1
- 11420 1
- 11435 1
- 11492 1
- 11534 1
- 11584 1
- 11596 1
- 11609 1
- 11623 1
- 11637 1
- 11653 1
- 11655 1
- 11678 1
- 11700 1
- 11703 1
- 11705 1
- 11708 1
- 11725 1
- 11739 1
- 11765 1
- 11783 1
- 11795 1
- 11802 1
- 11810 1
- 11823 1
- 11833 1
- 11843 1
- 11859 1
- 11869 1
- 11892 1
- 11897 1
- 11952 1
- 11981 1
- 12003 1
- 12032 1
- 12058 1
- 12067 1
- 12088 1
- 12154 1
- 12245 1
- 12322 1
- 12440 1
- 12543 1
- 12593 1
- 12619 1
- 12861 1
- 13117 1
- 13312 1
- 13550 1
- 13909 1
- 14029 1
- 14185 1
- 14693 1
- 14979 1
- 15387 1
- 15751 1
- 16099 1
- 16307 1
- 16597 1
- 16759 1
- 16856 1
- 17576 1
- 18161 1
- 18415 1
- 19249 1
- 19489 1
- 20056 1
- 20563 1
- 21047 1
- 21418 1
- 21721 1
- 21863 1
- 22013 1
- 22388 1
- 22620 1
- 22913 1
- 23307 1
- 23466 1
- 23606 1
- 23680 1
- 23885 1
- 24071 1
- 24263 1
- 24418 1
- 24543 1
- 24615 1
- 24669 1
- 24800 1
- 24948 1
- 25034 1
- 25098 1
- 25184 1
- 25233 1
- 25237 1
- 25328 1
- 25448 1
- 25506 1
- 25552 1
- 25599 1
- 25625 1
- 25637 1
- 25675 1
- 25716 1
- 25760 1
- 25793 1
- 25822 1
- 25837 1
- 25861 1
- 25885 1
- 25915 1
- 25934 1
- 25951 1
- 25968 1
- 25974 1
state 1
- Hawaii 788
fips 1
- 15001 · 788 ✖
county 1
- Hawaii 788
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3352 | 3352 | 2020-03-17 | Hawaii | Hawaii | 15001 | 1 | 0 |
3914 | 3914 | 2020-03-18 | Hawaii | Hawaii | 15001 | 1 | 0 |
4590 | 4590 | 2020-03-19 | Hawaii | Hawaii | 15001 | 1 | 0 |
5390 | 5390 | 2020-03-20 | Hawaii | Hawaii | 15001 | 1 | 0 |
6324 | 6324 | 2020-03-21 | Hawaii | Hawaii | 15001 | 3 | 0 |
7372 | 7372 | 2020-03-22 | Hawaii | Hawaii | 15001 | 3 | 0 |
8526 | 8526 | 2020-03-23 | Hawaii | Hawaii | 15001 | 5 | 0 |
9787 | 9787 | 2020-03-24 | Hawaii | Hawaii | 15001 | 5 | 0 |
11172 | 11172 | 2020-03-25 | Hawaii | Hawaii | 15001 | 5 | 0 |
12725 | 12725 | 2020-03-26 | Hawaii | Hawaii | 15001 | 5 | 0 |
14400 | 14400 | 2020-03-27 | Hawaii | Hawaii | 15001 | 7 | 0 |
16191 | 16191 | 2020-03-28 | Hawaii | Hawaii | 15001 | 10 | 0 |
18088 | 18088 | 2020-03-29 | Hawaii | Hawaii | 15001 | 12 | 0 |
20084 | 20084 | 2020-03-30 | Hawaii | Hawaii | 15001 | 15 | 0 |
22173 | 22173 | 2020-03-31 | Hawaii | Hawaii | 15001 | 15 | 0 |
24339 | 24339 | 2020-04-01 | Hawaii | Hawaii | 15001 | 18 | 0 |
26571 | 26571 | 2020-04-02 | Hawaii | Hawaii | 15001 | 18 | 0 |
28878 | 28878 | 2020-04-03 | Hawaii | Hawaii | 15001 | 20 | 0 |
31239 | 31239 | 2020-04-04 | Hawaii | Hawaii | 15001 | 22 | 0 |
33646 | 33646 | 2020-04-05 | Hawaii | Hawaii | 15001 | 22 | 0 |
36097 | 36097 | 2020-04-06 | Hawaii | Hawaii | 15001 | 23 | 0 |
38590 | 38590 | 2020-04-07 | Hawaii | Hawaii | 15001 | 23 | 0 |
41134 | 41134 | 2020-04-08 | Hawaii | Hawaii | 15001 | 26 | 0 |
43708 | 43708 | 2020-04-09 | Hawaii | Hawaii | 15001 | 28 | 0 |
46310 | 46310 | 2020-04-10 | Hawaii | Hawaii | 15001 | 31 | 0 |
48941 | 48941 | 2020-04-11 | Hawaii | Hawaii | 15001 | 34 | 0 |
51603 | 51603 | 2020-04-12 | Hawaii | Hawaii | 15001 | 39 | 0 |
54283 | 54283 | 2020-04-13 | Hawaii | Hawaii | 15001 | 40 | 0 |
56975 | 56975 | 2020-04-14 | Hawaii | Hawaii | 15001 | 41 | 0 |
59682 | 59682 | 2020-04-15 | Hawaii | Hawaii | 15001 | 41 | 0 |
62402 | 62402 | 2020-04-16 | Hawaii | Hawaii | 15001 | 41 | 0 |
65135 | 65135 | 2020-04-17 | Hawaii | Hawaii | 15001 | 44 | 0 |
67883 | 67883 | 2020-04-18 | Hawaii | Hawaii | 15001 | 61 | 0 |
70645 | 70645 | 2020-04-19 | Hawaii | Hawaii | 15001 | 62 | 0 |
73414 | 73414 | 2020-04-20 | Hawaii | Hawaii | 15001 | 64 | 0 |
76190 | 76190 | 2020-04-21 | Hawaii | Hawaii | 15001 | 64 | 0 |
78974 | 78974 | 2020-04-22 | Hawaii | Hawaii | 15001 | 67 | 0 |
81767 | 81767 | 2020-04-23 | Hawaii | Hawaii | 15001 | 68 | 0 |
84567 | 84567 | 2020-04-24 | Hawaii | Hawaii | 15001 | 69 | 0 |
87376 | 87376 | 2020-04-25 | Hawaii | Hawaii | 15001 | 69 | 0 |
90192 | 90192 | 2020-04-26 | Hawaii | Hawaii | 15001 | 70 | 0 |
93011 | 93011 | 2020-04-27 | Hawaii | Hawaii | 15001 | 70 | 0 |
95843 | 95843 | 2020-04-28 | Hawaii | Hawaii | 15001 | 70 | 0 |
98687 | 98687 | 2020-04-29 | Hawaii | Hawaii | 15001 | 70 | 0 |
101538 | 101538 | 2020-04-30 | Hawaii | Hawaii | 15001 | 73 | 0 |
104393 | 104393 | 2020-05-01 | Hawaii | Hawaii | 15001 | 73 | 0 |
107258 | 107258 | 2020-05-02 | Hawaii | Hawaii | 15001 | 73 | 0 |
110128 | 110128 | 2020-05-03 | Hawaii | Hawaii | 15001 | 74 | 0 |
115886 | 115886 | 2020-05-05 | Hawaii | Hawaii | 15001 | 74 | 0 |
118846 | 118846 | 2020-05-06 | Hawaii | Hawaii | 15001 | 74 | 0 |
121816 | 121816 | 2020-05-07 | Hawaii | Hawaii | 15001 | 74 | 0 |
124795 | 124795 | 2020-05-08 | Hawaii | Hawaii | 15001 | 74 | 0 |
113003 | 113003 | 2020-05-04 | Hawaii | Hawaii | 15001 | 75 | 0 |
127782 | 127782 | 2020-05-09 | Hawaii | Hawaii | 15001 | 75 | 0 |
130773 | 130773 | 2020-05-10 | Hawaii | Hawaii | 15001 | 75 | 0 |
133764 | 133764 | 2020-05-11 | Hawaii | Hawaii | 15001 | 75 | 0 |
136753 | 136753 | 2020-05-12 | Hawaii | Hawaii | 15001 | 75 | 0 |
139744 | 139744 | 2020-05-13 | Hawaii | Hawaii | 15001 | 75 | 0 |
142740 | 142740 | 2020-05-14 | Hawaii | Hawaii | 15001 | 75 | 0 |
145740 | 145740 | 2020-05-15 | Hawaii | Hawaii | 15001 | 76 | 0 |
148743 | 148743 | 2020-05-16 | Hawaii | Hawaii | 15001 | 76 | 0 |
151752 | 151752 | 2020-05-17 | Hawaii | Hawaii | 15001 | 77 | 0 |
154764 | 154764 | 2020-05-18 | Hawaii | Hawaii | 15001 | 77 | 0 |
157780 | 157780 | 2020-05-19 | Hawaii | Hawaii | 15001 | 78 | 0 |
160806 | 160806 | 2020-05-20 | Hawaii | Hawaii | 15001 | 79 | 0 |
166867 | 166867 | 2020-05-22 | Hawaii | Hawaii | 15001 | 81 | 0 |
169904 | 169904 | 2020-05-23 | Hawaii | Hawaii | 15001 | 81 | 0 |
172945 | 172945 | 2020-05-24 | Hawaii | Hawaii | 15001 | 81 | 0 |
175988 | 175988 | 2020-05-25 | Hawaii | Hawaii | 15001 | 81 | 0 |
179032 | 179032 | 2020-05-26 | Hawaii | Hawaii | 15001 | 81 | 0 |
191251 | 191251 | 2020-05-30 | Hawaii | Hawaii | 15001 | 81 | 0 |
194318 | 194318 | 2020-05-31 | Hawaii | Hawaii | 15001 | 81 | 0 |
197388 | 197388 | 2020-06-01 | Hawaii | Hawaii | 15001 | 81 | 0 |
200461 | 200461 | 2020-06-02 | Hawaii | Hawaii | 15001 | 81 | 0 |
203537 | 203537 | 2020-06-03 | Hawaii | Hawaii | 15001 | 81 | 0 |
206617 | 206617 | 2020-06-04 | Hawaii | Hawaii | 15001 | 81 | 0 |
209698 | 209698 | 2020-06-05 | Hawaii | Hawaii | 15001 | 81 | 0 |
212783 | 212783 | 2020-06-06 | Hawaii | Hawaii | 15001 | 81 | 0 |
215870 | 215870 | 2020-06-07 | Hawaii | Hawaii | 15001 | 81 | 0 |
218961 | 218961 | 2020-06-08 | Hawaii | Hawaii | 15001 | 81 | 0 |
222056 | 222056 | 2020-06-09 | Hawaii | Hawaii | 15001 | 81 | 0 |
225151 | 225151 | 2020-06-10 | Hawaii | Hawaii | 15001 | 81 | 0 |
228253 | 228253 | 2020-06-11 | Hawaii | Hawaii | 15001 | 81 | 0 |
231356 | 231356 | 2020-06-12 | Hawaii | Hawaii | 15001 | 81 | 0 |
234462 | 234462 | 2020-06-13 | Hawaii | Hawaii | 15001 | 81 | 0 |
163834 | 163834 | 2020-05-21 | Hawaii | Hawaii | 15001 | 82 | 0 |
182076 | 182076 | 2020-05-27 | Hawaii | Hawaii | 15001 | 82 | 0 |
185130 | 185130 | 2020-05-28 | Hawaii | Hawaii | 15001 | 82 | 0 |
188186 | 188186 | 2020-05-29 | Hawaii | Hawaii | 15001 | 82 | 0 |
237569 | 237569 | 2020-06-14 | Hawaii | Hawaii | 15001 | 82 | 0 |
240677 | 240677 | 2020-06-15 | Hawaii | Hawaii | 15001 | 82 | 0 |
243788 | 243788 | 2020-06-16 | Hawaii | Hawaii | 15001 | 82 | 0 |
246901 | 246901 | 2020-06-17 | Hawaii | Hawaii | 15001 | 83 | 0 |
250013 | 250013 | 2020-06-18 | Hawaii | Hawaii | 15001 | 83 | 0 |
253128 | 253128 | 2020-06-19 | Hawaii | Hawaii | 15001 | 83 | 0 |
256247 | 256247 | 2020-06-20 | Hawaii | Hawaii | 15001 | 83 | 0 |
259374 | 259374 | 2020-06-21 | Hawaii | Hawaii | 15001 | 85 | 0 |
262501 | 262501 | 2020-06-22 | Hawaii | Hawaii | 15001 | 85 | 0 |
265629 | 265629 | 2020-06-23 | Hawaii | Hawaii | 15001 | 85 | 0 |
268759 | 268759 | 2020-06-24 | Hawaii | Hawaii | 15001 | 86 | 0 |
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);