ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72123 and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117547 | 117547 | 2020-05-05 | Salinas | Puerto Rico | 72123 | 22 | |
120509 | 120509 | 2020-05-06 | Salinas | Puerto Rico | 72123 | 22 | |
123486 | 123486 | 2020-05-07 | Salinas | Puerto Rico | 72123 | 22 | |
126469 | 126469 | 2020-05-08 | Salinas | Puerto Rico | 72123 | 26 | |
129458 | 129458 | 2020-05-09 | Salinas | Puerto Rico | 72123 | 27 | |
132447 | 132447 | 2020-05-10 | Salinas | Puerto Rico | 72123 | 30 | |
135438 | 135438 | 2020-05-11 | Salinas | Puerto Rico | 72123 | 33 | |
138428 | 138428 | 2020-05-12 | Salinas | Puerto Rico | 72123 | 33 | |
141424 | 141424 | 2020-05-13 | Salinas | Puerto Rico | 72123 | 37 | |
144420 | 144420 | 2020-05-14 | Salinas | Puerto Rico | 72123 | 39 | |
147421 | 147421 | 2020-05-15 | Salinas | Puerto Rico | 72123 | 42 | |
150429 | 150429 | 2020-05-16 | Salinas | Puerto Rico | 72123 | 44 | |
153440 | 153440 | 2020-05-17 | Salinas | Puerto Rico | 72123 | 46 | |
156457 | 156457 | 2020-05-18 | Salinas | Puerto Rico | 72123 | 51 | |
159478 | 159478 | 2020-05-19 | Salinas | Puerto Rico | 72123 | 54 | |
162505 | 162505 | 2020-05-20 | Salinas | Puerto Rico | 72123 | 54 | |
165534 | 165534 | 2020-05-21 | Salinas | Puerto Rico | 72123 | 56 | |
168570 | 168570 | 2020-05-22 | Salinas | Puerto Rico | 72123 | 59 | |
171609 | 171609 | 2020-05-23 | Salinas | Puerto Rico | 72123 | 60 | |
174651 | 174651 | 2020-05-24 | Salinas | Puerto Rico | 72123 | 60 | |
177695 | 177695 | 2020-05-25 | Salinas | Puerto Rico | 72123 | 62 | |
180738 | 180738 | 2020-05-26 | Salinas | Puerto Rico | 72123 | 62 | |
186845 | 186845 | 2020-05-28 | Salinas | Puerto Rico | 72123 | 63 | |
183788 | 183788 | 2020-05-27 | Salinas | Puerto Rico | 72123 | 64 | |
189907 | 189907 | 2020-05-29 | Salinas | Puerto Rico | 72123 | 68 | |
192972 | 192972 | 2020-05-30 | Salinas | Puerto Rico | 72123 | 69 | |
196041 | 196041 | 2020-05-31 | Salinas | Puerto Rico | 72123 | 69 | |
199114 | 199114 | 2020-06-01 | Salinas | Puerto Rico | 72123 | 69 | |
202189 | 202189 | 2020-06-02 | Salinas | Puerto Rico | 72123 | 70 | |
205266 | 205266 | 2020-06-03 | Salinas | Puerto Rico | 72123 | 74 | |
208347 | 208347 | 2020-06-04 | Salinas | Puerto Rico | 72123 | 78 | |
211429 | 211429 | 2020-06-05 | Salinas | Puerto Rico | 72123 | 79 | |
214515 | 214515 | 2020-06-06 | Salinas | Puerto Rico | 72123 | 81 | |
217605 | 217605 | 2020-06-07 | Salinas | Puerto Rico | 72123 | 83 | |
220697 | 220697 | 2020-06-08 | Salinas | Puerto Rico | 72123 | 86 | |
223792 | 223792 | 2020-06-09 | Salinas | Puerto Rico | 72123 | 86 | |
226892 | 226892 | 2020-06-10 | Salinas | Puerto Rico | 72123 | 86 | |
229996 | 229996 | 2020-06-11 | Salinas | Puerto Rico | 72123 | 86 | |
233101 | 233101 | 2020-06-12 | Salinas | Puerto Rico | 72123 | 87 | |
236206 | 236206 | 2020-06-13 | Salinas | Puerto Rico | 72123 | 88 | |
239314 | 239314 | 2020-06-14 | Salinas | Puerto Rico | 72123 | 92 | |
242423 | 242423 | 2020-06-15 | Salinas | Puerto Rico | 72123 | 93 | |
248648 | 248648 | 2020-06-17 | Salinas | Puerto Rico | 72123 | 93 | |
245535 | 245535 | 2020-06-16 | Salinas | Puerto Rico | 72123 | 94 | |
251763 | 251763 | 2020-06-18 | Salinas | Puerto Rico | 72123 | 94 | |
254878 | 254878 | 2020-06-19 | Salinas | Puerto Rico | 72123 | 94 | |
258004 | 258004 | 2020-06-20 | Salinas | Puerto Rico | 72123 | 95 | |
261131 | 261131 | 2020-06-21 | Salinas | Puerto Rico | 72123 | 95 | |
264259 | 264259 | 2020-06-22 | Salinas | Puerto Rico | 72123 | 96 | |
267387 | 267387 | 2020-06-23 | Salinas | Puerto Rico | 72123 | 98 | |
270521 | 270521 | 2020-06-24 | Salinas | Puerto Rico | 72123 | 101 | |
273660 | 273660 | 2020-06-25 | Salinas | Puerto Rico | 72123 | 102 | |
276807 | 276807 | 2020-06-26 | Salinas | Puerto Rico | 72123 | 102 | |
279955 | 279955 | 2020-06-27 | Salinas | Puerto Rico | 72123 | 102 | |
283101 | 283101 | 2020-06-28 | Salinas | Puerto Rico | 72123 | 102 | |
286246 | 286246 | 2020-06-29 | Salinas | Puerto Rico | 72123 | 102 | |
289397 | 289397 | 2020-06-30 | Salinas | Puerto Rico | 72123 | 103 | |
292549 | 292549 | 2020-07-01 | Salinas | Puerto Rico | 72123 | 104 | |
295705 | 295705 | 2020-07-02 | Salinas | Puerto Rico | 72123 | 104 | |
298864 | 298864 | 2020-07-03 | Salinas | Puerto Rico | 72123 | 104 | |
302028 | 302028 | 2020-07-04 | Salinas | Puerto Rico | 72123 | 104 | |
305191 | 305191 | 2020-07-05 | Salinas | Puerto Rico | 72123 | 104 | |
308358 | 308358 | 2020-07-06 | Salinas | Puerto Rico | 72123 | 108 | |
311527 | 311527 | 2020-07-07 | Salinas | Puerto Rico | 72123 | 110 | |
314699 | 314699 | 2020-07-08 | Salinas | Puerto Rico | 72123 | 111 | |
317872 | 317872 | 2020-07-09 | Salinas | Puerto Rico | 72123 | 114 | |
321050 | 321050 | 2020-07-10 | Salinas | Puerto Rico | 72123 | 117 | |
324230 | 324230 | 2020-07-11 | Salinas | Puerto Rico | 72123 | 119 | |
327415 | 327415 | 2020-07-12 | Salinas | Puerto Rico | 72123 | 119 | |
330601 | 330601 | 2020-07-13 | Salinas | Puerto Rico | 72123 | 119 | |
333793 | 333793 | 2020-07-14 | Salinas | Puerto Rico | 72123 | 119 | |
336987 | 336987 | 2020-07-15 | Salinas | Puerto Rico | 72123 | 119 | |
340184 | 340184 | 2020-07-16 | Salinas | Puerto Rico | 72123 | 120 | |
343382 | 343382 | 2020-07-17 | Salinas | Puerto Rico | 72123 | 120 | |
346582 | 346582 | 2020-07-18 | Salinas | Puerto Rico | 72123 | 120 | |
349782 | 349782 | 2020-07-19 | Salinas | Puerto Rico | 72123 | 122 | |
352985 | 352985 | 2020-07-20 | Salinas | Puerto Rico | 72123 | 123 | |
356188 | 356188 | 2020-07-21 | Salinas | Puerto Rico | 72123 | 124 | |
359392 | 359392 | 2020-07-22 | Salinas | Puerto Rico | 72123 | 124 | |
362598 | 362598 | 2020-07-23 | Salinas | Puerto Rico | 72123 | 127 | |
365804 | 365804 | 2020-07-24 | Salinas | Puerto Rico | 72123 | 128 | |
369013 | 369013 | 2020-07-25 | Salinas | Puerto Rico | 72123 | 129 | |
372225 | 372225 | 2020-07-26 | Salinas | Puerto Rico | 72123 | 130 | |
375438 | 375438 | 2020-07-27 | Salinas | Puerto Rico | 72123 | 130 | |
378654 | 378654 | 2020-07-28 | Salinas | Puerto Rico | 72123 | 130 | |
381871 | 381871 | 2020-07-29 | Salinas | Puerto Rico | 72123 | 130 | |
385089 | 385089 | 2020-07-30 | Salinas | Puerto Rico | 72123 | 131 | |
391523 | 391523 | 2020-08-01 | Salinas | Puerto Rico | 72123 | 131 | |
394739 | 394739 | 2020-08-02 | Salinas | Puerto Rico | 72123 | 131 | |
388306 | 388306 | 2020-07-31 | Salinas | Puerto Rico | 72123 | 132 | |
397956 | 397956 | 2020-08-03 | Salinas | Puerto Rico | 72123 | 134 | |
401171 | 401171 | 2020-08-04 | Salinas | Puerto Rico | 72123 | 139 | |
404389 | 404389 | 2020-08-05 | Salinas | Puerto Rico | 72123 | 140 | |
407608 | 407608 | 2020-08-06 | Salinas | Puerto Rico | 72123 | 145 | |
410828 | 410828 | 2020-08-07 | Salinas | Puerto Rico | 72123 | 155 | |
414048 | 414048 | 2020-08-08 | Salinas | Puerto Rico | 72123 | 164 | |
417269 | 417269 | 2020-08-09 | Salinas | Puerto Rico | 72123 | 171 | |
420489 | 420489 | 2020-08-10 | Salinas | Puerto Rico | 72123 | 187 | |
423712 | 423712 | 2020-08-11 | Salinas | Puerto Rico | 72123 | 193 | |
426935 | 426935 | 2020-08-12 | Salinas | Puerto Rico | 72123 | 196 |
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);