ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,560 rows where county = "Ripley" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7443 | 7443 | 2020-03-22 | Ripley | Indiana | 18137 | 1 | 0 |
8601 | 8601 | 2020-03-23 | Ripley | Indiana | 18137 | 1 | 0 |
9874 | 9874 | 2020-03-24 | Ripley | Indiana | 18137 | 6 | 0 |
11269 | 11269 | 2020-03-25 | Ripley | Indiana | 18137 | 7 | 0 |
12829 | 12829 | 2020-03-26 | Ripley | Indiana | 18137 | 11 | 0 |
14515 | 14515 | 2020-03-27 | Ripley | Indiana | 18137 | 14 | 0 |
16314 | 16314 | 2020-03-28 | Ripley | Indiana | 18137 | 15 | 0 |
16794 | 16794 | 2020-03-28 | Ripley | Missouri | 29181 | 1 | 0 |
18218 | 18218 | 2020-03-29 | Ripley | Indiana | 18137 | 19 | 0 |
18716 | 18716 | 2020-03-29 | Ripley | Missouri | 29181 | 2 | 0 |
20224 | 20224 | 2020-03-30 | Ripley | Indiana | 18137 | 25 | 0 |
20749 | 20749 | 2020-03-30 | Ripley | Missouri | 29181 | 2 | 0 |
22319 | 22319 | 2020-03-31 | Ripley | Indiana | 18137 | 31 | 1 |
22868 | 22868 | 2020-03-31 | Ripley | Missouri | 29181 | 2 | 0 |
24490 | 24490 | 2020-04-01 | Ripley | Indiana | 18137 | 33 | 1 |
25056 | 25056 | 2020-04-01 | Ripley | Missouri | 29181 | 2 | 0 |
26729 | 26729 | 2020-04-02 | Ripley | Indiana | 18137 | 39 | 1 |
27313 | 27313 | 2020-04-02 | Ripley | Missouri | 29181 | 2 | 0 |
29040 | 29040 | 2020-04-03 | Ripley | Indiana | 18137 | 47 | 1 |
29634 | 29634 | 2020-04-03 | Ripley | Missouri | 29181 | 2 | 0 |
31407 | 31407 | 2020-04-04 | Ripley | Indiana | 18137 | 51 | 2 |
32015 | 32015 | 2020-04-04 | Ripley | Missouri | 29181 | 2 | 0 |
33818 | 33818 | 2020-04-05 | Ripley | Indiana | 18137 | 60 | 2 |
34443 | 34443 | 2020-04-05 | Ripley | Missouri | 29181 | 2 | 0 |
36272 | 36272 | 2020-04-06 | Ripley | Indiana | 18137 | 70 | 2 |
36909 | 36909 | 2020-04-06 | Ripley | Missouri | 29181 | 2 | 0 |
38770 | 38770 | 2020-04-07 | Ripley | Indiana | 18137 | 76 | 2 |
39424 | 39424 | 2020-04-07 | Ripley | Missouri | 29181 | 2 | 0 |
41316 | 41316 | 2020-04-08 | Ripley | Indiana | 18137 | 76 | 3 |
41978 | 41978 | 2020-04-08 | Ripley | Missouri | 29181 | 2 | 0 |
43892 | 43892 | 2020-04-09 | Ripley | Indiana | 18137 | 77 | 3 |
44555 | 44555 | 2020-04-09 | Ripley | Missouri | 29181 | 2 | 0 |
46497 | 46497 | 2020-04-10 | Ripley | Indiana | 18137 | 79 | 3 |
47164 | 47164 | 2020-04-10 | Ripley | Missouri | 29181 | 3 | 0 |
49131 | 49131 | 2020-04-11 | Ripley | Indiana | 18137 | 81 | 3 |
49812 | 49812 | 2020-04-11 | Ripley | Missouri | 29181 | 3 | 0 |
51795 | 51795 | 2020-04-12 | Ripley | Indiana | 18137 | 84 | 3 |
52485 | 52485 | 2020-04-12 | Ripley | Missouri | 29181 | 3 | 0 |
54476 | 54476 | 2020-04-13 | Ripley | Indiana | 18137 | 86 | 3 |
55167 | 55167 | 2020-04-13 | Ripley | Missouri | 29181 | 3 | 0 |
57169 | 57169 | 2020-04-14 | Ripley | Indiana | 18137 | 89 | 3 |
57865 | 57865 | 2020-04-14 | Ripley | Missouri | 29181 | 3 | 0 |
59877 | 59877 | 2020-04-15 | Ripley | Indiana | 18137 | 88 | 3 |
60579 | 60579 | 2020-04-15 | Ripley | Missouri | 29181 | 3 | 0 |
62598 | 62598 | 2020-04-16 | Ripley | Indiana | 18137 | 89 | 3 |
63301 | 63301 | 2020-04-16 | Ripley | Missouri | 29181 | 3 | 0 |
65332 | 65332 | 2020-04-17 | Ripley | Indiana | 18137 | 77 | 3 |
66041 | 66041 | 2020-04-17 | Ripley | Missouri | 29181 | 3 | 0 |
68081 | 68081 | 2020-04-18 | Ripley | Indiana | 18137 | 80 | 3 |
68795 | 68795 | 2020-04-18 | Ripley | Missouri | 29181 | 4 | 0 |
70843 | 70843 | 2020-04-19 | Ripley | Indiana | 18137 | 82 | 3 |
71562 | 71562 | 2020-04-19 | Ripley | Missouri | 29181 | 3 | 0 |
73614 | 73614 | 2020-04-20 | Ripley | Indiana | 18137 | 82 | 3 |
74335 | 74335 | 2020-04-20 | Ripley | Missouri | 29181 | 3 | 0 |
76391 | 76391 | 2020-04-21 | Ripley | Indiana | 18137 | 83 | 3 |
77116 | 77116 | 2020-04-21 | Ripley | Missouri | 29181 | 3 | 0 |
79175 | 79175 | 2020-04-22 | Ripley | Indiana | 18137 | 86 | 3 |
79903 | 79903 | 2020-04-22 | Ripley | Missouri | 29181 | 4 | 0 |
81968 | 81968 | 2020-04-23 | Ripley | Indiana | 18137 | 87 | 5 |
82699 | 82699 | 2020-04-23 | Ripley | Missouri | 29181 | 4 | 0 |
84768 | 84768 | 2020-04-24 | Ripley | Indiana | 18137 | 87 | 5 |
85503 | 85503 | 2020-04-24 | Ripley | Missouri | 29181 | 4 | 0 |
87578 | 87578 | 2020-04-25 | Ripley | Indiana | 18137 | 89 | 5 |
88313 | 88313 | 2020-04-25 | Ripley | Missouri | 29181 | 5 | 0 |
90394 | 90394 | 2020-04-26 | Ripley | Indiana | 18137 | 89 | 5 |
91129 | 91129 | 2020-04-26 | Ripley | Missouri | 29181 | 5 | 0 |
93213 | 93213 | 2020-04-27 | Ripley | Indiana | 18137 | 90 | 5 |
93950 | 93950 | 2020-04-27 | Ripley | Missouri | 29181 | 5 | 0 |
96045 | 96045 | 2020-04-28 | Ripley | Indiana | 18137 | 91 | 5 |
96786 | 96786 | 2020-04-28 | Ripley | Missouri | 29181 | 5 | 0 |
98889 | 98889 | 2020-04-29 | Ripley | Indiana | 18137 | 92 | 5 |
99632 | 99632 | 2020-04-29 | Ripley | Missouri | 29181 | 5 | 0 |
101740 | 101740 | 2020-04-30 | Ripley | Indiana | 18137 | 92 | 5 |
102484 | 102484 | 2020-04-30 | Ripley | Missouri | 29181 | 5 | 0 |
104596 | 104596 | 2020-05-01 | Ripley | Indiana | 18137 | 93 | 5 |
105345 | 105345 | 2020-05-01 | Ripley | Missouri | 29181 | 5 | 0 |
107461 | 107461 | 2020-05-02 | Ripley | Indiana | 18137 | 94 | 6 |
108210 | 108210 | 2020-05-02 | Ripley | Missouri | 29181 | 5 | 0 |
110331 | 110331 | 2020-05-03 | Ripley | Indiana | 18137 | 94 | 6 |
111082 | 111082 | 2020-05-03 | Ripley | Missouri | 29181 | 5 | 0 |
113206 | 113206 | 2020-05-04 | Ripley | Indiana | 18137 | 97 | 6 |
113961 | 113961 | 2020-05-04 | Ripley | Missouri | 29181 | 5 | 0 |
116089 | 116089 | 2020-05-05 | Ripley | Indiana | 18137 | 98 | 6 |
116843 | 116843 | 2020-05-05 | Ripley | Missouri | 29181 | 5 | 0 |
119049 | 119049 | 2020-05-06 | Ripley | Indiana | 18137 | 99 | 6 |
119803 | 119803 | 2020-05-06 | Ripley | Missouri | 29181 | 5 | 0 |
122019 | 122019 | 2020-05-07 | Ripley | Indiana | 18137 | 98 | 6 |
122777 | 122777 | 2020-05-07 | Ripley | Missouri | 29181 | 5 | 0 |
124999 | 124999 | 2020-05-08 | Ripley | Indiana | 18137 | 98 | 6 |
125759 | 125759 | 2020-05-08 | Ripley | Missouri | 29181 | 5 | 0 |
127986 | 127986 | 2020-05-09 | Ripley | Indiana | 18137 | 98 | 6 |
128747 | 128747 | 2020-05-09 | Ripley | Missouri | 29181 | 5 | 0 |
130977 | 130977 | 2020-05-10 | Ripley | Indiana | 18137 | 101 | 6 |
131737 | 131737 | 2020-05-10 | Ripley | Missouri | 29181 | 5 | 0 |
133967 | 133967 | 2020-05-11 | Ripley | Indiana | 18137 | 101 | 6 |
134728 | 134728 | 2020-05-11 | Ripley | Missouri | 29181 | 5 | 0 |
136956 | 136956 | 2020-05-12 | Ripley | Indiana | 18137 | 104 | 6 |
137718 | 137718 | 2020-05-12 | Ripley | Missouri | 29181 | 5 | 0 |
139948 | 139948 | 2020-05-13 | Ripley | Indiana | 18137 | 105 | 6 |
140712 | 140712 | 2020-05-13 | Ripley | Missouri | 29181 | 5 | 0 |
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);