ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 15009 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426 | 2426 | 2020-03-15 | Maui | Hawaii | 15009 | 1 | 0 |
2867 | 2867 | 2020-03-16 | Maui | Hawaii | 15009 | 2 | 0 |
3355 | 3355 | 2020-03-17 | Maui | Hawaii | 15009 | 3 | 0 |
3917 | 3917 | 2020-03-18 | Maui | Hawaii | 15009 | 3 | 0 |
4593 | 4593 | 2020-03-19 | Maui | Hawaii | 15009 | 5 | 0 |
5393 | 5393 | 2020-03-20 | Maui | Hawaii | 15009 | 5 | 0 |
6327 | 6327 | 2020-03-21 | Maui | Hawaii | 15009 | 7 | 0 |
7375 | 7375 | 2020-03-22 | Maui | Hawaii | 15009 | 9 | 0 |
8529 | 8529 | 2020-03-23 | Maui | Hawaii | 15009 | 11 | 0 |
9790 | 9790 | 2020-03-24 | Maui | Hawaii | 15009 | 11 | 0 |
11175 | 11175 | 2020-03-25 | Maui | Hawaii | 15009 | 13 | 0 |
12728 | 12728 | 2020-03-26 | Maui | Hawaii | 15009 | 14 | 0 |
14403 | 14403 | 2020-03-27 | Maui | Hawaii | 15009 | 16 | 0 |
16194 | 16194 | 2020-03-28 | Maui | Hawaii | 15009 | 16 | 0 |
18091 | 18091 | 2020-03-29 | Maui | Hawaii | 15009 | 20 | 0 |
20087 | 20087 | 2020-03-30 | Maui | Hawaii | 15009 | 25 | 0 |
22176 | 22176 | 2020-03-31 | Maui | Hawaii | 15009 | 25 | 0 |
24342 | 24342 | 2020-04-01 | Maui | Hawaii | 15009 | 26 | 0 |
26574 | 26574 | 2020-04-02 | Maui | Hawaii | 15009 | 27 | 0 |
28881 | 28881 | 2020-04-03 | Maui | Hawaii | 15009 | 36 | 0 |
31242 | 31242 | 2020-04-04 | Maui | Hawaii | 15009 | 38 | 0 |
33649 | 33649 | 2020-04-05 | Maui | Hawaii | 15009 | 43 | 0 |
36100 | 36100 | 2020-04-06 | Maui | Hawaii | 15009 | 44 | 1 |
38593 | 38593 | 2020-04-07 | Maui | Hawaii | 15009 | 48 | 1 |
41137 | 41137 | 2020-04-08 | Maui | Hawaii | 15009 | 54 | 1 |
43711 | 43711 | 2020-04-09 | Maui | Hawaii | 15009 | 57 | 2 |
46313 | 46313 | 2020-04-10 | Maui | Hawaii | 15009 | 66 | 3 |
48944 | 48944 | 2020-04-11 | Maui | Hawaii | 15009 | 80 | 3 |
51606 | 51606 | 2020-04-12 | Maui | Hawaii | 15009 | 84 | 3 |
54286 | 54286 | 2020-04-13 | Maui | Hawaii | 15009 | 86 | 3 |
56978 | 56978 | 2020-04-14 | Maui | Hawaii | 15009 | 88 | 3 |
59685 | 59685 | 2020-04-15 | Maui | Hawaii | 15009 | 92 | 3 |
62405 | 62405 | 2020-04-16 | Maui | Hawaii | 15009 | 95 | 3 |
65138 | 65138 | 2020-04-17 | Maui | Hawaii | 15009 | 102 | 3 |
67886 | 67886 | 2020-04-18 | Maui | Hawaii | 15009 | 104 | 3 |
70648 | 70648 | 2020-04-19 | Maui | Hawaii | 15009 | 106 | 4 |
73417 | 73417 | 2020-04-20 | Maui | Hawaii | 15009 | 108 | 4 |
76193 | 76193 | 2020-04-21 | Maui | Hawaii | 15009 | 110 | 5 |
78977 | 78977 | 2020-04-22 | Maui | Hawaii | 15009 | 110 | 5 |
81770 | 81770 | 2020-04-23 | Maui | Hawaii | 15009 | 112 | 5 |
84570 | 84570 | 2020-04-24 | Maui | Hawaii | 15009 | 113 | 5 |
87379 | 87379 | 2020-04-25 | Maui | Hawaii | 15009 | 112 | 5 |
90195 | 90195 | 2020-04-26 | Maui | Hawaii | 15009 | 112 | 5 |
93014 | 93014 | 2020-04-27 | Maui | Hawaii | 15009 | 113 | 5 |
95846 | 95846 | 2020-04-28 | Maui | Hawaii | 15009 | 115 | 5 |
98690 | 98690 | 2020-04-29 | Maui | Hawaii | 15009 | 115 | 5 |
101541 | 101541 | 2020-04-30 | Maui | Hawaii | 15009 | 116 | 5 |
104396 | 104396 | 2020-05-01 | Maui | Hawaii | 15009 | 116 | 5 |
107261 | 107261 | 2020-05-02 | Maui | Hawaii | 15009 | 117 | 5 |
110131 | 110131 | 2020-05-03 | Maui | Hawaii | 15009 | 116 | 6 |
113006 | 113006 | 2020-05-04 | Maui | Hawaii | 15009 | 116 | 6 |
115889 | 115889 | 2020-05-05 | Maui | Hawaii | 15009 | 116 | 6 |
118849 | 118849 | 2020-05-06 | Maui | Hawaii | 15009 | 116 | 6 |
121819 | 121819 | 2020-05-07 | Maui | Hawaii | 15009 | 116 | 6 |
124798 | 124798 | 2020-05-08 | Maui | Hawaii | 15009 | 116 | 6 |
127785 | 127785 | 2020-05-09 | Maui | Hawaii | 15009 | 117 | 6 |
130776 | 130776 | 2020-05-10 | Maui | Hawaii | 15009 | 117 | 6 |
133767 | 133767 | 2020-05-11 | Maui | Hawaii | 15009 | 117 | 6 |
136756 | 136756 | 2020-05-12 | Maui | Hawaii | 15009 | 117 | 6 |
139747 | 139747 | 2020-05-13 | Maui | Hawaii | 15009 | 117 | 6 |
142743 | 142743 | 2020-05-14 | Maui | Hawaii | 15009 | 117 | 6 |
145743 | 145743 | 2020-05-15 | Maui | Hawaii | 15009 | 117 | 6 |
148746 | 148746 | 2020-05-16 | Maui | Hawaii | 15009 | 117 | 6 |
151755 | 151755 | 2020-05-17 | Maui | Hawaii | 15009 | 117 | 6 |
154767 | 154767 | 2020-05-18 | Maui | Hawaii | 15009 | 117 | 6 |
157783 | 157783 | 2020-05-19 | Maui | Hawaii | 15009 | 117 | 6 |
160809 | 160809 | 2020-05-20 | Maui | Hawaii | 15009 | 117 | 6 |
163837 | 163837 | 2020-05-21 | Maui | Hawaii | 15009 | 118 | 6 |
166870 | 166870 | 2020-05-22 | Maui | Hawaii | 15009 | 117 | 6 |
169907 | 169907 | 2020-05-23 | Maui | Hawaii | 15009 | 118 | 6 |
172948 | 172948 | 2020-05-24 | Maui | Hawaii | 15009 | 118 | 6 |
175991 | 175991 | 2020-05-25 | Maui | Hawaii | 15009 | 118 | 6 |
179035 | 179035 | 2020-05-26 | Maui | Hawaii | 15009 | 118 | 6 |
182079 | 182079 | 2020-05-27 | Maui | Hawaii | 15009 | 118 | 6 |
185133 | 185133 | 2020-05-28 | Maui | Hawaii | 15009 | 118 | 6 |
188189 | 188189 | 2020-05-29 | Maui | Hawaii | 15009 | 118 | 6 |
191254 | 191254 | 2020-05-30 | Maui | Hawaii | 15009 | 119 | 6 |
194321 | 194321 | 2020-05-31 | Maui | Hawaii | 15009 | 120 | 6 |
197391 | 197391 | 2020-06-01 | Maui | Hawaii | 15009 | 120 | 6 |
200464 | 200464 | 2020-06-02 | Maui | Hawaii | 15009 | 120 | 6 |
203540 | 203540 | 2020-06-03 | Maui | Hawaii | 15009 | 119 | 6 |
206620 | 206620 | 2020-06-04 | Maui | Hawaii | 15009 | 119 | 6 |
209701 | 209701 | 2020-06-05 | Maui | Hawaii | 15009 | 120 | 6 |
212786 | 212786 | 2020-06-06 | Maui | Hawaii | 15009 | 120 | 6 |
215873 | 215873 | 2020-06-07 | Maui | Hawaii | 15009 | 120 | 6 |
218964 | 218964 | 2020-06-08 | Maui | Hawaii | 15009 | 120 | 6 |
222059 | 222059 | 2020-06-09 | Maui | Hawaii | 15009 | 120 | 6 |
225154 | 225154 | 2020-06-10 | Maui | Hawaii | 15009 | 120 | 6 |
228256 | 228256 | 2020-06-11 | Maui | Hawaii | 15009 | 120 | 6 |
231359 | 231359 | 2020-06-12 | Maui | Hawaii | 15009 | 120 | 6 |
234465 | 234465 | 2020-06-13 | Maui | Hawaii | 15009 | 120 | 6 |
237572 | 237572 | 2020-06-14 | Maui | Hawaii | 15009 | 120 | 6 |
240680 | 240680 | 2020-06-15 | Maui | Hawaii | 15009 | 120 | 6 |
243791 | 243791 | 2020-06-16 | Maui | Hawaii | 15009 | 120 | 6 |
246904 | 246904 | 2020-06-17 | Maui | Hawaii | 15009 | 120 | 6 |
250016 | 250016 | 2020-06-18 | Maui | Hawaii | 15009 | 120 | 6 |
253131 | 253131 | 2020-06-19 | Maui | Hawaii | 15009 | 121 | 6 |
256250 | 256250 | 2020-06-20 | Maui | Hawaii | 15009 | 122 | 6 |
259377 | 259377 | 2020-06-21 | Maui | Hawaii | 15009 | 122 | 6 |
262504 | 262504 | 2020-06-22 | Maui | Hawaii | 15009 | 122 | 6 |
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);