ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 30111 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1786 | 1786 | 2020-03-13 | Yellowstone | Montana | 30111 | 1 | 0 |
2132 | 2132 | 2020-03-14 | Yellowstone | Montana | 30111 | 1 | 0 |
2539 | 2539 | 2020-03-15 | Yellowstone | Montana | 30111 | 1 | 0 |
2994 | 2994 | 2020-03-16 | Yellowstone | Montana | 30111 | 3 | 0 |
3504 | 3504 | 2020-03-17 | Yellowstone | Montana | 30111 | 3 | 0 |
4095 | 4095 | 2020-03-18 | Yellowstone | Montana | 30111 | 5 | 0 |
4818 | 4818 | 2020-03-19 | Yellowstone | Montana | 30111 | 5 | 0 |
5657 | 5657 | 2020-03-20 | Yellowstone | Montana | 30111 | 5 | 0 |
6649 | 6649 | 2020-03-21 | Yellowstone | Montana | 30111 | 5 | 0 |
7738 | 7738 | 2020-03-22 | Yellowstone | Montana | 30111 | 6 | 0 |
8931 | 8931 | 2020-03-23 | Yellowstone | Montana | 30111 | 7 | 0 |
10234 | 10234 | 2020-03-24 | Yellowstone | Montana | 30111 | 8 | 0 |
11664 | 11664 | 2020-03-25 | Yellowstone | Montana | 30111 | 12 | 0 |
13265 | 13265 | 2020-03-26 | Yellowstone | Montana | 30111 | 14 | 0 |
14997 | 14997 | 2020-03-27 | Yellowstone | Montana | 30111 | 23 | 0 |
16823 | 16823 | 2020-03-28 | Yellowstone | Montana | 30111 | 26 | 0 |
18746 | 18746 | 2020-03-29 | Yellowstone | Montana | 30111 | 26 | 0 |
20781 | 20781 | 2020-03-30 | Yellowstone | Montana | 30111 | 28 | 0 |
22904 | 22904 | 2020-03-31 | Yellowstone | Montana | 30111 | 31 | 0 |
25093 | 25093 | 2020-04-01 | Yellowstone | Montana | 30111 | 32 | 0 |
27349 | 27349 | 2020-04-02 | Yellowstone | Montana | 30111 | 35 | 0 |
29672 | 29672 | 2020-04-03 | Yellowstone | Montana | 30111 | 38 | 0 |
32054 | 32054 | 2020-04-04 | Yellowstone | Montana | 30111 | 38 | 0 |
34482 | 34482 | 2020-04-05 | Yellowstone | Montana | 30111 | 40 | 0 |
36949 | 36949 | 2020-04-06 | Yellowstone | Montana | 30111 | 47 | 0 |
39465 | 39465 | 2020-04-07 | Yellowstone | Montana | 30111 | 47 | 0 |
42021 | 42021 | 2020-04-08 | Yellowstone | Montana | 30111 | 48 | 0 |
44601 | 44601 | 2020-04-09 | Yellowstone | Montana | 30111 | 52 | 0 |
47211 | 47211 | 2020-04-10 | Yellowstone | Montana | 30111 | 55 | 0 |
49860 | 49860 | 2020-04-11 | Yellowstone | Montana | 30111 | 57 | 0 |
52533 | 52533 | 2020-04-12 | Yellowstone | Montana | 30111 | 58 | 0 |
55214 | 55214 | 2020-04-13 | Yellowstone | Montana | 30111 | 59 | 0 |
57913 | 57913 | 2020-04-14 | Yellowstone | Montana | 30111 | 63 | 0 |
60627 | 60627 | 2020-04-15 | Yellowstone | Montana | 30111 | 64 | 0 |
63350 | 63350 | 2020-04-16 | Yellowstone | Montana | 30111 | 67 | 0 |
66090 | 66090 | 2020-04-17 | Yellowstone | Montana | 30111 | 67 | 0 |
68844 | 68844 | 2020-04-18 | Yellowstone | Montana | 30111 | 70 | 1 |
71611 | 71611 | 2020-04-19 | Yellowstone | Montana | 30111 | 72 | 1 |
74384 | 74384 | 2020-04-20 | Yellowstone | Montana | 30111 | 72 | 1 |
77164 | 77164 | 2020-04-21 | Yellowstone | Montana | 30111 | 73 | 1 |
79952 | 79952 | 2020-04-22 | Yellowstone | Montana | 30111 | 74 | 1 |
82748 | 82748 | 2020-04-23 | Yellowstone | Montana | 30111 | 76 | 1 |
85553 | 85553 | 2020-04-24 | Yellowstone | Montana | 30111 | 77 | 1 |
88363 | 88363 | 2020-04-25 | Yellowstone | Montana | 30111 | 77 | 1 |
91178 | 91178 | 2020-04-26 | Yellowstone | Montana | 30111 | 78 | 1 |
93999 | 93999 | 2020-04-27 | Yellowstone | Montana | 30111 | 79 | 1 |
96835 | 96835 | 2020-04-28 | Yellowstone | Montana | 30111 | 80 | 1 |
99681 | 99681 | 2020-04-29 | Yellowstone | Montana | 30111 | 80 | 2 |
102533 | 102533 | 2020-04-30 | Yellowstone | Montana | 30111 | 80 | 2 |
105394 | 105394 | 2020-05-01 | Yellowstone | Montana | 30111 | 80 | 2 |
108260 | 108260 | 2020-05-02 | Yellowstone | Montana | 30111 | 82 | 2 |
111132 | 111132 | 2020-05-03 | Yellowstone | Montana | 30111 | 82 | 2 |
114011 | 114011 | 2020-05-04 | Yellowstone | Montana | 30111 | 83 | 2 |
116893 | 116893 | 2020-05-05 | Yellowstone | Montana | 30111 | 83 | 2 |
119853 | 119853 | 2020-05-06 | Yellowstone | Montana | 30111 | 83 | 2 |
122827 | 122827 | 2020-05-07 | Yellowstone | Montana | 30111 | 83 | 2 |
125809 | 125809 | 2020-05-08 | Yellowstone | Montana | 30111 | 83 | 2 |
128797 | 128797 | 2020-05-09 | Yellowstone | Montana | 30111 | 82 | 2 |
131787 | 131787 | 2020-05-10 | Yellowstone | Montana | 30111 | 82 | 2 |
134778 | 134778 | 2020-05-11 | Yellowstone | Montana | 30111 | 82 | 2 |
137768 | 137768 | 2020-05-12 | Yellowstone | Montana | 30111 | 82 | 2 |
140762 | 140762 | 2020-05-13 | Yellowstone | Montana | 30111 | 83 | 2 |
143757 | 143757 | 2020-05-14 | Yellowstone | Montana | 30111 | 83 | 2 |
146758 | 146758 | 2020-05-15 | Yellowstone | Montana | 30111 | 83 | 2 |
149764 | 149764 | 2020-05-16 | Yellowstone | Montana | 30111 | 85 | 2 |
152775 | 152775 | 2020-05-17 | Yellowstone | Montana | 30111 | 85 | 2 |
155789 | 155789 | 2020-05-18 | Yellowstone | Montana | 30111 | 86 | 2 |
158807 | 158807 | 2020-05-19 | Yellowstone | Montana | 30111 | 87 | 2 |
161833 | 161833 | 2020-05-20 | Yellowstone | Montana | 30111 | 87 | 2 |
164862 | 164862 | 2020-05-21 | Yellowstone | Montana | 30111 | 88 | 2 |
167898 | 167898 | 2020-05-22 | Yellowstone | Montana | 30111 | 88 | 2 |
170937 | 170937 | 2020-05-23 | Yellowstone | Montana | 30111 | 88 | 2 |
173979 | 173979 | 2020-05-24 | Yellowstone | Montana | 30111 | 88 | 2 |
177022 | 177022 | 2020-05-25 | Yellowstone | Montana | 30111 | 88 | 2 |
180066 | 180066 | 2020-05-26 | Yellowstone | Montana | 30111 | 88 | 3 |
183114 | 183114 | 2020-05-27 | Yellowstone | Montana | 30111 | 89 | 3 |
186170 | 186170 | 2020-05-28 | Yellowstone | Montana | 30111 | 90 | 3 |
189229 | 189229 | 2020-05-29 | Yellowstone | Montana | 30111 | 90 | 3 |
192293 | 192293 | 2020-05-30 | Yellowstone | Montana | 30111 | 91 | 3 |
195363 | 195363 | 2020-05-31 | Yellowstone | Montana | 30111 | 99 | 3 |
198434 | 198434 | 2020-06-01 | Yellowstone | Montana | 30111 | 100 | 3 |
201508 | 201508 | 2020-06-02 | Yellowstone | Montana | 30111 | 100 | 3 |
204585 | 204585 | 2020-06-03 | Yellowstone | Montana | 30111 | 102 | 3 |
207666 | 207666 | 2020-06-04 | Yellowstone | Montana | 30111 | 103 | 3 |
210747 | 210747 | 2020-06-05 | Yellowstone | Montana | 30111 | 103 | 3 |
213831 | 213831 | 2020-06-06 | Yellowstone | Montana | 30111 | 104 | 3 |
216920 | 216920 | 2020-06-07 | Yellowstone | Montana | 30111 | 105 | 3 |
220012 | 220012 | 2020-06-08 | Yellowstone | Montana | 30111 | 105 | 3 |
223107 | 223107 | 2020-06-09 | Yellowstone | Montana | 30111 | 105 | 3 |
226206 | 226206 | 2020-06-10 | Yellowstone | Montana | 30111 | 105 | 3 |
229309 | 229309 | 2020-06-11 | Yellowstone | Montana | 30111 | 106 | 3 |
232414 | 232414 | 2020-06-12 | Yellowstone | Montana | 30111 | 106 | 3 |
235520 | 235520 | 2020-06-13 | Yellowstone | Montana | 30111 | 108 | 3 |
238627 | 238627 | 2020-06-14 | Yellowstone | Montana | 30111 | 108 | 3 |
241737 | 241737 | 2020-06-15 | Yellowstone | Montana | 30111 | 108 | 3 |
244848 | 244848 | 2020-06-16 | Yellowstone | Montana | 30111 | 109 | 3 |
247961 | 247961 | 2020-06-17 | Yellowstone | Montana | 30111 | 109 | 3 |
251076 | 251076 | 2020-06-18 | Yellowstone | Montana | 30111 | 112 | 3 |
254191 | 254191 | 2020-06-19 | Yellowstone | Montana | 30111 | 115 | 3 |
257314 | 257314 | 2020-06-20 | Yellowstone | Montana | 30111 | 120 | 3 |
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);