ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Comerio" and state = "Puerto Rico" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117509 | 117509 | 2020-05-05 | Comerio | Puerto Rico | 72045 | 9 | |
120471 | 120471 | 2020-05-06 | Comerio | Puerto Rico | 72045 | 9 | |
123448 | 123448 | 2020-05-07 | Comerio | Puerto Rico | 72045 | 9 | |
126431 | 126431 | 2020-05-08 | Comerio | Puerto Rico | 72045 | 9 | |
129420 | 129420 | 2020-05-09 | Comerio | Puerto Rico | 72045 | 9 | |
132409 | 132409 | 2020-05-10 | Comerio | Puerto Rico | 72045 | 9 | |
135400 | 135400 | 2020-05-11 | Comerio | Puerto Rico | 72045 | 9 | |
138390 | 138390 | 2020-05-12 | Comerio | Puerto Rico | 72045 | 9 | |
141386 | 141386 | 2020-05-13 | Comerio | Puerto Rico | 72045 | 9 | |
144382 | 144382 | 2020-05-14 | Comerio | Puerto Rico | 72045 | 11 | |
147383 | 147383 | 2020-05-15 | Comerio | Puerto Rico | 72045 | 13 | |
150390 | 150390 | 2020-05-16 | Comerio | Puerto Rico | 72045 | 14 | |
153401 | 153401 | 2020-05-17 | Comerio | Puerto Rico | 72045 | 14 | |
156418 | 156418 | 2020-05-18 | Comerio | Puerto Rico | 72045 | 14 | |
159439 | 159439 | 2020-05-19 | Comerio | Puerto Rico | 72045 | 15 | |
162466 | 162466 | 2020-05-20 | Comerio | Puerto Rico | 72045 | 15 | |
165495 | 165495 | 2020-05-21 | Comerio | Puerto Rico | 72045 | 15 | |
168531 | 168531 | 2020-05-22 | Comerio | Puerto Rico | 72045 | 17 | |
171570 | 171570 | 2020-05-23 | Comerio | Puerto Rico | 72045 | 18 | |
174612 | 174612 | 2020-05-24 | Comerio | Puerto Rico | 72045 | 19 | |
177656 | 177656 | 2020-05-25 | Comerio | Puerto Rico | 72045 | 19 | |
180699 | 180699 | 2020-05-26 | Comerio | Puerto Rico | 72045 | 23 | |
183749 | 183749 | 2020-05-27 | Comerio | Puerto Rico | 72045 | 24 | |
186806 | 186806 | 2020-05-28 | Comerio | Puerto Rico | 72045 | 24 | |
189867 | 189867 | 2020-05-29 | Comerio | Puerto Rico | 72045 | 24 | |
192932 | 192932 | 2020-05-30 | Comerio | Puerto Rico | 72045 | 24 | |
196001 | 196001 | 2020-05-31 | Comerio | Puerto Rico | 72045 | 24 | |
199074 | 199074 | 2020-06-01 | Comerio | Puerto Rico | 72045 | 24 | |
202149 | 202149 | 2020-06-02 | Comerio | Puerto Rico | 72045 | 24 | |
205226 | 205226 | 2020-06-03 | Comerio | Puerto Rico | 72045 | 26 | |
208307 | 208307 | 2020-06-04 | Comerio | Puerto Rico | 72045 | 27 | |
211389 | 211389 | 2020-06-05 | Comerio | Puerto Rico | 72045 | 28 | |
214475 | 214475 | 2020-06-06 | Comerio | Puerto Rico | 72045 | 31 | |
217565 | 217565 | 2020-06-07 | Comerio | Puerto Rico | 72045 | 31 | |
220657 | 220657 | 2020-06-08 | Comerio | Puerto Rico | 72045 | 31 | |
223752 | 223752 | 2020-06-09 | Comerio | Puerto Rico | 72045 | 31 | |
226852 | 226852 | 2020-06-10 | Comerio | Puerto Rico | 72045 | 32 | |
229956 | 229956 | 2020-06-11 | Comerio | Puerto Rico | 72045 | 32 | |
233061 | 233061 | 2020-06-12 | Comerio | Puerto Rico | 72045 | 32 | |
236166 | 236166 | 2020-06-13 | Comerio | Puerto Rico | 72045 | 32 | |
239274 | 239274 | 2020-06-14 | Comerio | Puerto Rico | 72045 | 32 | |
242383 | 242383 | 2020-06-15 | Comerio | Puerto Rico | 72045 | 32 | |
245495 | 245495 | 2020-06-16 | Comerio | Puerto Rico | 72045 | 32 | |
248608 | 248608 | 2020-06-17 | Comerio | Puerto Rico | 72045 | 32 | |
251723 | 251723 | 2020-06-18 | Comerio | Puerto Rico | 72045 | 32 | |
254838 | 254838 | 2020-06-19 | Comerio | Puerto Rico | 72045 | 32 | |
257964 | 257964 | 2020-06-20 | Comerio | Puerto Rico | 72045 | 32 | |
261091 | 261091 | 2020-06-21 | Comerio | Puerto Rico | 72045 | 32 | |
264219 | 264219 | 2020-06-22 | Comerio | Puerto Rico | 72045 | 32 | |
267347 | 267347 | 2020-06-23 | Comerio | Puerto Rico | 72045 | 32 | |
270481 | 270481 | 2020-06-24 | Comerio | Puerto Rico | 72045 | 32 | |
273620 | 273620 | 2020-06-25 | Comerio | Puerto Rico | 72045 | 43 | |
276767 | 276767 | 2020-06-26 | Comerio | Puerto Rico | 72045 | 43 | |
279915 | 279915 | 2020-06-27 | Comerio | Puerto Rico | 72045 | 44 | |
283061 | 283061 | 2020-06-28 | Comerio | Puerto Rico | 72045 | 46 | |
286206 | 286206 | 2020-06-29 | Comerio | Puerto Rico | 72045 | 46 | |
289357 | 289357 | 2020-06-30 | Comerio | Puerto Rico | 72045 | 47 | |
292509 | 292509 | 2020-07-01 | Comerio | Puerto Rico | 72045 | 47 | |
295665 | 295665 | 2020-07-02 | Comerio | Puerto Rico | 72045 | 47 | |
298824 | 298824 | 2020-07-03 | Comerio | Puerto Rico | 72045 | 47 | |
301988 | 301988 | 2020-07-04 | Comerio | Puerto Rico | 72045 | 48 | |
305151 | 305151 | 2020-07-05 | Comerio | Puerto Rico | 72045 | 48 | |
308318 | 308318 | 2020-07-06 | Comerio | Puerto Rico | 72045 | 54 | |
311487 | 311487 | 2020-07-07 | Comerio | Puerto Rico | 72045 | 54 | |
314659 | 314659 | 2020-07-08 | Comerio | Puerto Rico | 72045 | 55 | |
317832 | 317832 | 2020-07-09 | Comerio | Puerto Rico | 72045 | 55 | |
321010 | 321010 | 2020-07-10 | Comerio | Puerto Rico | 72045 | 55 | |
324190 | 324190 | 2020-07-11 | Comerio | Puerto Rico | 72045 | 58 | |
327375 | 327375 | 2020-07-12 | Comerio | Puerto Rico | 72045 | 64 | |
330561 | 330561 | 2020-07-13 | Comerio | Puerto Rico | 72045 | 69 | |
333753 | 333753 | 2020-07-14 | Comerio | Puerto Rico | 72045 | 69 | |
336947 | 336947 | 2020-07-15 | Comerio | Puerto Rico | 72045 | 69 | |
340144 | 340144 | 2020-07-16 | Comerio | Puerto Rico | 72045 | 71 | |
343342 | 343342 | 2020-07-17 | Comerio | Puerto Rico | 72045 | 75 | |
346542 | 346542 | 2020-07-18 | Comerio | Puerto Rico | 72045 | 76 | |
349742 | 349742 | 2020-07-19 | Comerio | Puerto Rico | 72045 | 82 | |
352945 | 352945 | 2020-07-20 | Comerio | Puerto Rico | 72045 | 84 | |
356148 | 356148 | 2020-07-21 | Comerio | Puerto Rico | 72045 | 84 | |
359352 | 359352 | 2020-07-22 | Comerio | Puerto Rico | 72045 | 84 | |
362558 | 362558 | 2020-07-23 | Comerio | Puerto Rico | 72045 | 86 | |
365764 | 365764 | 2020-07-24 | Comerio | Puerto Rico | 72045 | 89 | |
368973 | 368973 | 2020-07-25 | Comerio | Puerto Rico | 72045 | 92 | |
372185 | 372185 | 2020-07-26 | Comerio | Puerto Rico | 72045 | 94 | |
375398 | 375398 | 2020-07-27 | Comerio | Puerto Rico | 72045 | 94 | |
378614 | 378614 | 2020-07-28 | Comerio | Puerto Rico | 72045 | 95 | |
381831 | 381831 | 2020-07-29 | Comerio | Puerto Rico | 72045 | 95 | |
385049 | 385049 | 2020-07-30 | Comerio | Puerto Rico | 72045 | 97 | |
388266 | 388266 | 2020-07-31 | Comerio | Puerto Rico | 72045 | 99 | |
391483 | 391483 | 2020-08-01 | Comerio | Puerto Rico | 72045 | 102 | |
394699 | 394699 | 2020-08-02 | Comerio | Puerto Rico | 72045 | 105 | |
397916 | 397916 | 2020-08-03 | Comerio | Puerto Rico | 72045 | 110 | |
401131 | 401131 | 2020-08-04 | Comerio | Puerto Rico | 72045 | 112 | |
404349 | 404349 | 2020-08-05 | Comerio | Puerto Rico | 72045 | 112 | |
407568 | 407568 | 2020-08-06 | Comerio | Puerto Rico | 72045 | 113 | |
410788 | 410788 | 2020-08-07 | Comerio | Puerto Rico | 72045 | 114 | |
414008 | 414008 | 2020-08-08 | Comerio | Puerto Rico | 72045 | 115 | |
417229 | 417229 | 2020-08-09 | Comerio | Puerto Rico | 72045 | 117 | |
420449 | 420449 | 2020-08-10 | Comerio | Puerto Rico | 72045 | 122 | |
423672 | 423672 | 2020-08-11 | Comerio | Puerto Rico | 72045 | 122 | |
426895 | 426895 | 2020-08-12 | Comerio | Puerto Rico | 72045 | 130 |
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);