ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72027 and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117500 | 117500 | 2020-05-05 | Camuy | Puerto Rico | 72027 | 7 | |
120462 | 120462 | 2020-05-06 | Camuy | Puerto Rico | 72027 | 7 | |
123439 | 123439 | 2020-05-07 | Camuy | Puerto Rico | 72027 | 7 | |
126422 | 126422 | 2020-05-08 | Camuy | Puerto Rico | 72027 | 8 | |
129411 | 129411 | 2020-05-09 | Camuy | Puerto Rico | 72027 | 8 | |
132400 | 132400 | 2020-05-10 | Camuy | Puerto Rico | 72027 | 8 | |
135391 | 135391 | 2020-05-11 | Camuy | Puerto Rico | 72027 | 8 | |
138381 | 138381 | 2020-05-12 | Camuy | Puerto Rico | 72027 | 8 | |
141377 | 141377 | 2020-05-13 | Camuy | Puerto Rico | 72027 | 8 | |
144373 | 144373 | 2020-05-14 | Camuy | Puerto Rico | 72027 | 8 | |
147374 | 147374 | 2020-05-15 | Camuy | Puerto Rico | 72027 | 8 | |
150381 | 150381 | 2020-05-16 | Camuy | Puerto Rico | 72027 | 8 | |
153392 | 153392 | 2020-05-17 | Camuy | Puerto Rico | 72027 | 8 | |
156409 | 156409 | 2020-05-18 | Camuy | Puerto Rico | 72027 | 8 | |
159430 | 159430 | 2020-05-19 | Camuy | Puerto Rico | 72027 | 8 | |
162457 | 162457 | 2020-05-20 | Camuy | Puerto Rico | 72027 | 8 | |
165486 | 165486 | 2020-05-21 | Camuy | Puerto Rico | 72027 | 8 | |
168522 | 168522 | 2020-05-22 | Camuy | Puerto Rico | 72027 | 9 | |
171561 | 171561 | 2020-05-23 | Camuy | Puerto Rico | 72027 | 9 | |
174603 | 174603 | 2020-05-24 | Camuy | Puerto Rico | 72027 | 9 | |
177647 | 177647 | 2020-05-25 | Camuy | Puerto Rico | 72027 | 9 | |
180690 | 180690 | 2020-05-26 | Camuy | Puerto Rico | 72027 | 9 | |
183740 | 183740 | 2020-05-27 | Camuy | Puerto Rico | 72027 | 9 | |
186797 | 186797 | 2020-05-28 | Camuy | Puerto Rico | 72027 | 9 | |
189858 | 189858 | 2020-05-29 | Camuy | Puerto Rico | 72027 | 9 | |
192923 | 192923 | 2020-05-30 | Camuy | Puerto Rico | 72027 | 9 | |
195992 | 195992 | 2020-05-31 | Camuy | Puerto Rico | 72027 | 9 | |
199065 | 199065 | 2020-06-01 | Camuy | Puerto Rico | 72027 | 9 | |
202140 | 202140 | 2020-06-02 | Camuy | Puerto Rico | 72027 | 10 | |
205217 | 205217 | 2020-06-03 | Camuy | Puerto Rico | 72027 | 12 | |
208298 | 208298 | 2020-06-04 | Camuy | Puerto Rico | 72027 | 13 | |
211380 | 211380 | 2020-06-05 | Camuy | Puerto Rico | 72027 | 13 | |
214466 | 214466 | 2020-06-06 | Camuy | Puerto Rico | 72027 | 13 | |
217556 | 217556 | 2020-06-07 | Camuy | Puerto Rico | 72027 | 13 | |
220648 | 220648 | 2020-06-08 | Camuy | Puerto Rico | 72027 | 13 | |
223743 | 223743 | 2020-06-09 | Camuy | Puerto Rico | 72027 | 13 | |
226843 | 226843 | 2020-06-10 | Camuy | Puerto Rico | 72027 | 24 | |
229947 | 229947 | 2020-06-11 | Camuy | Puerto Rico | 72027 | 23 | |
233052 | 233052 | 2020-06-12 | Camuy | Puerto Rico | 72027 | 24 | |
236157 | 236157 | 2020-06-13 | Camuy | Puerto Rico | 72027 | 35 | |
239265 | 239265 | 2020-06-14 | Camuy | Puerto Rico | 72027 | 35 | |
242374 | 242374 | 2020-06-15 | Camuy | Puerto Rico | 72027 | 35 | |
245486 | 245486 | 2020-06-16 | Camuy | Puerto Rico | 72027 | 35 | |
248599 | 248599 | 2020-06-17 | Camuy | Puerto Rico | 72027 | 35 | |
251714 | 251714 | 2020-06-18 | Camuy | Puerto Rico | 72027 | 34 | |
254829 | 254829 | 2020-06-19 | Camuy | Puerto Rico | 72027 | 34 | |
257955 | 257955 | 2020-06-20 | Camuy | Puerto Rico | 72027 | 38 | |
261082 | 261082 | 2020-06-21 | Camuy | Puerto Rico | 72027 | 38 | |
264210 | 264210 | 2020-06-22 | Camuy | Puerto Rico | 72027 | 38 | |
267338 | 267338 | 2020-06-23 | Camuy | Puerto Rico | 72027 | 35 | |
270472 | 270472 | 2020-06-24 | Camuy | Puerto Rico | 72027 | 35 | |
273611 | 273611 | 2020-06-25 | Camuy | Puerto Rico | 72027 | 35 | |
276758 | 276758 | 2020-06-26 | Camuy | Puerto Rico | 72027 | 35 | |
279906 | 279906 | 2020-06-27 | Camuy | Puerto Rico | 72027 | 36 | |
283052 | 283052 | 2020-06-28 | Camuy | Puerto Rico | 72027 | 37 | |
286197 | 286197 | 2020-06-29 | Camuy | Puerto Rico | 72027 | 37 | |
289348 | 289348 | 2020-06-30 | Camuy | Puerto Rico | 72027 | 37 | |
292500 | 292500 | 2020-07-01 | Camuy | Puerto Rico | 72027 | 39 | |
295656 | 295656 | 2020-07-02 | Camuy | Puerto Rico | 72027 | 39 | |
298815 | 298815 | 2020-07-03 | Camuy | Puerto Rico | 72027 | 39 | |
301979 | 301979 | 2020-07-04 | Camuy | Puerto Rico | 72027 | 40 | |
305142 | 305142 | 2020-07-05 | Camuy | Puerto Rico | 72027 | 40 | |
308309 | 308309 | 2020-07-06 | Camuy | Puerto Rico | 72027 | 45 | |
311478 | 311478 | 2020-07-07 | Camuy | Puerto Rico | 72027 | 45 | |
314650 | 314650 | 2020-07-08 | Camuy | Puerto Rico | 72027 | 45 | |
317823 | 317823 | 2020-07-09 | Camuy | Puerto Rico | 72027 | 45 | |
321001 | 321001 | 2020-07-10 | Camuy | Puerto Rico | 72027 | 51 | |
324181 | 324181 | 2020-07-11 | Camuy | Puerto Rico | 72027 | 53 | |
327366 | 327366 | 2020-07-12 | Camuy | Puerto Rico | 72027 | 55 | |
330552 | 330552 | 2020-07-13 | Camuy | Puerto Rico | 72027 | 55 | |
333744 | 333744 | 2020-07-14 | Camuy | Puerto Rico | 72027 | 56 | |
336938 | 336938 | 2020-07-15 | Camuy | Puerto Rico | 72027 | 59 | |
340135 | 340135 | 2020-07-16 | Camuy | Puerto Rico | 72027 | 60 | |
343333 | 343333 | 2020-07-17 | Camuy | Puerto Rico | 72027 | 64 | |
346533 | 346533 | 2020-07-18 | Camuy | Puerto Rico | 72027 | 65 | |
349733 | 349733 | 2020-07-19 | Camuy | Puerto Rico | 72027 | 68 | |
352936 | 352936 | 2020-07-20 | Camuy | Puerto Rico | 72027 | 69 | |
356139 | 356139 | 2020-07-21 | Camuy | Puerto Rico | 72027 | 69 | |
359343 | 359343 | 2020-07-22 | Camuy | Puerto Rico | 72027 | 70 | |
362549 | 362549 | 2020-07-23 | Camuy | Puerto Rico | 72027 | 70 | |
365755 | 365755 | 2020-07-24 | Camuy | Puerto Rico | 72027 | 75 | |
368964 | 368964 | 2020-07-25 | Camuy | Puerto Rico | 72027 | 78 | |
372176 | 372176 | 2020-07-26 | Camuy | Puerto Rico | 72027 | 79 | |
375389 | 375389 | 2020-07-27 | Camuy | Puerto Rico | 72027 | 87 | |
378605 | 378605 | 2020-07-28 | Camuy | Puerto Rico | 72027 | 88 | |
381822 | 381822 | 2020-07-29 | Camuy | Puerto Rico | 72027 | 88 | |
385040 | 385040 | 2020-07-30 | Camuy | Puerto Rico | 72027 | 96 | |
388257 | 388257 | 2020-07-31 | Camuy | Puerto Rico | 72027 | 96 | |
391474 | 391474 | 2020-08-01 | Camuy | Puerto Rico | 72027 | 103 | |
394690 | 394690 | 2020-08-02 | Camuy | Puerto Rico | 72027 | 107 | |
397907 | 397907 | 2020-08-03 | Camuy | Puerto Rico | 72027 | 113 | |
401122 | 401122 | 2020-08-04 | Camuy | Puerto Rico | 72027 | 115 | |
404340 | 404340 | 2020-08-05 | Camuy | Puerto Rico | 72027 | 118 | |
407559 | 407559 | 2020-08-06 | Camuy | Puerto Rico | 72027 | 129 | |
410779 | 410779 | 2020-08-07 | Camuy | Puerto Rico | 72027 | 132 | |
413999 | 413999 | 2020-08-08 | Camuy | Puerto Rico | 72027 | 138 | |
417220 | 417220 | 2020-08-09 | Camuy | Puerto Rico | 72027 | 139 | |
420440 | 420440 | 2020-08-10 | Camuy | Puerto Rico | 72027 | 143 | |
423663 | 423663 | 2020-08-11 | Camuy | Puerto Rico | 72027 | 144 | |
426886 | 426886 | 2020-08-12 | Camuy | Puerto Rico | 72027 | 145 |
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);