johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
320 rows where confirmed = 2451 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1968056 | 1968056 | 2022-11-30 | US | West Virginia | Doddridge | 54017 | 2451 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-01 04:21:03 | Doddridge, West Virginia, US | |
2558119 | 2558119 | 2022-11-29 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-30 04:21:07 | Red River, Louisiana, US | |
1241193 | 1241193 | 2022-11-28 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-29 04:21:05 | Red River, Louisiana, US | |
3554988 | 3554988 | 2022-11-27 | US | Virginia | Fairfax City | 51600 | 2451 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-28 04:21:02 | Fairfax City, Virginia, US | |
3553181 | 3553181 | 2022-11-27 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-28 04:21:02 | Red River, Louisiana, US | |
2103468 | 2103468 | 2022-11-26 | US | Virginia | Fairfax City | 51600 | 2451 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-27 04:21:05 | Fairfax City, Virginia, US | |
2101661 | 2101661 | 2022-11-26 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-27 04:21:05 | Red River, Louisiana, US | |
490959 | 490959 | 2022-11-25 | US | Virginia | Fairfax City | 51600 | 2451 | 48 | 0 | 38.85157547 | -77.2977964 | 2022-11-26 04:21:11 | Fairfax City, Virginia, US | |
489152 | 489152 | 2022-11-25 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-26 04:21:11 | Red River, Louisiana, US | |
3524981 | 3524981 | 2022-11-24 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-25 04:21:06 | Red River, Louisiana, US | |
3313764 | 3313764 | 2022-11-23 | US | Louisiana | Red River | 22081 | 2451 | 58 | 0 | 32.09530039 | -93.34213308 | 2022-11-24 04:21:09 | Red River, Louisiana, US | |
1831417 | 1831417 | 2022-10-25 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-26 04:22:19 | Anderson, Kansas, US | |
795678 | 795678 | 2022-10-24 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-25 04:21:53 | Anderson, Kansas, US | |
3278133 | 3278133 | 2022-10-23 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-24 04:22:29 | Anderson, Kansas, US | |
2269171 | 2269171 | 2022-10-22 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-23 04:22:46 | Anderson, Kansas, US | |
1593471 | 1593471 | 2022-10-21 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-22 04:22:53 | Anderson, Kansas, US | |
2273187 | 2273187 | 2022-10-20 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-21 04:22:23 | Anderson, Kansas, US | |
199522 | 199522 | 2022-10-19 | US | Kansas | Anderson | 20003 | 2451 | 37 | 0 | 38.21413251 | -95.29272815 | 2022-10-20 04:22:59 | Anderson, Kansas, US | |
2759871 | 2759871 | 2022-10-18 | US | Tennessee | Hancock | 47067 | 2451 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-10-19 04:22:26 | Hancock, Tennessee, US | |
3572395 | 3572395 | 2022-09-19 | US | Mississippi | Claiborne | 28021 | 2451 | 48 | 0 | 31.97061673 | -90.90702196 | 2022-09-20 04:22:48 | Claiborne, Mississippi, US | |
421134 | 421134 | 2022-09-18 | US | Mississippi | Claiborne | 28021 | 2451 | 48 | 0 | 31.97061673 | -90.90702196 | 2022-09-19 04:21:49 | Claiborne, Mississippi, US | |
3375158 | 3375158 | 2022-09-17 | US | Mississippi | Claiborne | 28021 | 2451 | 48 | 0 | 31.97061673 | -90.90702196 | 2022-09-18 04:22:50 | Claiborne, Mississippi, US | |
2357266 | 2357266 | 2022-09-16 | US | Mississippi | Claiborne | 28021 | 2451 | 48 | 0 | 31.97061673 | -90.90702196 | 2022-09-17 04:20:19 | Claiborne, Mississippi, US | |
3988423 | 3988423 | 2022-09-15 | US | Mississippi | Claiborne | 28021 | 2451 | 48 | 0 | 31.97061673 | -90.90702196 | 2022-09-16 04:21:19 | Claiborne, Mississippi, US | |
1890940 | 1890940 | 2022-09-14 | US | Mississippi | Claiborne | 28021 | 2451 | 48 | 0 | 31.97061673 | -90.90702196 | 2022-09-15 04:21:02 | Claiborne, Mississippi, US | |
3827211 | 3827211 | 2022-09-10 | US | Puerto Rico | Las Marias | 72083 | 2451 | 0 | 0 | 18.23679 | -66.98362 | 2022-09-11 04:20:50 | Las Marias, Puerto Rico, US | |
965668 | 965668 | 2022-09-09 | US | Puerto Rico | Las Marias | 72083 | 2451 | 0 | 0 | 18.23679 | -66.98362 | 2022-09-10 04:21:10 | Las Marias, Puerto Rico, US | |
256070 | 256070 | 2022-09-08 | US | Puerto Rico | Las Marias | 72083 | 2451 | 0 | 0 | 18.23679 | -66.98362 | 2022-09-09 04:21:11 | Las Marias, Puerto Rico, US | |
1684021 | 1684021 | 2022-08-29 | US | West Virginia | Tyler | 54095 | 2451 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-08-30 04:21:03 | Tyler, West Virginia, US | |
1251711 | 1251711 | 2022-08-23 | US | Idaho | Owyhee | 16073 | 2451 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-08-24 04:20:46 | Owyhee, Idaho, US | |
2853815 | 2853815 | 2022-08-22 | US | Idaho | Owyhee | 16073 | 2451 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-08-23 04:20:56 | Owyhee, Idaho, US | |
3950968 | 3950968 | 2022-08-17 | US | Arkansas | Cleveland | 5025 | 2451 | 39 | 0 | 33.89723187 | -92.18537045 | 2022-08-18 04:21:11 | Cleveland, Arkansas, US | |
991470 | 991470 | 2022-08-16 | US | Arkansas | Cleveland | 5025 | 2451 | 39 | 0 | 33.89723187 | -92.18537045 | 2022-08-17 04:20:59 | Cleveland, Arkansas, US | |
1408377 | 1408377 | 2022-08-02 | US | Virginia | Essex | 51057 | 2451 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-08-03 04:20:59 | Essex, Virginia, US | |
2422087 | 2422087 | 2022-07-15 | US | Texas | Parmer | 48369 | 2451 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-07-16 04:21:05 | Parmer, Texas, US | |
3432444 | 3432444 | 2022-07-14 | US | West Virginia | Clay | 54015 | 2451 | 47 | 0 | 38.46231092 | -81.07652217 | 2022-07-15 04:20:53 | Clay, West Virginia, US | |
3729120 | 3729120 | 2022-06-07 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-08 04:20:55 | Roberts, South Dakota, US | |
3890522 | 3890522 | 2022-06-06 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-07 04:21:08 | Roberts, South Dakota, US | |
3510291 | 3510291 | 2022-06-05 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-06 04:20:57 | Roberts, South Dakota, US | |
3530368 | 3530368 | 2022-06-04 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-05 04:20:55 | Roberts, South Dakota, US | |
3136454 | 3136454 | 2022-06-03 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-04 04:20:58 | Roberts, South Dakota, US | |
3581529 | 3581529 | 2022-06-02 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-03 04:20:58 | Roberts, South Dakota, US | |
3579593 | 3579593 | 2022-06-02 | US | Illinois | Brown | 17009 | 2451 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-06-03 04:20:58 | Brown, Illinois, US | |
973822 | 973822 | 2022-06-01 | US | South Dakota | Roberts | 46109 | 2451 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-06-02 05:20:39 | Roberts, South Dakota, US | |
973111 | 973111 | 2022-06-01 | US | New Mexico | Colfax | 35007 | 2451 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-06-02 05:20:39 | Colfax, New Mexico, US | |
2087330 | 2087330 | 2022-05-15 | US | Virginia | Madison | 51113 | 2451 | 41 | 0 | 38.41531222 | -78.28220331 | 2022-05-16 04:20:47 | Madison, Virginia, US | |
3358040 | 3358040 | 2022-05-14 | US | Virginia | Madison | 51113 | 2451 | 41 | 0 | 38.41531222 | -78.28220331 | 2022-05-15 04:20:53 | Madison, Virginia, US | |
661685 | 661685 | 2022-05-13 | US | Virginia | Madison | 51113 | 2451 | 41 | 0 | 38.41531222 | -78.28220331 | 2022-05-14 04:20:48 | Madison, Virginia, US | |
661088 | 661088 | 2022-05-13 | US | Puerto Rico | Rincon | 72117 | 2451 | 0 | 0 | 18.335443 | -67.23174 | 2022-05-14 04:20:48 | Rincon, Puerto Rico, US | |
2534677 | 2534677 | 2022-05-12 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-13 04:20:51 | Doniphan, Kansas, US | |
3446123 | 3446123 | 2022-05-11 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-12 04:20:54 | Doniphan, Kansas, US | |
3536740 | 3536740 | 2022-05-10 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-11 04:20:48 | Doniphan, Kansas, US | |
223275 | 223275 | 2022-05-09 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-10 04:20:50 | Doniphan, Kansas, US | |
2332660 | 2332660 | 2022-05-08 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-09 04:20:54 | Doniphan, Kansas, US | |
361622 | 361622 | 2022-05-07 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-08 04:20:49 | Doniphan, Kansas, US | |
1398973 | 1398973 | 2022-05-06 | US | Kansas | Doniphan | 20043 | 2451 | 34 | 0 | 39.79067154 | -95.14056866 | 2022-05-07 04:21:09 | Doniphan, Kansas, US | |
3855330 | 3855330 | 2022-04-27 | US | West Virginia | Ritchie | 54085 | 2451 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-28 04:20:47 | Ritchie, West Virginia, US | |
1329760 | 1329760 | 2022-04-26 | US | West Virginia | Ritchie | 54085 | 2451 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-04-27 04:20:52 | Ritchie, West Virginia, US | |
1327092 | 1327092 | 2022-04-26 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-27 04:20:52 | McIntosh, Georgia, US | |
3723046 | 3723046 | 2022-04-25 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-26 04:20:51 | McIntosh, Georgia, US | |
2029614 | 2029614 | 2022-04-24 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-25 04:20:56 | McIntosh, Georgia, US | |
747189 | 747189 | 2022-04-23 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-24 04:20:56 | McIntosh, Georgia, US | |
3437674 | 3437674 | 2022-04-22 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-23 04:20:50 | McIntosh, Georgia, US | |
2895755 | 2895755 | 2022-04-21 | US | Virginia | Franklin City | 51620 | 2451 | 53 | 0 | 36.6831435 | -76.93859681 | 2022-04-22 04:20:45 | Franklin City, Virginia, US | |
2893259 | 2893259 | 2022-04-21 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-22 04:20:45 | McIntosh, Georgia, US | |
2309241 | 2309241 | 2022-04-20 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-21 04:20:46 | Ralls, Missouri, US | |
2308131 | 2308131 | 2022-04-20 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-21 04:20:46 | McIntosh, Georgia, US | |
2253380 | 2253380 | 2022-04-19 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-20 04:20:45 | Ralls, Missouri, US | |
2252270 | 2252270 | 2022-04-19 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-20 04:20:45 | McIntosh, Georgia, US | |
1847930 | 1847930 | 2022-04-18 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-19 04:21:00 | Ralls, Missouri, US | |
1846820 | 1846820 | 2022-04-18 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-19 04:21:00 | McIntosh, Georgia, US | |
3418874 | 3418874 | 2022-04-17 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-18 04:21:12 | Ralls, Missouri, US | |
3417764 | 3417764 | 2022-04-17 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-18 04:21:12 | McIntosh, Georgia, US | |
305823 | 305823 | 2022-04-16 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-17 04:20:59 | Ralls, Missouri, US | |
304713 | 304713 | 2022-04-16 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-17 04:20:59 | McIntosh, Georgia, US | |
2671768 | 2671768 | 2022-04-15 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-16 04:20:48 | Ralls, Missouri, US | |
2670658 | 2670658 | 2022-04-15 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-16 04:20:48 | McIntosh, Georgia, US | |
1225553 | 1225553 | 2022-04-14 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-15 04:20:57 | Ralls, Missouri, US | |
1224443 | 1224443 | 2022-04-14 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-15 04:20:57 | McIntosh, Georgia, US | |
2444711 | 2444711 | 2022-04-13 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-13 23:21:06 | Ralls, Missouri, US | |
2443601 | 2443601 | 2022-04-13 | US | Georgia | McIntosh | 13191 | 2451 | 37 | 0 | 31.49683595 | -81.40163426 | 2022-04-13 23:21:06 | McIntosh, Georgia, US | |
1950468 | 1950468 | 2022-04-12 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-13 04:21:03 | Ralls, Missouri, US | |
3208221 | 3208221 | 2022-04-11 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-12 04:20:49 | Ralls, Missouri, US | |
1578107 | 1578107 | 2022-04-10 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-11 04:21:02 | Ralls, Missouri, US | |
1654349 | 1654349 | 2022-04-09 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-10 04:20:52 | Ralls, Missouri, US | |
2117671 | 2117671 | 2022-04-08 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-09 04:20:42 | Ralls, Missouri, US | |
3322195 | 3322195 | 2022-04-07 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-08 04:20:48 | Ralls, Missouri, US | |
3868390 | 3868390 | 2022-04-05 | US | Georgia | McIntosh | 13191 | 2451 | 35 | 0 | 31.49683595 | -81.40163426 | 2022-04-06 04:20:49 | McIntosh, Georgia, US | |
2749732 | 2749732 | 2022-04-04 | US | Georgia | McIntosh | 13191 | 2451 | 35 | 0 | 31.49683595 | -81.40163426 | 2022-04-05 04:20:48 | McIntosh, Georgia, US | |
3731078 | 3731078 | 2022-04-03 | US | Georgia | McIntosh | 13191 | 2451 | 35 | 0 | 31.49683595 | -81.40163426 | 2022-04-04 04:20:51 | McIntosh, Georgia, US | |
500513 | 500513 | 2022-04-02 | US | Georgia | McIntosh | 13191 | 2451 | 35 | 0 | 31.49683595 | -81.40163426 | 2022-04-03 04:20:48 | McIntosh, Georgia, US | |
3351498 | 3351498 | 2022-04-01 | US | Georgia | McIntosh | 13191 | 2451 | 35 | 0 | 31.49683595 | -81.40163426 | 2022-04-02 04:20:47 | McIntosh, Georgia, US | |
1439902 | 1439902 | 2022-03-28 | US | Virginia | Charlotte | 51037 | 2451 | 46 | 0 | 37.01909701 | -78.66314092 | 2022-03-29 04:20:46 | Charlotte, Virginia, US | |
1907151 | 1907151 | 2022-03-22 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-22 23:20:51 | Ralls, Missouri, US | |
26355 | 26355 | 2022-03-20 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-21 04:20:50 | Ralls, Missouri, US | |
1658365 | 1658365 | 2022-03-19 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-20 04:20:45 | Ralls, Missouri, US | |
337891 | 337891 | 2022-03-18 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-19 04:20:47 | Ralls, Missouri, US | |
696344 | 696344 | 2022-03-17 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-18 04:20:55 | Ralls, Missouri, US | |
2321287 | 2321287 | 2022-03-16 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-17 04:20:56 | Ralls, Missouri, US | |
1647818 | 1647818 | 2022-03-03 | US | Washington | Pend Oreille | 53051 | 2451 | 32 | 0 | 48.53234021 | -117.2741804 | 2022-03-04 04:21:09 | Pend Oreille, Washington, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);