home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,256 rows where station_code = "DE000R" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
9610720 9610720 20260404211745_Q6Lxu DE000R 2026-04-06T12:10:51.195Z 2026-04-06T12:16:14.642Z
9610674 9610674 20260404210924_daBS3 DE000R 2026-04-06T12:10:40.198Z 2026-04-06T12:16:14.632Z
9604974 9604974 20260402022201_LBsKX DE000R 2026-04-03T12:12:29.139Z 2026-04-06T12:26:36.279Z
9604969 9604969 20260402022057_0Z2NY DE000R 2026-04-03T12:12:28.081Z 2026-04-06T12:26:35.779Z
9604960 9604960 20260402021917_6Kmh4 DE000R 2026-04-03T12:12:26.442Z 2026-04-06T12:26:35.076Z
9598692 9598692 20260331025449_s3kAd DE000R 2026-04-01T12:00:34.661Z 2026-04-06T12:26:47.474Z
9592772 9592772 20260329032013_8wIfZ DE000R 2026-03-30T12:01:54.482Z 2026-04-06T12:34:27.828Z
9585721 9585721 20260327021503_EKIEq DE000R 2026-03-28T12:01:06.832Z 2026-04-05T12:32:36.230Z
9585720 9585720 20260327021503_2lW8N DE000R 2026-03-28T12:01:06.446Z 2026-04-05T12:32:36.132Z
9585675 9585675 20260327020524_HBIAJ DE000R 2026-03-28T12:00:59.085Z 2026-04-05T12:32:34.202Z
9571782 9571782 20260324040740_it9oO DE000R 2026-03-25T12:02:40.344Z 2026-04-02T12:34:48.350Z
9571697 9571697 20260324033736_j7dW0 DE000R 2026-03-25T12:02:23.855Z 2026-04-02T12:34:39.730Z
9570817 9570817 20260322225509_mdnMc DE000R 2026-03-24T12:23:51.723Z 2026-03-30T12:30:49.934Z
9562304 9562304 20260323020532_m2yXt DE000R 2026-03-24T12:02:46.609Z 2026-03-31T12:26:07.215Z
9534284 9534284 20260320034003_Y8VCr DE000R 2026-03-21T12:07:37.519Z 2026-03-28T12:34:17.020Z
9521480 9521480 20260319041913_5WqW9 DE000R 2026-03-20T12:08:04.309Z 2026-03-27T12:40:55.141Z
9511538 9511538 20260318040003_09nNz DE000R 2026-03-19T12:10:25.066Z 2026-03-26T12:37:37.749Z
9511216 9511216 20260318034027_uU4Rs DE000R 2026-03-19T12:09:41.838Z 2026-03-26T12:37:29.474Z
9511210 9511210 20260318034025_37JQH DE000R 2026-03-19T12:09:41.691Z 2026-03-26T12:37:29.420Z
9510586 9510586 20260318030019_x1waK DE000R 2026-03-19T12:08:02.266Z 2026-03-26T12:37:14.541Z
9510284 9510284 20260318024217_c1zAO DE000R 2026-03-19T12:07:16.774Z 2026-03-26T12:37:11.325Z
9509738 9509738 20260318021147_J4RNB DE000R 2026-03-19T12:06:04.109Z 2026-03-26T12:37:07.500Z
9508124 9508124 20260318002004_vRARQ DE000R 2026-03-19T12:02:18.908Z 2026-03-26T12:36:56.038Z
9474283 9474283 20260312221915_VNJ3V DE000R 2026-03-14T12:22:28.759Z 2026-03-20T12:37:17.272Z
9474004 9474004 20260312191749_ZdzNi DE000R 2026-03-14T12:21:42.993Z 2026-03-20T12:37:14.484Z
9469892 9469892 20260313035807_DZgL8 DE000R 2026-03-14T12:05:51.796Z 2026-03-21T12:49:03.796Z
9469820 9469820 20260313034726_MIXh1 DE000R 2026-03-14T12:05:39.333Z 2026-03-21T12:49:02.674Z
9469724 9469724 20260313033402_OGcmn DE000R 2026-03-14T12:05:19.103Z 2026-03-21T12:49:01.422Z
9469669 9469669 20260313032631_iyCiE DE000R 2026-03-14T12:05:08.887Z 2026-03-21T12:48:58.363Z
9469440 9469440 20260313024852_tcRQI DE000R 2026-03-14T12:04:15.962Z 2026-03-21T12:48:39.181Z
9469193 9469193 20260313021102_Csz3Z DE000R 2026-03-14T12:03:21.224Z 2026-03-21T12:48:34.743Z
9469039 9469039 20260313013425_s2AGr DE000R 2026-03-14T12:02:44.181Z 2026-03-21T12:48:32.784Z
9464311 9464311 20260312042215_Sc5ni DE000R 2026-03-13T12:06:54.168Z 2026-03-20T12:36:37.219Z
9464278 9464278 20260312040811_roYHD DE000R 2026-03-13T12:06:46.494Z 2026-03-20T12:36:35.645Z
9464062 9464062 20260312032743_2z4sG DE000R 2026-03-13T12:06:07.628Z 2026-03-20T12:36:28.690Z
9463985 9463985 20260312031404_FEsZK DE000R 2026-03-13T12:05:48.561Z 2026-03-20T12:36:26.143Z
9463980 9463980 20260312031230_xIJCA DE000R 2026-03-13T12:05:47.262Z 2026-03-20T12:36:26.116Z
9456839 9456839 20260311011528_zx3US DE000R 2026-03-12T12:01:55.844Z 2026-03-19T12:44:22.659Z
9456827 9456827 20260311011109_uDcVX DE000R 2026-03-12T12:01:53.697Z 2026-03-19T12:44:22.497Z
9442672 9442672 20260308045115_uYV52 DE000R 2026-03-09T12:04:56.711Z 2026-03-16T12:43:54.822Z
9426722 9426722 20260305042935_cOGZK DE000R 2026-03-06T14:06:04.008Z 2026-03-13T12:34:50.154Z
9420382 9420382 20260302190613_2K1HV DE000R 2026-03-04T14:04:42.454Z 2026-03-10T12:36:49.612Z
9419418 9419418 20260303033713_pTStF DE000R 2026-03-04T14:01:23.304Z 2026-03-11T12:28:00.123Z
9415842 9415842 20260302042834_LIwOh DE000R 2026-03-03T14:01:48.526Z 2026-03-10T12:35:51.753Z
9415837 9415837 20260302042342_GoE32 DE000R 2026-03-03T14:01:47.167Z 2026-03-10T12:35:51.595Z
9415569 9415569 20260302013437_Oe2lR DE000R 2026-03-03T14:00:42.846Z 2026-03-10T12:35:44.318Z
9415483 9415483 20260301231717_X3E5X DE000R 2026-03-03T14:00:20.430Z 2026-03-10T12:35:42.483Z
9415374 9415374 20260228222927_gU1vC DE000R 2026-03-02T14:07:48.744Z 2026-03-08T12:43:11.518Z
9412596 9412596 20260301041843_XSfrA DE000R 2026-03-02T14:01:43.936Z 2026-03-09T12:39:44.394Z
9402744 9402744 20260227042912_N2Fte DE000R 2026-02-28T14:05:53.639Z 2026-03-07T14:47:02.383Z
9402643 9402643 20260227041322_HBh6v DE000R 2026-02-28T14:05:28.079Z 2026-03-07T14:46:55.536Z
9351916 9351916 20260218001216_p2L41 DE000R 2026-02-20T14:02:46.728Z 2026-02-26T14:40:14.519Z
9313739 9313739 20260210003322_wjy9S DE000R 2026-02-11T14:18:35.293Z 2026-02-18T15:02:21.806Z
9311454 9311454 20260208215839_c5xMQ DE000R 2026-02-10T14:23:51.756Z 2026-02-16T14:54:47.626Z
9306113 9306113 20260207204629_NA0nC DE000R 2026-02-09T14:22:25.087Z 2026-02-16T14:59:53.495Z
9217709 9217709 20260116191704_ii2UC DE000R 2026-01-18T14:08:37.921Z 2026-01-25T14:57:45.064Z
9123557 9123557 20251231020423_4vlJr DE000R 2026-01-02T14:30:59.197Z 2026-01-08T15:07:18.149Z
9112351 9112351 20251231022036_w8G6F DE000R 2026-01-01T14:14:47.710Z 2026-01-08T15:07:38.594Z
9112080 9112080 20251231020421_E9XWt DE000R 2026-01-01T14:13:55.435Z 2026-01-08T15:07:17.944Z
9111881 9111881 20251231015029_YrEKy DE000R 2026-01-01T14:13:10.634Z 2026-01-08T15:07:08.179Z
9111512 9111512 20251231011518_vCh6T DE000R 2026-01-01T14:11:47.009Z 2026-01-08T15:06:43.230Z
9111163 9111163 20251231004340_eird1 DE000R 2026-01-01T14:10:20.324Z 2026-01-08T15:06:18.670Z
9110816 9110816 20251231000401_vTU4m DE000R 2026-01-01T14:08:53.438Z 2026-01-08T15:05:52.641Z
9110700 9110700 20251230235129_SxFYs DE000R 2026-01-01T14:08:27.031Z 2026-01-08T15:05:45.907Z
9099290 9099290 20251226200535_sjpJ4 DE000R 2025-12-30T15:23:17.322Z 2026-01-03T15:43:37.474Z
9091067 9091067 20251228174745_MYSDk DE000R 2025-12-30T14:51:41.956Z 2026-01-05T15:14:00.829Z
9086885 9086885 20251228055756_6l7p8 DE000R 2025-12-30T14:42:24.339Z 2026-01-05T15:10:35.140Z
9083143 9083143 20251227230349_DDuzU DE000R 2025-12-30T14:31:46.524Z 2026-01-05T15:07:38.503Z
9082702 9082702 20251227213044_RopPF DE000R 2025-12-30T14:30:17.608Z 2026-01-05T15:07:13.905Z
9080020 9080020 20251229040705_mZn2F DE000R 2025-12-30T14:19:26.112Z 2026-01-06T15:17:48.542Z
9078927 9078927 20251229024035_QEzCK DE000R 2025-12-30T14:15:00.819Z 2026-01-06T15:16:45.788Z
9078797 9078797 20251229023003_l0pgC DE000R 2025-12-30T14:14:31.615Z 2026-01-06T15:16:41.936Z
9076816 9076816 20251228231425_RlbLR DE000R 2025-12-30T14:05:10.141Z 2026-01-06T15:14:55.682Z
9076430 9076430 20251228221141_tgswM DE000R 2025-12-30T14:03:32.217Z 2026-01-06T15:14:36.222Z
9076363 9076363 20251228215736_iSjnD DE000R 2025-12-30T14:03:12.909Z 2026-01-06T15:14:25.663Z
9075966 9075966 20251228204046_CIUta DE000R 2025-12-30T14:00:44.610Z 2026-01-06T15:14:08.355Z
9075134 9075134 20251225210842_lhXfp DE000R 2025-12-29T15:01:30.264Z 2026-01-02T15:48:44.860Z
9072013 9072013 20251226200535_YQpRW DE000R 2025-12-29T14:50:18.832Z 2025-12-29T14:51:19.160Z
9071477 9071477 20251226184346_Y1bj0 DE000R 2025-12-29T14:49:31.331Z 2026-01-03T15:42:56.533Z
9063503 9063503 20251226031758_irGWO DE000R 2025-12-29T14:35:27.352Z 2026-01-03T15:35:21.574Z
9063138 9063138 20251226025620_Co5cx DE000R 2025-12-29T14:34:44.433Z 2026-01-03T15:35:05.661Z
9061592 9061592 20251226011216_9IAok DE000R 2025-12-29T14:31:37.870Z 2026-01-03T15:33:43.410Z
9061182 9061182 20251226004123_ik2Uf DE000R 2025-12-29T14:30:50.939Z 2026-01-03T15:33:29.255Z
9061104 9061104 20251226003311_hCDXV DE000R 2025-12-29T14:30:38.911Z 2026-01-03T15:33:26.640Z
9058085 9058085 20251227053341_OszfM DE000R 2025-12-29T14:24:13.780Z 2026-01-04T15:30:14.044Z
9057384 9057384 20251227045922_RYOWJ DE000R 2025-12-29T14:22:55.849Z 2026-01-04T15:29:44.812Z
9055732 9055732 20251227033606_vFbjM DE000R 2025-12-29T14:18:53.694Z 2026-01-04T15:28:15.749Z
9055086 9055086 20251227030545_uS5Q2 DE000R 2025-12-29T14:17:05.642Z 2026-01-04T15:27:41.462Z
9054397 9054397 20251227023258_kV1Im DE000R 2025-12-29T14:15:25.040Z 2026-01-04T15:27:05.498Z
9053806 9053806 20251227020258_hnZAl DE000R 2025-12-29T14:13:38.202Z 2026-01-04T15:26:31.605Z
9053371 9053371 20251227014102_8e2Dm DE000R 2025-12-29T14:12:28.685Z 2026-01-04T15:26:16.763Z
9053150 9053150 20251227012954_bqReA DE000R 2025-12-29T14:11:54.530Z 2026-01-04T15:25:58.036Z
9053001 9053001 20251227012249_cM5QW DE000R 2025-12-29T14:11:33.856Z 2026-01-04T15:25:53.576Z
9052775 9052775 20251227011206_W7Aua DE000R 2025-12-29T14:11:02.286Z 2026-01-04T15:25:45.231Z
9051569 9051569 20251226235518_fqevH DE000R 2025-12-29T14:07:12.304Z 2026-01-04T15:24:42.286Z
9051157 9051157 20251226232533_bBkJc DE000R 2025-12-29T14:05:52.038Z 2026-01-04T15:24:19.784Z
9051129 9051129 20251226232314_Q6cAQ DE000R 2025-12-29T14:05:46.728Z 2026-01-04T15:24:17.096Z
9050943 9050943 20251226230706_OOxKU DE000R 2025-12-29T14:05:05.912Z 2026-01-04T15:24:09.805Z
9024050 9024050 20251218012700_annlR DE000R 2025-12-27T15:18:54.901Z 2025-12-27T15:18:54.901Z
9015692 9015692 20251221230227_XWkcU DE000R 2025-12-27T14:54:33.511Z 2025-12-27T14:54:33.511Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network