ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Unknown" and state = "Guam" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423 | 2423 | 2020-03-15 | Unknown | Guam | 3 | 0 | |
2864 | 2864 | 2020-03-16 | Unknown | Guam | 3 | 0 | |
3351 | 3351 | 2020-03-17 | Unknown | Guam | 3 | 0 | |
3913 | 3913 | 2020-03-18 | Unknown | Guam | 8 | 0 | |
4589 | 4589 | 2020-03-19 | Unknown | Guam | 12 | 0 | |
5389 | 5389 | 2020-03-20 | Unknown | Guam | 14 | 0 | |
6323 | 6323 | 2020-03-21 | Unknown | Guam | 15 | 0 | |
7371 | 7371 | 2020-03-22 | Unknown | Guam | 27 | 1 | |
8525 | 8525 | 2020-03-23 | Unknown | Guam | 29 | 1 | |
9786 | 9786 | 2020-03-24 | Unknown | Guam | 32 | 1 | |
11171 | 11171 | 2020-03-25 | Unknown | Guam | 32 | 1 | |
12724 | 12724 | 2020-03-26 | Unknown | Guam | 49 | 1 | |
14399 | 14399 | 2020-03-27 | Unknown | Guam | 53 | 1 | |
16190 | 16190 | 2020-03-28 | Unknown | Guam | 57 | 1 | |
18087 | 18087 | 2020-03-29 | Unknown | Guam | 58 | 1 | |
20083 | 20083 | 2020-03-30 | Unknown | Guam | 60 | 1 | |
22172 | 22172 | 2020-03-31 | Unknown | Guam | 139 | 2 | |
24338 | 24338 | 2020-04-01 | Unknown | Guam | 147 | 3 | |
26570 | 26570 | 2020-04-02 | Unknown | Guam | 152 | 3 | |
28877 | 28877 | 2020-04-03 | Unknown | Guam | 154 | 4 | |
31238 | 31238 | 2020-04-04 | Unknown | Guam | 223 | 4 | |
33645 | 33645 | 2020-04-05 | Unknown | Guam | 265 | 4 | |
36096 | 36096 | 2020-04-06 | Unknown | Guam | 266 | 4 | |
38589 | 38589 | 2020-04-07 | Unknown | Guam | 274 | 4 | |
41133 | 41133 | 2020-04-08 | Unknown | Guam | 409 | 4 | |
43707 | 43707 | 2020-04-09 | Unknown | Guam | 542 | 4 | |
46309 | 46309 | 2020-04-10 | Unknown | Guam | 577 | 4 | |
48940 | 48940 | 2020-04-11 | Unknown | Guam | 681 | 5 | |
51602 | 51602 | 2020-04-12 | Unknown | Guam | 716 | 5 | |
54282 | 54282 | 2020-04-13 | Unknown | Guam | 719 | 6 | |
56974 | 56974 | 2020-04-14 | Unknown | Guam | 721 | 6 | |
59681 | 59681 | 2020-04-15 | Unknown | Guam | 750 | 6 | |
62401 | 62401 | 2020-04-16 | Unknown | Guam | 790 | 6 | |
65134 | 65134 | 2020-04-17 | Unknown | Guam | 796 | 6 | |
67882 | 67882 | 2020-04-18 | Unknown | Guam | 805 | 6 | |
70644 | 70644 | 2020-04-19 | Unknown | Guam | 808 | 6 | |
73413 | 73413 | 2020-04-20 | Unknown | Guam | 811 | 6 | |
76189 | 76189 | 2020-04-21 | Unknown | Guam | 852 | 6 | |
78973 | 78973 | 2020-04-22 | Unknown | Guam | 911 | 6 | |
81766 | 81766 | 2020-04-23 | Unknown | Guam | 979 | 6 | |
84566 | 84566 | 2020-04-24 | Unknown | Guam | 997 | 6 | |
87375 | 87375 | 2020-04-25 | Unknown | Guam | 997 | 6 | |
90191 | 90191 | 2020-04-26 | Unknown | Guam | 997 | 6 | |
93010 | 93010 | 2020-04-27 | Unknown | Guam | 1113 | 6 | |
95842 | 95842 | 2020-04-28 | Unknown | Guam | 1114 | 6 | |
98686 | 98686 | 2020-04-29 | Unknown | Guam | 1114 | 6 | |
101537 | 101537 | 2020-04-30 | Unknown | Guam | 1115 | 6 | |
104392 | 104392 | 2020-05-01 | Unknown | Guam | 1115 | 6 | |
107257 | 107257 | 2020-05-02 | Unknown | Guam | 1117 | 6 | |
110127 | 110127 | 2020-05-03 | Unknown | Guam | 1118 | 6 | |
113002 | 113002 | 2020-05-04 | Unknown | Guam | 1118 | 6 | |
115885 | 115885 | 2020-05-05 | Unknown | Guam | 1118 | 6 | |
118845 | 118845 | 2020-05-06 | Unknown | Guam | 1118 | 6 | |
121815 | 121815 | 2020-05-07 | Unknown | Guam | 1118 | 6 | |
124794 | 124794 | 2020-05-08 | Unknown | Guam | 1120 | 6 | |
127781 | 127781 | 2020-05-09 | Unknown | Guam | 1120 | 6 | |
130772 | 130772 | 2020-05-10 | Unknown | Guam | 1120 | 6 | |
133763 | 133763 | 2020-05-11 | Unknown | Guam | 1120 | 6 | |
136752 | 136752 | 2020-05-12 | Unknown | Guam | 1121 | 6 | |
139743 | 139743 | 2020-05-13 | Unknown | Guam | 1121 | 6 | |
142739 | 142739 | 2020-05-14 | Unknown | Guam | 1121 | 6 | |
145739 | 145739 | 2020-05-15 | Unknown | Guam | 1123 | 6 | |
148742 | 148742 | 2020-05-16 | Unknown | Guam | 1123 | 6 | |
151751 | 151751 | 2020-05-17 | Unknown | Guam | 1123 | 6 | |
154763 | 154763 | 2020-05-18 | Unknown | Guam | 1123 | 6 | |
157779 | 157779 | 2020-05-19 | Unknown | Guam | 1123 | 6 | |
160805 | 160805 | 2020-05-20 | Unknown | Guam | 1134 | 6 | |
163833 | 163833 | 2020-05-21 | Unknown | Guam | 1134 | 6 | |
166866 | 166866 | 2020-05-22 | Unknown | Guam | 1134 | 6 | |
169903 | 169903 | 2020-05-23 | Unknown | Guam | 1134 | 6 | |
172944 | 172944 | 2020-05-24 | Unknown | Guam | 1135 | 6 | |
175987 | 175987 | 2020-05-25 | Unknown | Guam | 1135 | 6 | |
179031 | 179031 | 2020-05-26 | Unknown | Guam | 1139 | 6 | |
182075 | 182075 | 2020-05-27 | Unknown | Guam | 1140 | 6 | |
185129 | 185129 | 2020-05-28 | Unknown | Guam | 1141 | 6 | |
188185 | 188185 | 2020-05-29 | Unknown | Guam | 1141 | 6 | |
191250 | 191250 | 2020-05-30 | Unknown | Guam | 1141 | 6 | |
194317 | 194317 | 2020-05-31 | Unknown | Guam | 1144 | 6 | |
197387 | 197387 | 2020-06-01 | Unknown | Guam | 1144 | 6 | |
200460 | 200460 | 2020-06-02 | Unknown | Guam | 1146 | 6 | |
203536 | 203536 | 2020-06-03 | Unknown | Guam | 1146 | 6 | |
206616 | 206616 | 2020-06-04 | Unknown | Guam | 1148 | 6 | |
209697 | 209697 | 2020-06-05 | Unknown | Guam | 1148 | 6 | |
212782 | 212782 | 2020-06-06 | Unknown | Guam | 1148 | 6 | |
215869 | 215869 | 2020-06-07 | Unknown | Guam | 1148 | 6 | |
218960 | 218960 | 2020-06-08 | Unknown | Guam | 1149 | 6 | |
222055 | 222055 | 2020-06-09 | Unknown | Guam | 1149 | 6 | |
225150 | 225150 | 2020-06-10 | Unknown | Guam | 1149 | 6 | |
228252 | 228252 | 2020-06-11 | Unknown | Guam | 1152 | 6 | |
231355 | 231355 | 2020-06-12 | Unknown | Guam | 1153 | 6 | |
234461 | 234461 | 2020-06-13 | Unknown | Guam | 1154 | 6 | |
237568 | 237568 | 2020-06-14 | Unknown | Guam | 1154 | 6 | |
240676 | 240676 | 2020-06-15 | Unknown | Guam | 1155 | 6 | |
243787 | 243787 | 2020-06-16 | Unknown | Guam | 1155 | 6 | |
246900 | 246900 | 2020-06-17 | Unknown | Guam | 1157 | 6 | |
250012 | 250012 | 2020-06-18 | Unknown | Guam | 1162 | 6 | |
253127 | 253127 | 2020-06-19 | Unknown | Guam | 1169 | 6 | |
256246 | 256246 | 2020-06-20 | Unknown | Guam | 1191 | 6 | |
259373 | 259373 | 2020-06-21 | Unknown | Guam | 1191 | 6 | |
262500 | 262500 | 2020-06-22 | Unknown | Guam | 1191 | 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);