ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Providence" and state = "Rhode Island" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
12002 | 12002 | 2020-03-25 | Providence | Rhode Island | 44007 | 37 | 0 |
13624 | 13624 | 2020-03-26 | Providence | Rhode Island | 44007 | 42 | 0 |
15371 | 15371 | 2020-03-27 | Providence | Rhode Island | 44007 | 42 | 0 |
17225 | 17225 | 2020-03-28 | Providence | Rhode Island | 44007 | 42 | 0 |
19165 | 19165 | 2020-03-29 | Providence | Rhode Island | 44007 | 148 | 0 |
21216 | 21216 | 2020-03-30 | Providence | Rhode Island | 44007 | 214 | 0 |
23353 | 23353 | 2020-03-31 | Providence | Rhode Island | 44007 | 305 | 0 |
25550 | 25550 | 2020-04-01 | Providence | Rhode Island | 44007 | 391 | 3 |
27823 | 27823 | 2020-04-02 | Providence | Rhode Island | 44007 | 418 | 3 |
30158 | 30158 | 2020-04-03 | Providence | Rhode Island | 44007 | 418 | 7 |
32549 | 32549 | 2020-04-04 | Providence | Rhode Island | 44007 | 491 | 7 |
34985 | 34985 | 2020-04-05 | Providence | Rhode Island | 44007 | 538 | 7 |
37460 | 37460 | 2020-04-06 | Providence | Rhode Island | 44007 | 538 | 7 |
39983 | 39983 | 2020-04-07 | Providence | Rhode Island | 44007 | 715 | 17 |
42543 | 42543 | 2020-04-08 | Providence | Rhode Island | 44007 | 832 | 20 |
45129 | 45129 | 2020-04-09 | Providence | Rhode Island | 44007 | 957 | 20 |
47746 | 47746 | 2020-04-10 | Providence | Rhode Island | 44007 | 957 | 20 |
50403 | 50403 | 2020-04-11 | Providence | Rhode Island | 44007 | 1278 | 20 |
53076 | 53076 | 2020-04-12 | Providence | Rhode Island | 44007 | 1278 | 20 |
55761 | 55761 | 2020-04-13 | Providence | Rhode Island | 44007 | 1278 | 20 |
58464 | 58464 | 2020-04-14 | Providence | Rhode Island | 44007 | 1957 | 20 |
61179 | 61179 | 2020-04-15 | Providence | Rhode Island | 44007 | 1957 | 20 |
63905 | 63905 | 2020-04-16 | Providence | Rhode Island | 44007 | 2401 | 20 |
66651 | 66651 | 2020-04-17 | Providence | Rhode Island | 44007 | 2703 | 20 |
69409 | 69409 | 2020-04-18 | Providence | Rhode Island | 44007 | 3014 | 20 |
72176 | 72176 | 2020-04-19 | Providence | Rhode Island | 44007 | 3292 | 20 |
74951 | 74951 | 2020-04-20 | Providence | Rhode Island | 44007 | 3491 | 20 |
77733 | 77733 | 2020-04-21 | Providence | Rhode Island | 44007 | 3727 | 20 |
80523 | 80523 | 2020-04-22 | Providence | Rhode Island | 44007 | 3727 | 20 |
83322 | 83322 | 2020-04-23 | Providence | Rhode Island | 44007 | 3727 | 20 |
86126 | 86126 | 2020-04-24 | Providence | Rhode Island | 44007 | 4603 | 20 |
88940 | 88940 | 2020-04-25 | Providence | Rhode Island | 44007 | 4916 | 111 |
91756 | 91756 | 2020-04-26 | Providence | Rhode Island | 44007 | 5266 | 107 |
94583 | 94583 | 2020-04-27 | Providence | Rhode Island | 44007 | 5266 | 107 |
97422 | 97422 | 2020-04-28 | Providence | Rhode Island | 44007 | 5520 | 107 |
100271 | 100271 | 2020-04-29 | Providence | Rhode Island | 44007 | 5967 | 132 |
103124 | 103124 | 2020-04-30 | Providence | Rhode Island | 44007 | 6290 | 132 |
105987 | 105987 | 2020-05-01 | Providence | Rhode Island | 44007 | 6579 | 132 |
108854 | 108854 | 2020-05-02 | Providence | Rhode Island | 44007 | 6822 | 132 |
111728 | 111728 | 2020-05-03 | Providence | Rhode Island | 44007 | 7028 | 265 |
114610 | 114610 | 2020-05-04 | Providence | Rhode Island | 44007 | 7138 | 265 |
117566 | 117566 | 2020-05-05 | Providence | Rhode Island | 44007 | 7138 | 265 |
120528 | 120528 | 2020-05-06 | Providence | Rhode Island | 44007 | 7138 | 265 |
123506 | 123506 | 2020-05-07 | Providence | Rhode Island | 44007 | 7138 | 265 |
126489 | 126489 | 2020-05-08 | Providence | Rhode Island | 44007 | 7138 | 265 |
129478 | 129478 | 2020-05-09 | Providence | Rhode Island | 44007 | 7138 | 265 |
132467 | 132467 | 2020-05-10 | Providence | Rhode Island | 44007 | 7138 | 265 |
135458 | 135458 | 2020-05-11 | Providence | Rhode Island | 44007 | 8674 | 342 |
138448 | 138448 | 2020-05-12 | Providence | Rhode Island | 44007 | 8798 | 342 |
141444 | 141444 | 2020-05-13 | Providence | Rhode Island | 44007 | 9112 | 342 |
144440 | 144440 | 2020-05-14 | Providence | Rhode Island | 44007 | 9112 | 342 |
147441 | 147441 | 2020-05-15 | Providence | Rhode Island | 44007 | 9112 | 342 |
150449 | 150449 | 2020-05-16 | Providence | Rhode Island | 44007 | 9112 | 342 |
153460 | 153460 | 2020-05-17 | Providence | Rhode Island | 44007 | 9112 | 342 |
156477 | 156477 | 2020-05-18 | Providence | Rhode Island | 44007 | 9112 | 342 |
159498 | 159498 | 2020-05-19 | Providence | Rhode Island | 44007 | 9112 | 342 |
162525 | 162525 | 2020-05-20 | Providence | Rhode Island | 44007 | 9976 | 342 |
165554 | 165554 | 2020-05-21 | Providence | Rhode Island | 44007 | 10160 | 342 |
168590 | 168590 | 2020-05-22 | Providence | Rhode Island | 44007 | 10320 | 342 |
171629 | 171629 | 2020-05-23 | Providence | Rhode Island | 44007 | 10519 | 342 |
174671 | 174671 | 2020-05-24 | Providence | Rhode Island | 44007 | 10607 | 342 |
177715 | 177715 | 2020-05-25 | Providence | Rhode Island | 44007 | 10607 | 342 |
180758 | 180758 | 2020-05-26 | Providence | Rhode Island | 44007 | 10607 | 342 |
183808 | 183808 | 2020-05-27 | Providence | Rhode Island | 44007 | 10874 | 518 |
186865 | 186865 | 2020-05-28 | Providence | Rhode Island | 44007 | 10968 | 518 |
189927 | 189927 | 2020-05-29 | Providence | Rhode Island | 44007 | 11052 | 518 |
192992 | 192992 | 2020-05-30 | Providence | Rhode Island | 44007 | 11052 | 518 |
196061 | 196061 | 2020-05-31 | Providence | Rhode Island | 44007 | 11052 | 518 |
199134 | 199134 | 2020-06-01 | Providence | Rhode Island | 44007 | 11052 | 518 |
202209 | 202209 | 2020-06-02 | Providence | Rhode Island | 44007 | 11052 | 518 |
205286 | 205286 | 2020-06-03 | Providence | Rhode Island | 44007 | 11052 | 518 |
208367 | 208367 | 2020-06-04 | Providence | Rhode Island | 44007 | 11052 | 518 |
211449 | 211449 | 2020-06-05 | Providence | Rhode Island | 44007 | 11052 | 518 |
214535 | 214535 | 2020-06-06 | Providence | Rhode Island | 44007 | 11052 | 518 |
217625 | 217625 | 2020-06-07 | Providence | Rhode Island | 44007 | 11052 | 518 |
220717 | 220717 | 2020-06-08 | Providence | Rhode Island | 44007 | 11959 | 637 |
223812 | 223812 | 2020-06-09 | Providence | Rhode Island | 44007 | 11959 | 637 |
226912 | 226912 | 2020-06-10 | Providence | Rhode Island | 44007 | 11959 | 637 |
230016 | 230016 | 2020-06-11 | Providence | Rhode Island | 44007 | 11959 | 637 |
233121 | 233121 | 2020-06-12 | Providence | Rhode Island | 44007 | 11959 | 637 |
236226 | 236226 | 2020-06-13 | Providence | Rhode Island | 44007 | 11959 | 637 |
239334 | 239334 | 2020-06-14 | Providence | Rhode Island | 44007 | 11959 | 637 |
242443 | 242443 | 2020-06-15 | Providence | Rhode Island | 44007 | 12363 | 637 |
245555 | 245555 | 2020-06-16 | Providence | Rhode Island | 44007 | 12363 | 637 |
248668 | 248668 | 2020-06-17 | Providence | Rhode Island | 44007 | 12363 | 637 |
251783 | 251783 | 2020-06-18 | Providence | Rhode Island | 44007 | 12363 | 637 |
254898 | 254898 | 2020-06-19 | Providence | Rhode Island | 44007 | 12363 | 637 |
258024 | 258024 | 2020-06-20 | Providence | Rhode Island | 44007 | 12363 | 637 |
261151 | 261151 | 2020-06-21 | Providence | Rhode Island | 44007 | 12363 | 637 |
264279 | 264279 | 2020-06-22 | Providence | Rhode Island | 44007 | 12712 | 637 |
267407 | 267407 | 2020-06-23 | Providence | Rhode Island | 44007 | 12712 | 637 |
270541 | 270541 | 2020-06-24 | Providence | Rhode Island | 44007 | 12712 | 637 |
273680 | 273680 | 2020-06-25 | Providence | Rhode Island | 44007 | 12712 | 637 |
276827 | 276827 | 2020-06-26 | Providence | Rhode Island | 44007 | 12712 | 747 |
279975 | 279975 | 2020-06-27 | Providence | Rhode Island | 44007 | 12712 | 747 |
283121 | 283121 | 2020-06-28 | Providence | Rhode Island | 44007 | 12712 | 747 |
286266 | 286266 | 2020-06-29 | Providence | Rhode Island | 44007 | 12937 | 747 |
289417 | 289417 | 2020-06-30 | Providence | Rhode Island | 44007 | 12937 | 747 |
292569 | 292569 | 2020-07-01 | Providence | Rhode Island | 44007 | 12937 | 747 |
295725 | 295725 | 2020-07-02 | Providence | Rhode Island | 44007 | 12937 | 747 |
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);