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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- …
state 1
- Rhode Island · 804 ✖
fips 1
- - 804
county 1
- Unknown · 804 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
419 | 419 | 2020-03-01 | Unknown | Rhode Island | 2 | 0 | |
451 | 451 | 2020-03-02 | Unknown | Rhode Island | 2 | 0 | |
486 | 486 | 2020-03-03 | Unknown | Rhode Island | 2 | 0 | |
523 | 523 | 2020-03-04 | Unknown | Rhode Island | 2 | 0 | |
570 | 570 | 2020-03-05 | Unknown | Rhode Island | 2 | 0 | |
637 | 637 | 2020-03-06 | Unknown | Rhode Island | 3 | 0 | |
729 | 729 | 2020-03-07 | Unknown | Rhode Island | 3 | 0 | |
838 | 838 | 2020-03-08 | Unknown | Rhode Island | 3 | 0 | |
967 | 967 | 2020-03-09 | Unknown | Rhode Island | 3 | 0 | |
1120 | 1120 | 2020-03-10 | Unknown | Rhode Island | 5 | 0 | |
1314 | 1314 | 2020-03-11 | Unknown | Rhode Island | 5 | 0 | |
1560 | 1560 | 2020-03-12 | Unknown | Rhode Island | 5 | 0 | |
1860 | 1860 | 2020-03-13 | Unknown | Rhode Island | 20 | 0 | |
2222 | 2222 | 2020-03-14 | Unknown | Rhode Island | 20 | 0 | |
2644 | 2644 | 2020-03-15 | Unknown | Rhode Island | 20 | 0 | |
3109 | 3109 | 2020-03-16 | Unknown | Rhode Island | 21 | 0 | |
3639 | 3639 | 2020-03-17 | Unknown | Rhode Island | 23 | 0 | |
4258 | 4258 | 2020-03-18 | Unknown | Rhode Island | 33 | 0 | |
25551 | 25551 | 2020-04-01 | Unknown | Rhode Island | 37 | 7 | |
5000 | 5000 | 2020-03-19 | Unknown | Rhode Island | 44 | 0 | |
5873 | 5873 | 2020-03-20 | Unknown | Rhode Island | 44 | 0 | |
6877 | 6877 | 2020-03-21 | Unknown | Rhode Island | 66 | 0 | |
12003 | 12003 | 2020-03-25 | Unknown | Rhode Island | 66 | 0 | |
19166 | 19166 | 2020-03-29 | Unknown | Rhode Island | 69 | 3 | |
23354 | 23354 | 2020-03-31 | Unknown | Rhode Island | 72 | 8 | |
7997 | 7997 | 2020-03-22 | Unknown | Rhode Island | 83 | 0 | |
27824 | 27824 | 2020-04-02 | Unknown | Rhode Island | 92 | 9 | |
13625 | 13625 | 2020-03-26 | Unknown | Rhode Island | 94 | 0 | |
21217 | 21217 | 2020-03-30 | Unknown | Rhode Island | 99 | 4 | |
9208 | 9208 | 2020-03-23 | Unknown | Rhode Island | 106 | 0 | |
32550 | 32550 | 2020-04-04 | Unknown | Rhode Island | 122 | 10 | |
10533 | 10533 | 2020-03-24 | Unknown | Rhode Island | 124 | 0 | |
15372 | 15372 | 2020-03-27 | Unknown | Rhode Island | 132 | 0 | |
30159 | 30159 | 2020-04-03 | Unknown | Rhode Island | 146 | 7 | |
17226 | 17226 | 2020-03-28 | Unknown | Rhode Island | 168 | 2 | |
34986 | 34986 | 2020-04-05 | Unknown | Rhode Island | 172 | 18 | |
39984 | 39984 | 2020-04-07 | Unknown | Rhode Island | 223 | 13 | |
42544 | 42544 | 2020-04-08 | Unknown | Rhode Island | 297 | 15 | |
37461 | 37461 | 2020-04-06 | Unknown | Rhode Island | 332 | 20 | |
45130 | 45130 | 2020-04-09 | Unknown | Rhode Island | 424 | 23 | |
50404 | 50404 | 2020-04-11 | Unknown | Rhode Island | 673 | 36 | |
47747 | 47747 | 2020-04-10 | Unknown | Rhode Island | 712 | 29 | |
72177 | 72177 | 2020-04-19 | Unknown | Rhode Island | 715 | 130 | |
58465 | 58465 | 2020-04-14 | Unknown | Rhode Island | 756 | 60 | |
69410 | 69410 | 2020-04-18 | Unknown | Rhode Island | 815 | 117 | |
66652 | 66652 | 2020-04-17 | Unknown | Rhode Island | 832 | 98 | |
63906 | 63906 | 2020-04-16 | Unknown | Rhode Island | 840 | 85 | |
74952 | 74952 | 2020-04-20 | Unknown | Rhode Island | 861 | 135 | |
53077 | 53077 | 2020-04-12 | Unknown | Rhode Island | 989 | 43 | |
77734 | 77734 | 2020-04-21 | Unknown | Rhode Island | 1000 | 151 | |
61180 | 61180 | 2020-04-15 | Unknown | Rhode Island | 1034 | 67 | |
141445 | 141445 | 2020-05-13 | Unknown | Rhode Island | 1046 | 37 | |
100272 | 100272 | 2020-04-29 | Unknown | Rhode Island | 1065 | 104 | |
111729 | 111729 | 2020-05-03 | Unknown | Rhode Island | 1086 | 1 | |
103125 | 103125 | 2020-04-30 | Unknown | Rhode Island | 1087 | 119 | |
105988 | 105988 | 2020-05-01 | Unknown | Rhode Island | 1104 | 132 | |
91757 | 91757 | 2020-04-26 | Unknown | Rhode Island | 1109 | 111 | |
86127 | 86127 | 2020-04-24 | Unknown | Rhode Island | 1132 | 182 | |
114611 | 114611 | 2020-05-04 | Unknown | Rhode Island | 1133 | 22 | |
108855 | 108855 | 2020-05-02 | Unknown | Rhode Island | 1142 | 149 | |
135459 | 135459 | 2020-05-11 | Unknown | Rhode Island | 1158 | 5 | |
88941 | 88941 | 2020-04-25 | Unknown | Rhode Island | 1198 | 96 | |
138449 | 138449 | 2020-05-12 | Unknown | Rhode Island | 1198 | 19 | |
144441 | 144441 | 2020-05-14 | Unknown | Rhode Island | 1227 | 43 | |
97423 | 97423 | 2020-04-28 | Unknown | Rhode Island | 1267 | 124 | |
55762 | 55762 | 2020-04-13 | Unknown | Rhode Island | 1300 | 53 | |
80524 | 80524 | 2020-04-22 | Unknown | Rhode Island | 1341 | 161 | |
94584 | 94584 | 2020-04-27 | Unknown | Rhode Island | 1378 | 118 | |
117567 | 117567 | 2020-05-05 | Unknown | Rhode Island | 1414 | 36 | |
147442 | 147442 | 2020-05-15 | Unknown | Rhode Island | 1430 | 54 | |
337008 | 337008 | 2020-07-15 | Unknown | Rhode Island | 1438 | 6 | |
359413 | 359413 | 2020-07-22 | Unknown | Rhode Island | 1449 | 10 | |
298885 | 298885 | 2020-07-03 | Unknown | Rhode Island | 1488 | 36 | |
302049 | 302049 | 2020-07-04 | Unknown | Rhode Island | 1488 | 36 | |
305212 | 305212 | 2020-07-05 | Unknown | Rhode Island | 1488 | 36 | |
308379 | 308379 | 2020-07-06 | Unknown | Rhode Island | 1488 | 36 | |
183809 | 183809 | 2020-05-27 | Unknown | Rhode Island | 1496 | 3 | |
171630 | 171630 | 2020-05-23 | Unknown | Rhode Island | 1504 | 172 | |
340205 | 340205 | 2020-07-16 | Unknown | Rhode Island | 1509 | 7 | |
264280 | 264280 | 2020-06-22 | Unknown | Rhode Island | 1514 | 106 | |
174672 | 174672 | 2020-05-24 | Unknown | Rhode Island | 1518 | 183 | |
177716 | 177716 | 2020-05-25 | Unknown | Rhode Island | 1518 | 183 | |
168591 | 168591 | 2020-05-22 | Unknown | Rhode Island | 1528 | 154 | |
186866 | 186866 | 2020-05-28 | Unknown | Rhode Island | 1533 | 25 | |
286267 | 286267 | 2020-06-29 | Unknown | Rhode Island | 1535 | 22 | |
362619 | 362619 | 2020-07-23 | Unknown | Rhode Island | 1535 | 14 | |
165555 | 165555 | 2020-05-21 | Unknown | Rhode Island | 1553 | 131 | |
162526 | 162526 | 2020-05-20 | Unknown | Rhode Island | 1556 | 113 | |
381892 | 381892 | 2020-07-29 | Unknown | Rhode Island | 1556 | 12 | |
189928 | 189928 | 2020-05-29 | Unknown | Rhode Island | 1564 | 41 | |
220718 | 220718 | 2020-06-08 | Unknown | Rhode Island | 1565 | 2 | |
242444 | 242444 | 2020-06-15 | Unknown | Rhode Island | 1569 | 54 | |
289418 | 289418 | 2020-06-30 | Unknown | Rhode Island | 1584 | 26 | |
267408 | 267408 | 2020-06-23 | Unknown | Rhode Island | 1588 | 109 | |
343403 | 343403 | 2020-07-17 | Unknown | Rhode Island | 1591 | 9 | |
346603 | 346603 | 2020-07-18 | Unknown | Rhode Island | 1591 | 9 | |
349803 | 349803 | 2020-07-19 | Unknown | Rhode Island | 1591 | 9 | |
426956 | 426956 | 2020-08-12 | Unknown | Rhode Island | 1593 | 10 | |
365825 | 365825 | 2020-07-24 | Unknown | Rhode Island | 1611 | 15 | |
369034 | 369034 | 2020-07-25 | Unknown | Rhode Island | 1611 | 15 |
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);