ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72077 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 |
---|---|---|---|---|---|---|---|
117525 | 117525 | 2020-05-05 | Juncos | Puerto Rico | 72077 | 13 | |
120487 | 120487 | 2020-05-06 | Juncos | Puerto Rico | 72077 | 13 | |
123464 | 123464 | 2020-05-07 | Juncos | Puerto Rico | 72077 | 13 | |
126447 | 126447 | 2020-05-08 | Juncos | Puerto Rico | 72077 | 13 | |
129436 | 129436 | 2020-05-09 | Juncos | Puerto Rico | 72077 | 13 | |
132425 | 132425 | 2020-05-10 | Juncos | Puerto Rico | 72077 | 13 | |
135416 | 135416 | 2020-05-11 | Juncos | Puerto Rico | 72077 | 13 | |
150406 | 150406 | 2020-05-16 | Juncos | Puerto Rico | 72077 | 13 | |
153417 | 153417 | 2020-05-17 | Juncos | Puerto Rico | 72077 | 13 | |
156434 | 156434 | 2020-05-18 | Juncos | Puerto Rico | 72077 | 13 | |
138406 | 138406 | 2020-05-12 | Juncos | Puerto Rico | 72077 | 14 | |
141402 | 141402 | 2020-05-13 | Juncos | Puerto Rico | 72077 | 14 | |
144398 | 144398 | 2020-05-14 | Juncos | Puerto Rico | 72077 | 14 | |
147399 | 147399 | 2020-05-15 | Juncos | Puerto Rico | 72077 | 14 | |
159455 | 159455 | 2020-05-19 | Juncos | Puerto Rico | 72077 | 14 | |
162482 | 162482 | 2020-05-20 | Juncos | Puerto Rico | 72077 | 14 | |
165511 | 165511 | 2020-05-21 | Juncos | Puerto Rico | 72077 | 16 | |
168547 | 168547 | 2020-05-22 | Juncos | Puerto Rico | 72077 | 17 | |
171586 | 171586 | 2020-05-23 | Juncos | Puerto Rico | 72077 | 18 | |
174628 | 174628 | 2020-05-24 | Juncos | Puerto Rico | 72077 | 18 | |
177672 | 177672 | 2020-05-25 | Juncos | Puerto Rico | 72077 | 18 | |
180715 | 180715 | 2020-05-26 | Juncos | Puerto Rico | 72077 | 18 | |
183765 | 183765 | 2020-05-27 | Juncos | Puerto Rico | 72077 | 18 | |
186822 | 186822 | 2020-05-28 | Juncos | Puerto Rico | 72077 | 18 | |
189884 | 189884 | 2020-05-29 | Juncos | Puerto Rico | 72077 | 19 | |
192949 | 192949 | 2020-05-30 | Juncos | Puerto Rico | 72077 | 19 | |
196018 | 196018 | 2020-05-31 | Juncos | Puerto Rico | 72077 | 21 | |
199091 | 199091 | 2020-06-01 | Juncos | Puerto Rico | 72077 | 21 | |
202166 | 202166 | 2020-06-02 | Juncos | Puerto Rico | 72077 | 21 | |
205243 | 205243 | 2020-06-03 | Juncos | Puerto Rico | 72077 | 22 | |
208324 | 208324 | 2020-06-04 | Juncos | Puerto Rico | 72077 | 28 | |
211406 | 211406 | 2020-06-05 | Juncos | Puerto Rico | 72077 | 29 | |
214492 | 214492 | 2020-06-06 | Juncos | Puerto Rico | 72077 | 31 | |
217582 | 217582 | 2020-06-07 | Juncos | Puerto Rico | 72077 | 32 | |
220674 | 220674 | 2020-06-08 | Juncos | Puerto Rico | 72077 | 34 | |
223769 | 223769 | 2020-06-09 | Juncos | Puerto Rico | 72077 | 34 | |
226869 | 226869 | 2020-06-10 | Juncos | Puerto Rico | 72077 | 35 | |
229973 | 229973 | 2020-06-11 | Juncos | Puerto Rico | 72077 | 36 | |
236183 | 236183 | 2020-06-13 | Juncos | Puerto Rico | 72077 | 37 | |
233078 | 233078 | 2020-06-12 | Juncos | Puerto Rico | 72077 | 38 | |
239291 | 239291 | 2020-06-14 | Juncos | Puerto Rico | 72077 | 38 | |
242400 | 242400 | 2020-06-15 | Juncos | Puerto Rico | 72077 | 38 | |
251740 | 251740 | 2020-06-18 | Juncos | Puerto Rico | 72077 | 38 | |
254855 | 254855 | 2020-06-19 | Juncos | Puerto Rico | 72077 | 38 | |
245512 | 245512 | 2020-06-16 | Juncos | Puerto Rico | 72077 | 39 | |
248625 | 248625 | 2020-06-17 | Juncos | Puerto Rico | 72077 | 39 | |
257981 | 257981 | 2020-06-20 | Juncos | Puerto Rico | 72077 | 41 | |
261108 | 261108 | 2020-06-21 | Juncos | Puerto Rico | 72077 | 41 | |
264236 | 264236 | 2020-06-22 | Juncos | Puerto Rico | 72077 | 41 | |
267364 | 267364 | 2020-06-23 | Juncos | Puerto Rico | 72077 | 45 | |
270498 | 270498 | 2020-06-24 | Juncos | Puerto Rico | 72077 | 46 | |
273637 | 273637 | 2020-06-25 | Juncos | Puerto Rico | 72077 | 47 | |
276784 | 276784 | 2020-06-26 | Juncos | Puerto Rico | 72077 | 48 | |
279932 | 279932 | 2020-06-27 | Juncos | Puerto Rico | 72077 | 50 | |
283078 | 283078 | 2020-06-28 | Juncos | Puerto Rico | 72077 | 50 | |
286223 | 286223 | 2020-06-29 | Juncos | Puerto Rico | 72077 | 50 | |
289374 | 289374 | 2020-06-30 | Juncos | Puerto Rico | 72077 | 50 | |
292526 | 292526 | 2020-07-01 | Juncos | Puerto Rico | 72077 | 50 | |
295682 | 295682 | 2020-07-02 | Juncos | Puerto Rico | 72077 | 50 | |
298841 | 298841 | 2020-07-03 | Juncos | Puerto Rico | 72077 | 50 | |
302005 | 302005 | 2020-07-04 | Juncos | Puerto Rico | 72077 | 50 | |
305168 | 305168 | 2020-07-05 | Juncos | Puerto Rico | 72077 | 50 | |
308335 | 308335 | 2020-07-06 | Juncos | Puerto Rico | 72077 | 56 | |
311504 | 311504 | 2020-07-07 | Juncos | Puerto Rico | 72077 | 57 | |
314676 | 314676 | 2020-07-08 | Juncos | Puerto Rico | 72077 | 57 | |
317849 | 317849 | 2020-07-09 | Juncos | Puerto Rico | 72077 | 57 | |
321027 | 321027 | 2020-07-10 | Juncos | Puerto Rico | 72077 | 58 | |
324207 | 324207 | 2020-07-11 | Juncos | Puerto Rico | 72077 | 62 | |
327392 | 327392 | 2020-07-12 | Juncos | Puerto Rico | 72077 | 62 | |
330578 | 330578 | 2020-07-13 | Juncos | Puerto Rico | 72077 | 62 | |
333770 | 333770 | 2020-07-14 | Juncos | Puerto Rico | 72077 | 62 | |
336964 | 336964 | 2020-07-15 | Juncos | Puerto Rico | 72077 | 64 | |
340161 | 340161 | 2020-07-16 | Juncos | Puerto Rico | 72077 | 64 | |
343359 | 343359 | 2020-07-17 | Juncos | Puerto Rico | 72077 | 64 | |
346559 | 346559 | 2020-07-18 | Juncos | Puerto Rico | 72077 | 66 | |
349759 | 349759 | 2020-07-19 | Juncos | Puerto Rico | 72077 | 69 | |
352962 | 352962 | 2020-07-20 | Juncos | Puerto Rico | 72077 | 71 | |
356165 | 356165 | 2020-07-21 | Juncos | Puerto Rico | 72077 | 74 | |
359369 | 359369 | 2020-07-22 | Juncos | Puerto Rico | 72077 | 75 | |
362575 | 362575 | 2020-07-23 | Juncos | Puerto Rico | 72077 | 75 | |
365781 | 365781 | 2020-07-24 | Juncos | Puerto Rico | 72077 | 82 | |
368990 | 368990 | 2020-07-25 | Juncos | Puerto Rico | 72077 | 83 | |
372202 | 372202 | 2020-07-26 | Juncos | Puerto Rico | 72077 | 86 | |
375415 | 375415 | 2020-07-27 | Juncos | Puerto Rico | 72077 | 89 | |
378631 | 378631 | 2020-07-28 | Juncos | Puerto Rico | 72077 | 91 | |
381848 | 381848 | 2020-07-29 | Juncos | Puerto Rico | 72077 | 92 | |
385066 | 385066 | 2020-07-30 | Juncos | Puerto Rico | 72077 | 94 | |
388283 | 388283 | 2020-07-31 | Juncos | Puerto Rico | 72077 | 97 | |
391500 | 391500 | 2020-08-01 | Juncos | Puerto Rico | 72077 | 102 | |
394716 | 394716 | 2020-08-02 | Juncos | Puerto Rico | 72077 | 103 | |
397933 | 397933 | 2020-08-03 | Juncos | Puerto Rico | 72077 | 106 | |
401148 | 401148 | 2020-08-04 | Juncos | Puerto Rico | 72077 | 107 | |
404366 | 404366 | 2020-08-05 | Juncos | Puerto Rico | 72077 | 111 | |
407585 | 407585 | 2020-08-06 | Juncos | Puerto Rico | 72077 | 113 | |
410805 | 410805 | 2020-08-07 | Juncos | Puerto Rico | 72077 | 121 | |
414025 | 414025 | 2020-08-08 | Juncos | Puerto Rico | 72077 | 128 | |
417246 | 417246 | 2020-08-09 | Juncos | Puerto Rico | 72077 | 131 | |
420466 | 420466 | 2020-08-10 | Juncos | Puerto Rico | 72077 | 141 | |
423689 | 423689 | 2020-08-11 | Juncos | Puerto Rico | 72077 | 143 | |
426912 | 426912 | 2020-08-12 | Juncos | Puerto Rico | 72077 | 149 |
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);