ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72017 and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117495 | 117495 | 2020-05-05 | Barceloneta | Puerto Rico | 72017 | 3 | |
120457 | 120457 | 2020-05-06 | Barceloneta | Puerto Rico | 72017 | 4 | |
123434 | 123434 | 2020-05-07 | Barceloneta | Puerto Rico | 72017 | 5 | |
126417 | 126417 | 2020-05-08 | Barceloneta | Puerto Rico | 72017 | 5 | |
129406 | 129406 | 2020-05-09 | Barceloneta | Puerto Rico | 72017 | 5 | |
132395 | 132395 | 2020-05-10 | Barceloneta | Puerto Rico | 72017 | 5 | |
135386 | 135386 | 2020-05-11 | Barceloneta | Puerto Rico | 72017 | 5 | |
138376 | 138376 | 2020-05-12 | Barceloneta | Puerto Rico | 72017 | 5 | |
141372 | 141372 | 2020-05-13 | Barceloneta | Puerto Rico | 72017 | 5 | |
144368 | 144368 | 2020-05-14 | Barceloneta | Puerto Rico | 72017 | 5 | |
147369 | 147369 | 2020-05-15 | Barceloneta | Puerto Rico | 72017 | 7 | |
150376 | 150376 | 2020-05-16 | Barceloneta | Puerto Rico | 72017 | 7 | |
153387 | 153387 | 2020-05-17 | Barceloneta | Puerto Rico | 72017 | 8 | |
156404 | 156404 | 2020-05-18 | Barceloneta | Puerto Rico | 72017 | 8 | |
159425 | 159425 | 2020-05-19 | Barceloneta | Puerto Rico | 72017 | 8 | |
162452 | 162452 | 2020-05-20 | Barceloneta | Puerto Rico | 72017 | 8 | |
165481 | 165481 | 2020-05-21 | Barceloneta | Puerto Rico | 72017 | 8 | |
168517 | 168517 | 2020-05-22 | Barceloneta | Puerto Rico | 72017 | 8 | |
171556 | 171556 | 2020-05-23 | Barceloneta | Puerto Rico | 72017 | 8 | |
174598 | 174598 | 2020-05-24 | Barceloneta | Puerto Rico | 72017 | 8 | |
177642 | 177642 | 2020-05-25 | Barceloneta | Puerto Rico | 72017 | 9 | |
180685 | 180685 | 2020-05-26 | Barceloneta | Puerto Rico | 72017 | 9 | |
183735 | 183735 | 2020-05-27 | Barceloneta | Puerto Rico | 72017 | 10 | |
186792 | 186792 | 2020-05-28 | Barceloneta | Puerto Rico | 72017 | 11 | |
189853 | 189853 | 2020-05-29 | Barceloneta | Puerto Rico | 72017 | 11 | |
192918 | 192918 | 2020-05-30 | Barceloneta | Puerto Rico | 72017 | 11 | |
195987 | 195987 | 2020-05-31 | Barceloneta | Puerto Rico | 72017 | 11 | |
199060 | 199060 | 2020-06-01 | Barceloneta | Puerto Rico | 72017 | 11 | |
202135 | 202135 | 2020-06-02 | Barceloneta | Puerto Rico | 72017 | 11 | |
205212 | 205212 | 2020-06-03 | Barceloneta | Puerto Rico | 72017 | 12 | |
208293 | 208293 | 2020-06-04 | Barceloneta | Puerto Rico | 72017 | 16 | |
211375 | 211375 | 2020-06-05 | Barceloneta | Puerto Rico | 72017 | 16 | |
214461 | 214461 | 2020-06-06 | Barceloneta | Puerto Rico | 72017 | 18 | |
217551 | 217551 | 2020-06-07 | Barceloneta | Puerto Rico | 72017 | 18 | |
220643 | 220643 | 2020-06-08 | Barceloneta | Puerto Rico | 72017 | 18 | |
223738 | 223738 | 2020-06-09 | Barceloneta | Puerto Rico | 72017 | 18 | |
226838 | 226838 | 2020-06-10 | Barceloneta | Puerto Rico | 72017 | 21 | |
229942 | 229942 | 2020-06-11 | Barceloneta | Puerto Rico | 72017 | 21 | |
233047 | 233047 | 2020-06-12 | Barceloneta | Puerto Rico | 72017 | 21 | |
236152 | 236152 | 2020-06-13 | Barceloneta | Puerto Rico | 72017 | 21 | |
239260 | 239260 | 2020-06-14 | Barceloneta | Puerto Rico | 72017 | 21 | |
242369 | 242369 | 2020-06-15 | Barceloneta | Puerto Rico | 72017 | 21 | |
245481 | 245481 | 2020-06-16 | Barceloneta | Puerto Rico | 72017 | 22 | |
248594 | 248594 | 2020-06-17 | Barceloneta | Puerto Rico | 72017 | 22 | |
251709 | 251709 | 2020-06-18 | Barceloneta | Puerto Rico | 72017 | 22 | |
254824 | 254824 | 2020-06-19 | Barceloneta | Puerto Rico | 72017 | 24 | |
257950 | 257950 | 2020-06-20 | Barceloneta | Puerto Rico | 72017 | 24 | |
261077 | 261077 | 2020-06-21 | Barceloneta | Puerto Rico | 72017 | 24 | |
264205 | 264205 | 2020-06-22 | Barceloneta | Puerto Rico | 72017 | 24 | |
267333 | 267333 | 2020-06-23 | Barceloneta | Puerto Rico | 72017 | 24 | |
270467 | 270467 | 2020-06-24 | Barceloneta | Puerto Rico | 72017 | 26 | |
273606 | 273606 | 2020-06-25 | Barceloneta | Puerto Rico | 72017 | 26 | |
276753 | 276753 | 2020-06-26 | Barceloneta | Puerto Rico | 72017 | 26 | |
279901 | 279901 | 2020-06-27 | Barceloneta | Puerto Rico | 72017 | 26 | |
283047 | 283047 | 2020-06-28 | Barceloneta | Puerto Rico | 72017 | 26 | |
286192 | 286192 | 2020-06-29 | Barceloneta | Puerto Rico | 72017 | 26 | |
289343 | 289343 | 2020-06-30 | Barceloneta | Puerto Rico | 72017 | 27 | |
292495 | 292495 | 2020-07-01 | Barceloneta | Puerto Rico | 72017 | 27 | |
295651 | 295651 | 2020-07-02 | Barceloneta | Puerto Rico | 72017 | 27 | |
298810 | 298810 | 2020-07-03 | Barceloneta | Puerto Rico | 72017 | 27 | |
301974 | 301974 | 2020-07-04 | Barceloneta | Puerto Rico | 72017 | 27 | |
305137 | 305137 | 2020-07-05 | Barceloneta | Puerto Rico | 72017 | 27 | |
308304 | 308304 | 2020-07-06 | Barceloneta | Puerto Rico | 72017 | 28 | |
311473 | 311473 | 2020-07-07 | Barceloneta | Puerto Rico | 72017 | 28 | |
314645 | 314645 | 2020-07-08 | Barceloneta | Puerto Rico | 72017 | 28 | |
317818 | 317818 | 2020-07-09 | Barceloneta | Puerto Rico | 72017 | 28 | |
320996 | 320996 | 2020-07-10 | Barceloneta | Puerto Rico | 72017 | 30 | |
324176 | 324176 | 2020-07-11 | Barceloneta | Puerto Rico | 72017 | 30 | |
327361 | 327361 | 2020-07-12 | Barceloneta | Puerto Rico | 72017 | 31 | |
330547 | 330547 | 2020-07-13 | Barceloneta | Puerto Rico | 72017 | 31 | |
333739 | 333739 | 2020-07-14 | Barceloneta | Puerto Rico | 72017 | 31 | |
336933 | 336933 | 2020-07-15 | Barceloneta | Puerto Rico | 72017 | 32 | |
340130 | 340130 | 2020-07-16 | Barceloneta | Puerto Rico | 72017 | 32 | |
343328 | 343328 | 2020-07-17 | Barceloneta | Puerto Rico | 72017 | 32 | |
346528 | 346528 | 2020-07-18 | Barceloneta | Puerto Rico | 72017 | 34 | |
349728 | 349728 | 2020-07-19 | Barceloneta | Puerto Rico | 72017 | 36 | |
352931 | 352931 | 2020-07-20 | Barceloneta | Puerto Rico | 72017 | 38 | |
356134 | 356134 | 2020-07-21 | Barceloneta | Puerto Rico | 72017 | 40 | |
359338 | 359338 | 2020-07-22 | Barceloneta | Puerto Rico | 72017 | 40 | |
362544 | 362544 | 2020-07-23 | Barceloneta | Puerto Rico | 72017 | 43 | |
365750 | 365750 | 2020-07-24 | Barceloneta | Puerto Rico | 72017 | 46 | |
368959 | 368959 | 2020-07-25 | Barceloneta | Puerto Rico | 72017 | 51 | |
372171 | 372171 | 2020-07-26 | Barceloneta | Puerto Rico | 72017 | 56 | |
375384 | 375384 | 2020-07-27 | Barceloneta | Puerto Rico | 72017 | 57 | |
378600 | 378600 | 2020-07-28 | Barceloneta | Puerto Rico | 72017 | 62 | |
381817 | 381817 | 2020-07-29 | Barceloneta | Puerto Rico | 72017 | 63 | |
385035 | 385035 | 2020-07-30 | Barceloneta | Puerto Rico | 72017 | 65 | |
388252 | 388252 | 2020-07-31 | Barceloneta | Puerto Rico | 72017 | 67 | |
391469 | 391469 | 2020-08-01 | Barceloneta | Puerto Rico | 72017 | 69 | |
394685 | 394685 | 2020-08-02 | Barceloneta | Puerto Rico | 72017 | 72 | |
397902 | 397902 | 2020-08-03 | Barceloneta | Puerto Rico | 72017 | 73 | |
401117 | 401117 | 2020-08-04 | Barceloneta | Puerto Rico | 72017 | 73 | |
404335 | 404335 | 2020-08-05 | Barceloneta | Puerto Rico | 72017 | 78 | |
407554 | 407554 | 2020-08-06 | Barceloneta | Puerto Rico | 72017 | 78 | |
410774 | 410774 | 2020-08-07 | Barceloneta | Puerto Rico | 72017 | 81 | |
413994 | 413994 | 2020-08-08 | Barceloneta | Puerto Rico | 72017 | 88 | |
417215 | 417215 | 2020-08-09 | Barceloneta | Puerto Rico | 72017 | 91 | |
420435 | 420435 | 2020-08-10 | Barceloneta | Puerto Rico | 72017 | 95 | |
423658 | 423658 | 2020-08-11 | Barceloneta | Puerto Rico | 72017 | 95 | |
426881 | 426881 | 2020-08-12 | Barceloneta | Puerto Rico | 72017 | 96 |
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);