ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Corozal" 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 |
---|---|---|---|---|---|---|---|
117510 | 117510 | 2020-05-05 | Corozal | Puerto Rico | 72047 | 18 | |
120472 | 120472 | 2020-05-06 | Corozal | Puerto Rico | 72047 | 18 | |
123449 | 123449 | 2020-05-07 | Corozal | Puerto Rico | 72047 | 18 | |
126432 | 126432 | 2020-05-08 | Corozal | Puerto Rico | 72047 | 19 | |
129421 | 129421 | 2020-05-09 | Corozal | Puerto Rico | 72047 | 19 | |
132410 | 132410 | 2020-05-10 | Corozal | Puerto Rico | 72047 | 19 | |
135401 | 135401 | 2020-05-11 | Corozal | Puerto Rico | 72047 | 19 | |
138391 | 138391 | 2020-05-12 | Corozal | Puerto Rico | 72047 | 19 | |
141387 | 141387 | 2020-05-13 | Corozal | Puerto Rico | 72047 | 19 | |
144383 | 144383 | 2020-05-14 | Corozal | Puerto Rico | 72047 | 20 | |
147384 | 147384 | 2020-05-15 | Corozal | Puerto Rico | 72047 | 20 | |
150391 | 150391 | 2020-05-16 | Corozal | Puerto Rico | 72047 | 21 | |
153402 | 153402 | 2020-05-17 | Corozal | Puerto Rico | 72047 | 21 | |
156419 | 156419 | 2020-05-18 | Corozal | Puerto Rico | 72047 | 22 | |
159440 | 159440 | 2020-05-19 | Corozal | Puerto Rico | 72047 | 23 | |
162467 | 162467 | 2020-05-20 | Corozal | Puerto Rico | 72047 | 23 | |
165496 | 165496 | 2020-05-21 | Corozal | Puerto Rico | 72047 | 23 | |
168532 | 168532 | 2020-05-22 | Corozal | Puerto Rico | 72047 | 24 | |
171571 | 171571 | 2020-05-23 | Corozal | Puerto Rico | 72047 | 25 | |
174613 | 174613 | 2020-05-24 | Corozal | Puerto Rico | 72047 | 25 | |
177657 | 177657 | 2020-05-25 | Corozal | Puerto Rico | 72047 | 26 | |
180700 | 180700 | 2020-05-26 | Corozal | Puerto Rico | 72047 | 26 | |
183750 | 183750 | 2020-05-27 | Corozal | Puerto Rico | 72047 | 26 | |
186807 | 186807 | 2020-05-28 | Corozal | Puerto Rico | 72047 | 27 | |
189868 | 189868 | 2020-05-29 | Corozal | Puerto Rico | 72047 | 29 | |
192933 | 192933 | 2020-05-30 | Corozal | Puerto Rico | 72047 | 30 | |
196002 | 196002 | 2020-05-31 | Corozal | Puerto Rico | 72047 | 30 | |
199075 | 199075 | 2020-06-01 | Corozal | Puerto Rico | 72047 | 30 | |
202150 | 202150 | 2020-06-02 | Corozal | Puerto Rico | 72047 | 30 | |
205227 | 205227 | 2020-06-03 | Corozal | Puerto Rico | 72047 | 30 | |
208308 | 208308 | 2020-06-04 | Corozal | Puerto Rico | 72047 | 32 | |
211390 | 211390 | 2020-06-05 | Corozal | Puerto Rico | 72047 | 33 | |
214476 | 214476 | 2020-06-06 | Corozal | Puerto Rico | 72047 | 35 | |
217566 | 217566 | 2020-06-07 | Corozal | Puerto Rico | 72047 | 37 | |
220658 | 220658 | 2020-06-08 | Corozal | Puerto Rico | 72047 | 37 | |
223753 | 223753 | 2020-06-09 | Corozal | Puerto Rico | 72047 | 38 | |
226853 | 226853 | 2020-06-10 | Corozal | Puerto Rico | 72047 | 38 | |
229957 | 229957 | 2020-06-11 | Corozal | Puerto Rico | 72047 | 38 | |
233062 | 233062 | 2020-06-12 | Corozal | Puerto Rico | 72047 | 39 | |
236167 | 236167 | 2020-06-13 | Corozal | Puerto Rico | 72047 | 40 | |
239275 | 239275 | 2020-06-14 | Corozal | Puerto Rico | 72047 | 41 | |
242384 | 242384 | 2020-06-15 | Corozal | Puerto Rico | 72047 | 43 | |
245496 | 245496 | 2020-06-16 | Corozal | Puerto Rico | 72047 | 44 | |
248609 | 248609 | 2020-06-17 | Corozal | Puerto Rico | 72047 | 46 | |
251724 | 251724 | 2020-06-18 | Corozal | Puerto Rico | 72047 | 46 | |
254839 | 254839 | 2020-06-19 | Corozal | Puerto Rico | 72047 | 46 | |
257965 | 257965 | 2020-06-20 | Corozal | Puerto Rico | 72047 | 46 | |
261092 | 261092 | 2020-06-21 | Corozal | Puerto Rico | 72047 | 46 | |
264220 | 264220 | 2020-06-22 | Corozal | Puerto Rico | 72047 | 47 | |
267348 | 267348 | 2020-06-23 | Corozal | Puerto Rico | 72047 | 47 | |
270482 | 270482 | 2020-06-24 | Corozal | Puerto Rico | 72047 | 48 | |
273621 | 273621 | 2020-06-25 | Corozal | Puerto Rico | 72047 | 48 | |
276768 | 276768 | 2020-06-26 | Corozal | Puerto Rico | 72047 | 48 | |
279916 | 279916 | 2020-06-27 | Corozal | Puerto Rico | 72047 | 48 | |
283062 | 283062 | 2020-06-28 | Corozal | Puerto Rico | 72047 | 48 | |
286207 | 286207 | 2020-06-29 | Corozal | Puerto Rico | 72047 | 48 | |
289358 | 289358 | 2020-06-30 | Corozal | Puerto Rico | 72047 | 49 | |
292510 | 292510 | 2020-07-01 | Corozal | Puerto Rico | 72047 | 51 | |
295666 | 295666 | 2020-07-02 | Corozal | Puerto Rico | 72047 | 51 | |
298825 | 298825 | 2020-07-03 | Corozal | Puerto Rico | 72047 | 52 | |
301989 | 301989 | 2020-07-04 | Corozal | Puerto Rico | 72047 | 52 | |
305152 | 305152 | 2020-07-05 | Corozal | Puerto Rico | 72047 | 53 | |
308319 | 308319 | 2020-07-06 | Corozal | Puerto Rico | 72047 | 56 | |
311488 | 311488 | 2020-07-07 | Corozal | Puerto Rico | 72047 | 57 | |
314660 | 314660 | 2020-07-08 | Corozal | Puerto Rico | 72047 | 57 | |
317833 | 317833 | 2020-07-09 | Corozal | Puerto Rico | 72047 | 58 | |
321011 | 321011 | 2020-07-10 | Corozal | Puerto Rico | 72047 | 59 | |
324191 | 324191 | 2020-07-11 | Corozal | Puerto Rico | 72047 | 60 | |
327376 | 327376 | 2020-07-12 | Corozal | Puerto Rico | 72047 | 62 | |
330562 | 330562 | 2020-07-13 | Corozal | Puerto Rico | 72047 | 67 | |
333754 | 333754 | 2020-07-14 | Corozal | Puerto Rico | 72047 | 67 | |
336948 | 336948 | 2020-07-15 | Corozal | Puerto Rico | 72047 | 68 | |
340145 | 340145 | 2020-07-16 | Corozal | Puerto Rico | 72047 | 69 | |
343343 | 343343 | 2020-07-17 | Corozal | Puerto Rico | 72047 | 71 | |
346543 | 346543 | 2020-07-18 | Corozal | Puerto Rico | 72047 | 71 | |
349743 | 349743 | 2020-07-19 | Corozal | Puerto Rico | 72047 | 77 | |
352946 | 352946 | 2020-07-20 | Corozal | Puerto Rico | 72047 | 84 | |
356149 | 356149 | 2020-07-21 | Corozal | Puerto Rico | 72047 | 89 | |
359353 | 359353 | 2020-07-22 | Corozal | Puerto Rico | 72047 | 89 | |
362559 | 362559 | 2020-07-23 | Corozal | Puerto Rico | 72047 | 92 | |
365765 | 365765 | 2020-07-24 | Corozal | Puerto Rico | 72047 | 98 | |
368974 | 368974 | 2020-07-25 | Corozal | Puerto Rico | 72047 | 107 | |
372186 | 372186 | 2020-07-26 | Corozal | Puerto Rico | 72047 | 116 | |
375399 | 375399 | 2020-07-27 | Corozal | Puerto Rico | 72047 | 118 | |
378615 | 378615 | 2020-07-28 | Corozal | Puerto Rico | 72047 | 124 | |
381832 | 381832 | 2020-07-29 | Corozal | Puerto Rico | 72047 | 129 | |
385050 | 385050 | 2020-07-30 | Corozal | Puerto Rico | 72047 | 141 | |
388267 | 388267 | 2020-07-31 | Corozal | Puerto Rico | 72047 | 145 | |
391484 | 391484 | 2020-08-01 | Corozal | Puerto Rico | 72047 | 174 | |
394700 | 394700 | 2020-08-02 | Corozal | Puerto Rico | 72047 | 176 | |
397917 | 397917 | 2020-08-03 | Corozal | Puerto Rico | 72047 | 178 | |
401132 | 401132 | 2020-08-04 | Corozal | Puerto Rico | 72047 | 188 | |
404350 | 404350 | 2020-08-05 | Corozal | Puerto Rico | 72047 | 189 | |
407569 | 407569 | 2020-08-06 | Corozal | Puerto Rico | 72047 | 192 | |
410789 | 410789 | 2020-08-07 | Corozal | Puerto Rico | 72047 | 203 | |
414009 | 414009 | 2020-08-08 | Corozal | Puerto Rico | 72047 | 218 | |
417230 | 417230 | 2020-08-09 | Corozal | Puerto Rico | 72047 | 226 | |
420450 | 420450 | 2020-08-10 | Corozal | Puerto Rico | 72047 | 242 | |
423673 | 423673 | 2020-08-11 | Corozal | Puerto Rico | 72047 | 247 | |
426896 | 426896 | 2020-08-12 | Corozal | Puerto Rico | 72047 | 249 |
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);