ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "Unknown" and state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536827 | 536827 | 2020-09-15 | Unknown | Rhode Island | 2426 | 29 | |
533591 | 533591 | 2020-09-14 | Unknown | Rhode Island | 2306 | 26 | |
530356 | 530356 | 2020-09-13 | Unknown | Rhode Island | 2081 | 22 | |
527119 | 527119 | 2020-09-12 | Unknown | Rhode Island | 2081 | 22 | |
523883 | 523883 | 2020-09-11 | Unknown | Rhode Island | 2081 | 22 | |
520647 | 520647 | 2020-09-10 | Unknown | Rhode Island | 1958 | 18 | |
517411 | 517411 | 2020-09-09 | Unknown | Rhode Island | 1852 | 13 | |
514176 | 514176 | 2020-09-08 | Unknown | Rhode Island | 2242 | 21 | |
510943 | 510943 | 2020-09-07 | Unknown | Rhode Island | 1893 | 17 | |
507710 | 507710 | 2020-09-06 | Unknown | Rhode Island | 1893 | 17 | |
504478 | 504478 | 2020-09-05 | Unknown | Rhode Island | 1893 | 17 | |
501244 | 501244 | 2020-09-04 | Unknown | Rhode Island | 1893 | 17 | |
498010 | 498010 | 2020-09-03 | Unknown | Rhode Island | 1793 | 17 | |
494777 | 494777 | 2020-09-02 | Unknown | Rhode Island | 1728 | 13 | |
491543 | 491543 | 2020-09-01 | Unknown | Rhode Island | 2193 | 23 | |
488310 | 488310 | 2020-08-31 | Unknown | Rhode Island | 2140 | 21 | |
485077 | 485077 | 2020-08-30 | Unknown | Rhode Island | 1874 | 19 | |
481842 | 481842 | 2020-08-29 | Unknown | Rhode Island | 1874 | 19 | |
478608 | 478608 | 2020-08-28 | Unknown | Rhode Island | 1874 | 19 | |
475375 | 475375 | 2020-08-27 | Unknown | Rhode Island | 1780 | 17 | |
472141 | 472141 | 2020-08-26 | Unknown | Rhode Island | 1645 | 14 | |
468909 | 468909 | 2020-08-25 | Unknown | Rhode Island | 2239 | 24 | |
465681 | 465681 | 2020-08-24 | Unknown | Rhode Island | 2169 | 20 | |
462452 | 462452 | 2020-08-23 | Unknown | Rhode Island | 1889 | 15 | |
459224 | 459224 | 2020-08-22 | Unknown | Rhode Island | 1889 | 15 | |
455996 | 455996 | 2020-08-21 | Unknown | Rhode Island | 1889 | 15 | |
452768 | 452768 | 2020-08-20 | Unknown | Rhode Island | 1738 | 13 | |
449540 | 449540 | 2020-08-19 | Unknown | Rhode Island | 1662 | 12 | |
446312 | 446312 | 2020-08-18 | Unknown | Rhode Island | 2156 | 16 | |
443086 | 443086 | 2020-08-17 | Unknown | Rhode Island | 2036 | 15 | |
439859 | 439859 | 2020-08-16 | Unknown | Rhode Island | 1799 | 13 | |
436634 | 436634 | 2020-08-15 | Unknown | Rhode Island | 1799 | 13 | |
433407 | 433407 | 2020-08-14 | Unknown | Rhode Island | 1799 | 13 | |
430181 | 430181 | 2020-08-13 | Unknown | Rhode Island | 1704 | 11 | |
426956 | 426956 | 2020-08-12 | Unknown | Rhode Island | 1593 | 10 | |
423733 | 423733 | 2020-08-11 | Unknown | Rhode Island | 2193 | 15 | |
420510 | 420510 | 2020-08-10 | Unknown | Rhode Island | 2074 | 14 | |
417290 | 417290 | 2020-08-09 | Unknown | Rhode Island | 1878 | 13 | |
414069 | 414069 | 2020-08-08 | Unknown | Rhode Island | 1878 | 13 | |
410849 | 410849 | 2020-08-07 | Unknown | Rhode Island | 1878 | 13 | |
407629 | 407629 | 2020-08-06 | Unknown | Rhode Island | 1751 | 13 | |
404410 | 404410 | 2020-08-05 | Unknown | Rhode Island | 1621 | 11 | |
401192 | 401192 | 2020-08-04 | Unknown | Rhode Island | 2146 | 16 | |
397977 | 397977 | 2020-08-03 | Unknown | Rhode Island | 2002 | 15 | |
394760 | 394760 | 2020-08-02 | Unknown | Rhode Island | 1778 | 12 | |
391544 | 391544 | 2020-08-01 | Unknown | Rhode Island | 1778 | 12 | |
388327 | 388327 | 2020-07-31 | Unknown | Rhode Island | 1778 | 12 | |
385110 | 385110 | 2020-07-30 | Unknown | Rhode Island | 1706 | 12 | |
381892 | 381892 | 2020-07-29 | Unknown | Rhode Island | 1556 | 12 | |
378675 | 378675 | 2020-07-28 | Unknown | Rhode Island | 2112 | 18 | |
375459 | 375459 | 2020-07-27 | Unknown | Rhode Island | 1902 | 17 | |
372246 | 372246 | 2020-07-26 | Unknown | Rhode Island | 1611 | 15 | |
369034 | 369034 | 2020-07-25 | Unknown | Rhode Island | 1611 | 15 | |
365825 | 365825 | 2020-07-24 | Unknown | Rhode Island | 1611 | 15 | |
362619 | 362619 | 2020-07-23 | Unknown | Rhode Island | 1535 | 14 | |
359413 | 359413 | 2020-07-22 | Unknown | Rhode Island | 1449 | 10 | |
356209 | 356209 | 2020-07-21 | Unknown | Rhode Island | 1784 | 15 | |
353006 | 353006 | 2020-07-20 | Unknown | Rhode Island | 1702 | 14 | |
349803 | 349803 | 2020-07-19 | Unknown | Rhode Island | 1591 | 9 | |
346603 | 346603 | 2020-07-18 | Unknown | Rhode Island | 1591 | 9 | |
343403 | 343403 | 2020-07-17 | Unknown | Rhode Island | 1591 | 9 | |
340205 | 340205 | 2020-07-16 | Unknown | Rhode Island | 1509 | 7 | |
337008 | 337008 | 2020-07-15 | Unknown | Rhode Island | 1438 | 6 | |
333814 | 333814 | 2020-07-14 | Unknown | Rhode Island | 2085 | 30 | |
330622 | 330622 | 2020-07-13 | Unknown | Rhode Island | 1984 | 29 | |
327436 | 327436 | 2020-07-12 | Unknown | Rhode Island | 1809 | 21 | |
324251 | 324251 | 2020-07-11 | Unknown | Rhode Island | 1809 | 21 | |
321071 | 321071 | 2020-07-10 | Unknown | Rhode Island | 1809 | 21 | |
317893 | 317893 | 2020-07-09 | Unknown | Rhode Island | 1740 | 19 | |
314720 | 314720 | 2020-07-08 | Unknown | Rhode Island | 1701 | 16 | |
311548 | 311548 | 2020-07-07 | Unknown | Rhode Island | 1651 | 45 | |
308379 | 308379 | 2020-07-06 | Unknown | Rhode Island | 1488 | 36 | |
305212 | 305212 | 2020-07-05 | Unknown | Rhode Island | 1488 | 36 | |
302049 | 302049 | 2020-07-04 | Unknown | Rhode Island | 1488 | 36 | |
298885 | 298885 | 2020-07-03 | Unknown | Rhode Island | 1488 | 36 | |
295726 | 295726 | 2020-07-02 | Unknown | Rhode Island | 1712 | 35 | |
292570 | 292570 | 2020-07-01 | Unknown | Rhode Island | 1624 | 32 | |
289418 | 289418 | 2020-06-30 | Unknown | Rhode Island | 1584 | 26 | |
286267 | 286267 | 2020-06-29 | Unknown | Rhode Island | 1535 | 22 | |
283122 | 283122 | 2020-06-28 | Unknown | Rhode Island | 1716 | 3 | |
279976 | 279976 | 2020-06-27 | Unknown | Rhode Island | 1716 | 3 | |
276828 | 276828 | 2020-06-26 | Unknown | Rhode Island | 1716 | 3 | |
273681 | 273681 | 2020-06-25 | Unknown | Rhode Island | 1695 | 123 | |
270542 | 270542 | 2020-06-24 | Unknown | Rhode Island | 1661 | 115 | |
267408 | 267408 | 2020-06-23 | Unknown | Rhode Island | 1588 | 109 | |
264280 | 264280 | 2020-06-22 | Unknown | Rhode Island | 1514 | 106 | |
261152 | 261152 | 2020-06-21 | Unknown | Rhode Island | 1813 | 97 | |
258025 | 258025 | 2020-06-20 | Unknown | Rhode Island | 1813 | 97 | |
254899 | 254899 | 2020-06-19 | Unknown | Rhode Island | 1813 | 97 | |
251784 | 251784 | 2020-06-18 | Unknown | Rhode Island | 1745 | 88 | |
248669 | 248669 | 2020-06-17 | Unknown | Rhode Island | 1689 | 79 | |
245556 | 245556 | 2020-06-16 | Unknown | Rhode Island | 1640 | 68 | |
242444 | 242444 | 2020-06-15 | Unknown | Rhode Island | 1569 | 54 | |
239335 | 239335 | 2020-06-14 | Unknown | Rhode Island | 1870 | 36 | |
236227 | 236227 | 2020-06-13 | Unknown | Rhode Island | 1870 | 36 | |
233122 | 233122 | 2020-06-12 | Unknown | Rhode Island | 1870 | 36 | |
230017 | 230017 | 2020-06-11 | Unknown | Rhode Island | 1785 | 26 | |
226913 | 226913 | 2020-06-10 | Unknown | Rhode Island | 1679 | 15 | |
223813 | 223813 | 2020-06-09 | Unknown | Rhode Island | 1614 | 11 | |
220718 | 220718 | 2020-06-08 | Unknown | Rhode Island | 1565 | 2 |
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);