ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "San Juan" and fips = 49037 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17475 | 17475 | 2020-03-28 | San Juan | Utah | 49037 | 1 | 0 |
19434 | 19434 | 2020-03-29 | San Juan | Utah | 49037 | 4 | 0 |
21497 | 21497 | 2020-03-30 | San Juan | Utah | 49037 | 4 | 0 |
23636 | 23636 | 2020-03-31 | San Juan | Utah | 49037 | 4 | 0 |
25851 | 25851 | 2020-04-01 | San Juan | Utah | 49037 | 4 | 0 |
28140 | 28140 | 2020-04-02 | San Juan | Utah | 49037 | 5 | 0 |
30483 | 30483 | 2020-04-03 | San Juan | Utah | 49037 | 5 | 0 |
32881 | 32881 | 2020-04-04 | San Juan | Utah | 49037 | 5 | 0 |
35319 | 35319 | 2020-04-05 | San Juan | Utah | 49037 | 5 | 0 |
37797 | 37797 | 2020-04-06 | San Juan | Utah | 49037 | 5 | 0 |
40326 | 40326 | 2020-04-07 | San Juan | Utah | 49037 | 5 | 0 |
42894 | 42894 | 2020-04-08 | San Juan | Utah | 49037 | 6 | 0 |
45488 | 45488 | 2020-04-09 | San Juan | Utah | 49037 | 6 | 0 |
48112 | 48112 | 2020-04-10 | San Juan | Utah | 49037 | 6 | 0 |
50770 | 50770 | 2020-04-11 | San Juan | Utah | 49037 | 8 | 0 |
53445 | 53445 | 2020-04-12 | San Juan | Utah | 49037 | 8 | 0 |
56134 | 56134 | 2020-04-13 | San Juan | Utah | 49037 | 9 | 0 |
58840 | 58840 | 2020-04-14 | San Juan | Utah | 49037 | 9 | 0 |
61558 | 61558 | 2020-04-15 | San Juan | Utah | 49037 | 9 | 0 |
64290 | 64290 | 2020-04-16 | San Juan | Utah | 49037 | 9 | 0 |
67038 | 67038 | 2020-04-17 | San Juan | Utah | 49037 | 17 | 2 |
69799 | 69799 | 2020-04-18 | San Juan | Utah | 49037 | 18 | 2 |
72569 | 72569 | 2020-04-19 | San Juan | Utah | 49037 | 22 | 2 |
75345 | 75345 | 2020-04-20 | San Juan | Utah | 49037 | 29 | 2 |
78127 | 78127 | 2020-04-21 | San Juan | Utah | 49037 | 34 | 2 |
80919 | 80919 | 2020-04-22 | San Juan | Utah | 49037 | 34 | 2 |
83720 | 83720 | 2020-04-23 | San Juan | Utah | 49037 | 37 | 2 |
86527 | 86527 | 2020-04-24 | San Juan | Utah | 49037 | 37 | 2 |
89342 | 89342 | 2020-04-25 | San Juan | Utah | 49037 | 40 | 2 |
92159 | 92159 | 2020-04-26 | San Juan | Utah | 49037 | 43 | 2 |
94988 | 94988 | 2020-04-27 | San Juan | Utah | 49037 | 45 | 2 |
97830 | 97830 | 2020-04-28 | San Juan | Utah | 49037 | 45 | 2 |
100680 | 100680 | 2020-04-29 | San Juan | Utah | 49037 | 45 | 2 |
103535 | 103535 | 2020-04-30 | San Juan | Utah | 49037 | 46 | 2 |
106399 | 106399 | 2020-05-01 | San Juan | Utah | 49037 | 47 | 2 |
109268 | 109268 | 2020-05-02 | San Juan | Utah | 49037 | 78 | 2 |
112142 | 112142 | 2020-05-03 | San Juan | Utah | 49037 | 100 | 2 |
115025 | 115025 | 2020-05-04 | San Juan | Utah | 49037 | 116 | 2 |
117984 | 117984 | 2020-05-05 | San Juan | Utah | 49037 | 119 | 2 |
120948 | 120948 | 2020-05-06 | San Juan | Utah | 49037 | 126 | 2 |
123929 | 123929 | 2020-05-07 | San Juan | Utah | 49037 | 132 | 2 |
126914 | 126914 | 2020-05-08 | San Juan | Utah | 49037 | 135 | 2 |
129903 | 129903 | 2020-05-09 | San Juan | Utah | 49037 | 145 | 3 |
132893 | 132893 | 2020-05-10 | San Juan | Utah | 49037 | 147 | 3 |
135884 | 135884 | 2020-05-11 | San Juan | Utah | 49037 | 149 | 3 |
138874 | 138874 | 2020-05-12 | San Juan | Utah | 49037 | 152 | 3 |
141870 | 141870 | 2020-05-13 | San Juan | Utah | 49037 | 152 | 3 |
144867 | 144867 | 2020-05-14 | San Juan | Utah | 49037 | 154 | 3 |
147871 | 147871 | 2020-05-15 | San Juan | Utah | 49037 | 159 | 4 |
150879 | 150879 | 2020-05-16 | San Juan | Utah | 49037 | 177 | 4 |
153890 | 153890 | 2020-05-17 | San Juan | Utah | 49037 | 198 | 4 |
156907 | 156907 | 2020-05-18 | San Juan | Utah | 49037 | 227 | 4 |
159931 | 159931 | 2020-05-19 | San Juan | Utah | 49037 | 238 | 4 |
162959 | 162959 | 2020-05-20 | San Juan | Utah | 49037 | 246 | 4 |
165988 | 165988 | 2020-05-21 | San Juan | Utah | 49037 | 251 | 4 |
169024 | 169024 | 2020-05-22 | San Juan | Utah | 49037 | 254 | 4 |
172065 | 172065 | 2020-05-23 | San Juan | Utah | 49037 | 259 | 4 |
175108 | 175108 | 2020-05-24 | San Juan | Utah | 49037 | 264 | 4 |
178153 | 178153 | 2020-05-25 | San Juan | Utah | 49037 | 268 | 4 |
181197 | 181197 | 2020-05-26 | San Juan | Utah | 49037 | 272 | 5 |
184248 | 184248 | 2020-05-27 | San Juan | Utah | 49037 | 272 | 5 |
187305 | 187305 | 2020-05-28 | San Juan | Utah | 49037 | 283 | 5 |
190369 | 190369 | 2020-05-29 | San Juan | Utah | 49037 | 286 | 5 |
193435 | 193435 | 2020-05-30 | San Juan | Utah | 49037 | 289 | 5 |
196505 | 196505 | 2020-05-31 | San Juan | Utah | 49037 | 297 | 5 |
199578 | 199578 | 2020-06-01 | San Juan | Utah | 49037 | 299 | 5 |
202654 | 202654 | 2020-06-02 | San Juan | Utah | 49037 | 308 | 5 |
205733 | 205733 | 2020-06-03 | San Juan | Utah | 49037 | 309 | 5 |
208815 | 208815 | 2020-06-04 | San Juan | Utah | 49037 | 312 | 5 |
211900 | 211900 | 2020-06-05 | San Juan | Utah | 49037 | 314 | 5 |
214987 | 214987 | 2020-06-06 | San Juan | Utah | 49037 | 333 | 5 |
218077 | 218077 | 2020-06-07 | San Juan | Utah | 49037 | 333 | 5 |
221169 | 221169 | 2020-06-08 | San Juan | Utah | 49037 | 333 | 5 |
224265 | 224265 | 2020-06-09 | San Juan | Utah | 49037 | 337 | 5 |
227365 | 227365 | 2020-06-10 | San Juan | Utah | 49037 | 339 | 5 |
230469 | 230469 | 2020-06-11 | San Juan | Utah | 49037 | 343 | 5 |
233574 | 233574 | 2020-06-12 | San Juan | Utah | 49037 | 350 | 5 |
236681 | 236681 | 2020-06-13 | San Juan | Utah | 49037 | 351 | 5 |
239789 | 239789 | 2020-06-14 | San Juan | Utah | 49037 | 357 | 5 |
242900 | 242900 | 2020-06-15 | San Juan | Utah | 49037 | 363 | 6 |
246012 | 246012 | 2020-06-16 | San Juan | Utah | 49037 | 365 | 6 |
249125 | 249125 | 2020-06-17 | San Juan | Utah | 49037 | 367 | 6 |
252240 | 252240 | 2020-06-18 | San Juan | Utah | 49037 | 374 | 7 |
255357 | 255357 | 2020-06-19 | San Juan | Utah | 49037 | 380 | 7 |
258484 | 258484 | 2020-06-20 | San Juan | Utah | 49037 | 382 | 7 |
261611 | 261611 | 2020-06-21 | San Juan | Utah | 49037 | 383 | 7 |
264740 | 264740 | 2020-06-22 | San Juan | Utah | 49037 | 386 | 7 |
267869 | 267869 | 2020-06-23 | San Juan | Utah | 49037 | 388 | 7 |
271003 | 271003 | 2020-06-24 | San Juan | Utah | 49037 | 389 | 7 |
274143 | 274143 | 2020-06-25 | San Juan | Utah | 49037 | 391 | 7 |
277291 | 277291 | 2020-06-26 | San Juan | Utah | 49037 | 395 | 7 |
280439 | 280439 | 2020-06-27 | San Juan | Utah | 49037 | 399 | 8 |
283585 | 283585 | 2020-06-28 | San Juan | Utah | 49037 | 399 | 8 |
286731 | 286731 | 2020-06-29 | San Juan | Utah | 49037 | 400 | 8 |
289881 | 289881 | 2020-06-30 | San Juan | Utah | 49037 | 399 | 9 |
293034 | 293034 | 2020-07-01 | San Juan | Utah | 49037 | 402 | 9 |
296189 | 296189 | 2020-07-02 | San Juan | Utah | 49037 | 404 | 9 |
299351 | 299351 | 2020-07-03 | San Juan | Utah | 49037 | 403 | 9 |
302515 | 302515 | 2020-07-04 | San Juan | Utah | 49037 | 413 | 9 |
305679 | 305679 | 2020-07-05 | San Juan | Utah | 49037 | 414 | 9 |
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);