ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Washington" and state = "Rhode Island" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12004 | 12004 | 2020-03-25 | Washington | Rhode Island | 44009 | 9 | 0 |
13626 | 13626 | 2020-03-26 | Washington | Rhode Island | 44009 | 9 | 0 |
15373 | 15373 | 2020-03-27 | Washington | Rhode Island | 44009 | 9 | 0 |
17227 | 17227 | 2020-03-28 | Washington | Rhode Island | 44009 | 9 | 0 |
19167 | 19167 | 2020-03-29 | Washington | Rhode Island | 44009 | 21 | 0 |
21218 | 21218 | 2020-03-30 | Washington | Rhode Island | 44009 | 28 | 0 |
23355 | 23355 | 2020-03-31 | Washington | Rhode Island | 44009 | 29 | 0 |
25552 | 25552 | 2020-04-01 | Washington | Rhode Island | 44009 | 32 | 0 |
27825 | 27825 | 2020-04-02 | Washington | Rhode Island | 44009 | 34 | 0 |
30160 | 30160 | 2020-04-03 | Washington | Rhode Island | 44009 | 34 | 0 |
32551 | 32551 | 2020-04-04 | Washington | Rhode Island | 44009 | 48 | 0 |
34987 | 34987 | 2020-04-05 | Washington | Rhode Island | 44009 | 53 | 0 |
37462 | 37462 | 2020-04-06 | Washington | Rhode Island | 44009 | 53 | 0 |
39985 | 39985 | 2020-04-07 | Washington | Rhode Island | 44009 | 80 | 0 |
42545 | 42545 | 2020-04-08 | Washington | Rhode Island | 44009 | 97 | 0 |
45131 | 45131 | 2020-04-09 | Washington | Rhode Island | 44009 | 100 | 0 |
47748 | 47748 | 2020-04-10 | Washington | Rhode Island | 44009 | 100 | 0 |
50405 | 50405 | 2020-04-11 | Washington | Rhode Island | 44009 | 116 | 0 |
53078 | 53078 | 2020-04-12 | Washington | Rhode Island | 44009 | 116 | 0 |
55763 | 55763 | 2020-04-13 | Washington | Rhode Island | 44009 | 116 | 0 |
58466 | 58466 | 2020-04-14 | Washington | Rhode Island | 44009 | 152 | 0 |
61181 | 61181 | 2020-04-15 | Washington | Rhode Island | 44009 | 152 | 0 |
63907 | 63907 | 2020-04-16 | Washington | Rhode Island | 44009 | 171 | 0 |
66653 | 66653 | 2020-04-17 | Washington | Rhode Island | 44009 | 183 | 0 |
69411 | 69411 | 2020-04-18 | Washington | Rhode Island | 44009 | 184 | 0 |
72178 | 72178 | 2020-04-19 | Washington | Rhode Island | 44009 | 188 | 0 |
74953 | 74953 | 2020-04-20 | Washington | Rhode Island | 44009 | 198 | 0 |
77735 | 77735 | 2020-04-21 | Washington | Rhode Island | 44009 | 209 | 0 |
80525 | 80525 | 2020-04-22 | Washington | Rhode Island | 44009 | 209 | 0 |
83324 | 83324 | 2020-04-23 | Washington | Rhode Island | 44009 | 209 | 0 |
86128 | 86128 | 2020-04-24 | Washington | Rhode Island | 44009 | 272 | 0 |
88942 | 88942 | 2020-04-25 | Washington | Rhode Island | 44009 | 282 | 6 |
91758 | 91758 | 2020-04-26 | Washington | Rhode Island | 44009 | 292 | 6 |
94585 | 94585 | 2020-04-27 | Washington | Rhode Island | 44009 | 292 | 6 |
97424 | 97424 | 2020-04-28 | Washington | Rhode Island | 44009 | 313 | 6 |
100273 | 100273 | 2020-04-29 | Washington | Rhode Island | 44009 | 324 | 11 |
103126 | 103126 | 2020-04-30 | Washington | Rhode Island | 44009 | 330 | 11 |
105989 | 105989 | 2020-05-01 | Washington | Rhode Island | 44009 | 344 | 11 |
108856 | 108856 | 2020-05-02 | Washington | Rhode Island | 44009 | 350 | 11 |
111730 | 111730 | 2020-05-03 | Washington | Rhode Island | 44009 | 356 | 25 |
114612 | 114612 | 2020-05-04 | Washington | Rhode Island | 44009 | 363 | 25 |
117568 | 117568 | 2020-05-05 | Washington | Rhode Island | 44009 | 363 | 25 |
120530 | 120530 | 2020-05-06 | Washington | Rhode Island | 44009 | 363 | 25 |
123508 | 123508 | 2020-05-07 | Washington | Rhode Island | 44009 | 363 | 25 |
126491 | 126491 | 2020-05-08 | Washington | Rhode Island | 44009 | 363 | 25 |
129480 | 129480 | 2020-05-09 | Washington | Rhode Island | 44009 | 363 | 25 |
132469 | 132469 | 2020-05-10 | Washington | Rhode Island | 44009 | 363 | 25 |
135460 | 135460 | 2020-05-11 | Washington | Rhode Island | 44009 | 406 | 32 |
138450 | 138450 | 2020-05-12 | Washington | Rhode Island | 44009 | 411 | 32 |
141446 | 141446 | 2020-05-13 | Washington | Rhode Island | 44009 | 425 | 32 |
144442 | 144442 | 2020-05-14 | Washington | Rhode Island | 44009 | 425 | 32 |
147443 | 147443 | 2020-05-15 | Washington | Rhode Island | 44009 | 425 | 32 |
150451 | 150451 | 2020-05-16 | Washington | Rhode Island | 44009 | 425 | 32 |
153462 | 153462 | 2020-05-17 | Washington | Rhode Island | 44009 | 425 | 32 |
156479 | 156479 | 2020-05-18 | Washington | Rhode Island | 44009 | 425 | 32 |
159500 | 159500 | 2020-05-19 | Washington | Rhode Island | 44009 | 425 | 32 |
162527 | 162527 | 2020-05-20 | Washington | Rhode Island | 44009 | 462 | 32 |
165556 | 165556 | 2020-05-21 | Washington | Rhode Island | 44009 | 471 | 32 |
168592 | 168592 | 2020-05-22 | Washington | Rhode Island | 44009 | 482 | 32 |
171631 | 171631 | 2020-05-23 | Washington | Rhode Island | 44009 | 485 | 32 |
174673 | 174673 | 2020-05-24 | Washington | Rhode Island | 44009 | 486 | 32 |
177717 | 177717 | 2020-05-25 | Washington | Rhode Island | 44009 | 486 | 32 |
180760 | 180760 | 2020-05-26 | Washington | Rhode Island | 44009 | 486 | 32 |
183810 | 183810 | 2020-05-27 | Washington | Rhode Island | 44009 | 493 | 51 |
186867 | 186867 | 2020-05-28 | Washington | Rhode Island | 44009 | 496 | 51 |
189929 | 189929 | 2020-05-29 | Washington | Rhode Island | 44009 | 499 | 51 |
192994 | 192994 | 2020-05-30 | Washington | Rhode Island | 44009 | 499 | 51 |
196063 | 196063 | 2020-05-31 | Washington | Rhode Island | 44009 | 499 | 51 |
199136 | 199136 | 2020-06-01 | Washington | Rhode Island | 44009 | 499 | 51 |
202211 | 202211 | 2020-06-02 | Washington | Rhode Island | 44009 | 499 | 51 |
205288 | 205288 | 2020-06-03 | Washington | Rhode Island | 44009 | 499 | 51 |
208369 | 208369 | 2020-06-04 | Washington | Rhode Island | 44009 | 499 | 51 |
211451 | 211451 | 2020-06-05 | Washington | Rhode Island | 44009 | 499 | 51 |
214537 | 214537 | 2020-06-06 | Washington | Rhode Island | 44009 | 499 | 51 |
217627 | 217627 | 2020-06-07 | Washington | Rhode Island | 44009 | 499 | 51 |
220719 | 220719 | 2020-06-08 | Washington | Rhode Island | 44009 | 513 | 61 |
223814 | 223814 | 2020-06-09 | Washington | Rhode Island | 44009 | 513 | 61 |
226914 | 226914 | 2020-06-10 | Washington | Rhode Island | 44009 | 513 | 61 |
230018 | 230018 | 2020-06-11 | Washington | Rhode Island | 44009 | 513 | 61 |
233123 | 233123 | 2020-06-12 | Washington | Rhode Island | 44009 | 513 | 61 |
236228 | 236228 | 2020-06-13 | Washington | Rhode Island | 44009 | 513 | 61 |
239336 | 239336 | 2020-06-14 | Washington | Rhode Island | 44009 | 513 | 61 |
242445 | 242445 | 2020-06-15 | Washington | Rhode Island | 44009 | 516 | 61 |
245557 | 245557 | 2020-06-16 | Washington | Rhode Island | 44009 | 516 | 61 |
248670 | 248670 | 2020-06-17 | Washington | Rhode Island | 44009 | 516 | 61 |
251785 | 251785 | 2020-06-18 | Washington | Rhode Island | 44009 | 516 | 61 |
254900 | 254900 | 2020-06-19 | Washington | Rhode Island | 44009 | 516 | 61 |
258026 | 258026 | 2020-06-20 | Washington | Rhode Island | 44009 | 516 | 61 |
261153 | 261153 | 2020-06-21 | Washington | Rhode Island | 44009 | 516 | 61 |
264281 | 264281 | 2020-06-22 | Washington | Rhode Island | 44009 | 523 | 61 |
267409 | 267409 | 2020-06-23 | Washington | Rhode Island | 44009 | 523 | 61 |
270543 | 270543 | 2020-06-24 | Washington | Rhode Island | 44009 | 523 | 61 |
273682 | 273682 | 2020-06-25 | Washington | Rhode Island | 44009 | 523 | 61 |
276829 | 276829 | 2020-06-26 | Washington | Rhode Island | 44009 | 523 | 63 |
279977 | 279977 | 2020-06-27 | Washington | Rhode Island | 44009 | 523 | 63 |
283123 | 283123 | 2020-06-28 | Washington | Rhode Island | 44009 | 523 | 63 |
286268 | 286268 | 2020-06-29 | Washington | Rhode Island | 44009 | 532 | 63 |
289419 | 289419 | 2020-06-30 | Washington | Rhode Island | 44009 | 532 | 63 |
292571 | 292571 | 2020-07-01 | Washington | Rhode Island | 44009 | 532 | 63 |
295727 | 295727 | 2020-07-02 | Washington | Rhode Island | 44009 | 532 | 63 |
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);