ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,311 rows where county = "McIntosh" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- North Dakota 779
- Georgia 775
- Oklahoma 757
county 1
- McIntosh · 2,311 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13451 | 13451 | 2020-03-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
15188 | 15188 | 2020-03-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
17024 | 17024 | 2020-03-28 | McIntosh | North Dakota | 38051 | 1 | 0 |
18958 | 18958 | 2020-03-29 | McIntosh | North Dakota | 38051 | 1 | 0 |
20037 | 20037 | 2020-03-30 | McIntosh | Georgia | 13191 | 1 | 0 |
21000 | 21000 | 2020-03-30 | McIntosh | North Dakota | 38051 | 1 | 0 |
22118 | 22118 | 2020-03-31 | McIntosh | Georgia | 13191 | 1 | 0 |
23130 | 23130 | 2020-03-31 | McIntosh | North Dakota | 38051 | 1 | 0 |
24282 | 24282 | 2020-04-01 | McIntosh | Georgia | 13191 | 1 | 0 |
25325 | 25325 | 2020-04-01 | McIntosh | North Dakota | 38051 | 1 | 0 |
26513 | 26513 | 2020-04-02 | McIntosh | Georgia | 13191 | 1 | 0 |
27591 | 27591 | 2020-04-02 | McIntosh | North Dakota | 38051 | 1 | 0 |
28818 | 28818 | 2020-04-03 | McIntosh | Georgia | 13191 | 2 | 0 |
29919 | 29919 | 2020-04-03 | McIntosh | North Dakota | 38051 | 1 | 0 |
31178 | 31178 | 2020-04-04 | McIntosh | Georgia | 13191 | 2 | 0 |
32307 | 32307 | 2020-04-04 | McIntosh | North Dakota | 38051 | 1 | 0 |
33585 | 33585 | 2020-04-05 | McIntosh | Georgia | 13191 | 2 | 0 |
34740 | 34740 | 2020-04-05 | McIntosh | North Dakota | 38051 | 1 | 0 |
36035 | 36035 | 2020-04-06 | McIntosh | Georgia | 13191 | 2 | 0 |
37209 | 37209 | 2020-04-06 | McIntosh | North Dakota | 38051 | 1 | 0 |
38528 | 38528 | 2020-04-07 | McIntosh | Georgia | 13191 | 3 | 0 |
39726 | 39726 | 2020-04-07 | McIntosh | North Dakota | 38051 | 1 | 0 |
41072 | 41072 | 2020-04-08 | McIntosh | Georgia | 13191 | 3 | 0 |
42283 | 42283 | 2020-04-08 | McIntosh | North Dakota | 38051 | 1 | 0 |
43646 | 43646 | 2020-04-09 | McIntosh | Georgia | 13191 | 3 | 0 |
44867 | 44867 | 2020-04-09 | McIntosh | North Dakota | 38051 | 1 | 0 |
46248 | 46248 | 2020-04-10 | McIntosh | Georgia | 13191 | 3 | 0 |
47480 | 47480 | 2020-04-10 | McIntosh | North Dakota | 38051 | 1 | 0 |
48878 | 48878 | 2020-04-11 | McIntosh | Georgia | 13191 | 3 | 0 |
50135 | 50135 | 2020-04-11 | McIntosh | North Dakota | 38051 | 1 | 0 |
51540 | 51540 | 2020-04-12 | McIntosh | Georgia | 13191 | 3 | 0 |
52808 | 52808 | 2020-04-12 | McIntosh | North Dakota | 38051 | 1 | 0 |
54220 | 54220 | 2020-04-13 | McIntosh | Georgia | 13191 | 3 | 0 |
55492 | 55492 | 2020-04-13 | McIntosh | North Dakota | 38051 | 1 | 0 |
56912 | 56912 | 2020-04-14 | McIntosh | Georgia | 13191 | 3 | 0 |
58193 | 58193 | 2020-04-14 | McIntosh | North Dakota | 38051 | 1 | 0 |
59619 | 59619 | 2020-04-15 | McIntosh | Georgia | 13191 | 3 | 0 |
60907 | 60907 | 2020-04-15 | McIntosh | North Dakota | 38051 | 1 | 0 |
62339 | 62339 | 2020-04-16 | McIntosh | Georgia | 13191 | 4 | 0 |
63633 | 63633 | 2020-04-16 | McIntosh | North Dakota | 38051 | 1 | 0 |
65072 | 65072 | 2020-04-17 | McIntosh | Georgia | 13191 | 4 | 0 |
66376 | 66376 | 2020-04-17 | McIntosh | North Dakota | 38051 | 1 | 0 |
66523 | 66523 | 2020-04-17 | McIntosh | Oklahoma | 40091 | 1 | 0 |
67820 | 67820 | 2020-04-18 | McIntosh | Georgia | 13191 | 4 | 0 |
69133 | 69133 | 2020-04-18 | McIntosh | North Dakota | 38051 | 1 | 0 |
69281 | 69281 | 2020-04-18 | McIntosh | Oklahoma | 40091 | 2 | 0 |
70582 | 70582 | 2020-04-19 | McIntosh | Georgia | 13191 | 4 | 0 |
71899 | 71899 | 2020-04-19 | McIntosh | North Dakota | 38051 | 1 | 0 |
72048 | 72048 | 2020-04-19 | McIntosh | Oklahoma | 40091 | 2 | 0 |
73351 | 73351 | 2020-04-20 | McIntosh | Georgia | 13191 | 4 | 0 |
74674 | 74674 | 2020-04-20 | McIntosh | North Dakota | 38051 | 1 | 0 |
74823 | 74823 | 2020-04-20 | McIntosh | Oklahoma | 40091 | 2 | 0 |
76127 | 76127 | 2020-04-21 | McIntosh | Georgia | 13191 | 4 | 0 |
77455 | 77455 | 2020-04-21 | McIntosh | North Dakota | 38051 | 1 | 0 |
77605 | 77605 | 2020-04-21 | McIntosh | Oklahoma | 40091 | 2 | 0 |
78911 | 78911 | 2020-04-22 | McIntosh | Georgia | 13191 | 4 | 0 |
80244 | 80244 | 2020-04-22 | McIntosh | North Dakota | 38051 | 1 | 0 |
80395 | 80395 | 2020-04-22 | McIntosh | Oklahoma | 40091 | 2 | 0 |
81704 | 81704 | 2020-04-23 | McIntosh | Georgia | 13191 | 4 | 0 |
83043 | 83043 | 2020-04-23 | McIntosh | North Dakota | 38051 | 1 | 0 |
83194 | 83194 | 2020-04-23 | McIntosh | Oklahoma | 40091 | 2 | 0 |
84504 | 84504 | 2020-04-24 | McIntosh | Georgia | 13191 | 4 | 0 |
85847 | 85847 | 2020-04-24 | McIntosh | North Dakota | 38051 | 1 | 0 |
85998 | 85998 | 2020-04-24 | McIntosh | Oklahoma | 40091 | 2 | 0 |
87313 | 87313 | 2020-04-25 | McIntosh | Georgia | 13191 | 4 | 0 |
88660 | 88660 | 2020-04-25 | McIntosh | North Dakota | 38051 | 1 | 0 |
88812 | 88812 | 2020-04-25 | McIntosh | Oklahoma | 40091 | 2 | 0 |
90129 | 90129 | 2020-04-26 | McIntosh | Georgia | 13191 | 4 | 0 |
91475 | 91475 | 2020-04-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
91628 | 91628 | 2020-04-26 | McIntosh | Oklahoma | 40091 | 2 | 0 |
92948 | 92948 | 2020-04-27 | McIntosh | Georgia | 13191 | 4 | 0 |
94301 | 94301 | 2020-04-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
94454 | 94454 | 2020-04-27 | McIntosh | Oklahoma | 40091 | 2 | 0 |
95780 | 95780 | 2020-04-28 | McIntosh | Georgia | 13191 | 4 | 0 |
97138 | 97138 | 2020-04-28 | McIntosh | North Dakota | 38051 | 1 | 0 |
97292 | 97292 | 2020-04-28 | McIntosh | Oklahoma | 40091 | 2 | 0 |
98625 | 98625 | 2020-04-29 | McIntosh | Georgia | 13191 | 4 | 0 |
99987 | 99987 | 2020-04-29 | McIntosh | North Dakota | 38051 | 1 | 0 |
100141 | 100141 | 2020-04-29 | McIntosh | Oklahoma | 40091 | 2 | 0 |
101475 | 101475 | 2020-04-30 | McIntosh | Georgia | 13191 | 4 | 0 |
102840 | 102840 | 2020-04-30 | McIntosh | North Dakota | 38051 | 1 | 0 |
102994 | 102994 | 2020-04-30 | McIntosh | Oklahoma | 40091 | 2 | 0 |
104330 | 104330 | 2020-05-01 | McIntosh | Georgia | 13191 | 6 | 0 |
105702 | 105702 | 2020-05-01 | McIntosh | North Dakota | 38051 | 1 | 0 |
105857 | 105857 | 2020-05-01 | McIntosh | Oklahoma | 40091 | 2 | 0 |
107195 | 107195 | 2020-05-02 | McIntosh | Georgia | 13191 | 6 | 0 |
108569 | 108569 | 2020-05-02 | McIntosh | North Dakota | 38051 | 1 | 0 |
108724 | 108724 | 2020-05-02 | McIntosh | Oklahoma | 40091 | 2 | 0 |
110064 | 110064 | 2020-05-03 | McIntosh | Georgia | 13191 | 6 | 0 |
111443 | 111443 | 2020-05-03 | McIntosh | North Dakota | 38051 | 1 | 0 |
111598 | 111598 | 2020-05-03 | McIntosh | Oklahoma | 40091 | 2 | 0 |
112939 | 112939 | 2020-05-04 | McIntosh | Georgia | 13191 | 6 | 0 |
114324 | 114324 | 2020-05-04 | McIntosh | North Dakota | 38051 | 1 | 0 |
114480 | 114480 | 2020-05-04 | McIntosh | Oklahoma | 40091 | 3 | 0 |
115822 | 115822 | 2020-05-05 | McIntosh | Georgia | 13191 | 5 | 0 |
117204 | 117204 | 2020-05-05 | McIntosh | North Dakota | 38051 | 1 | 0 |
117361 | 117361 | 2020-05-05 | McIntosh | Oklahoma | 40091 | 3 | 0 |
118782 | 118782 | 2020-05-06 | McIntosh | Georgia | 13191 | 5 | 0 |
120165 | 120165 | 2020-05-06 | McIntosh | North Dakota | 38051 | 1 | 0 |
120322 | 120322 | 2020-05-06 | McIntosh | Oklahoma | 40091 | 4 | 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);