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

>10,000 rows count all where station_code = "BE000G" 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
9611682 9611682 20260405030833_du1QC BE000G 2026-04-06T12:15:43.415Z 2026-04-06T12:16:14.846Z
9611274 9611274 20260405010905_CrTp9 BE000G 2026-04-06T12:13:48.716Z 2026-04-06T12:16:14.767Z
9610956 9610956 20260404230255_30d59 BE000G 2026-04-06T12:12:14.511Z 2026-04-06T12:16:14.698Z
9610932 9610932 20260404225516_wQTtX BE000G 2026-04-06T12:12:05.006Z 2026-04-06T12:16:14.693Z
9610881 9610881 20260404224123_ol3Bd BE000G 2026-04-06T12:11:54.250Z 2026-04-06T12:16:14.683Z
9610732 9610732 20260404212548_NRgHM BE000G 2026-04-06T12:10:59.858Z 2026-04-06T12:16:14.647Z
9610678 9610678 20260404211120_okYae BE000G 2026-04-06T12:10:41.060Z 2026-04-06T12:16:14.633Z
9610539 9610539 20260404201907_RTZud BE000G 2026-04-06T12:10:04.798Z 2026-04-06T12:16:14.597Z
9609108 9609108 20260405033550_sH36i BE000G 2026-04-06T12:00:17.935Z 2026-04-06T12:00:17.935Z
9604946 9604946 20260402021131_deMPU BE000G 2026-04-03T12:12:23.512Z 2026-04-06T12:26:34.111Z
9604846 9604846 20260402011729_Fl7t2 BE000G 2026-04-03T12:11:53.624Z 2026-04-06T12:26:27.154Z
9604672 9604672 20260401232507_TjB3L BE000G 2026-04-03T12:11:05.707Z 2026-04-06T12:26:10.629Z
9604587 9604587 20260401213647_xhiEO BE000G 2026-04-03T12:10:46.971Z 2026-04-06T12:26:05.252Z
9604565 9604565 20260401210512_ijVOF BE000G 2026-04-03T12:10:28.699Z 2026-04-06T12:26:02.137Z
9602765 9602765 20260402030707_pE5QQ BE000G 2026-04-03T12:00:30.810Z 2026-04-06T12:21:08.969Z
9600474 9600474 20260330223855_OJbhg BE000G 2026-04-01T12:10:52.826Z 2026-04-06T12:33:27.666Z
9600409 9600409 20260330212259_1mtrm BE000G 2026-04-01T12:10:39.553Z 2026-04-06T12:33:23.942Z
9600400 9600400 20260330211323_gO17m BE000G 2026-04-01T12:10:37.180Z 2026-04-06T12:33:23.333Z
9600321 9600321 20260330201937_jmZMB BE000G 2026-04-01T12:10:17.538Z 2026-04-06T12:33:16.553Z
9600295 9600295 20260330195212_NgZd0 BE000G 2026-04-01T12:10:10.079Z 2026-04-06T12:33:14.056Z
9600286 9600286 20260330193110_2IjE7 BE000G 2026-04-01T12:10:06.171Z 2026-04-06T12:33:13.471Z
9598726 9598726 20260331034818_DEngx BE000G 2026-04-01T12:00:45.636Z 2026-04-06T12:26:53.813Z
9598704 9598704 20260331031302_tnloa BE000G 2026-04-01T12:00:38.900Z 2026-04-06T12:26:48.628Z
9598669 9598669 20260331023835_OfWqa BE000G 2026-04-01T12:00:26.652Z 2026-04-06T12:26:45.519Z
9598658 9598658 20260331023119_XW4eI BE000G 2026-04-01T12:00:22.969Z 2026-04-06T12:26:44.541Z
9598621 9598621 20260331015142_gi5mX BE000G 2026-04-01T12:00:13.200Z 2026-04-06T12:26:39.648Z
9595485 9595485 20260330041942_6XpuX BE000G 2026-03-31T12:01:32.543Z 2026-04-06T12:30:05.998Z
9594216 9594216 20260328201854_Ar9TY BE000G 2026-03-30T12:09:00.421Z 2026-04-06T12:39:43.590Z
9594187 9594187 20260328195338_KJKB3 BE000G 2026-03-30T12:08:55.506Z 2026-04-06T12:39:41.529Z
9594185 9594185 20260328195223_zRZoH BE000G 2026-03-30T12:08:55.100Z 2026-04-06T12:39:41.432Z
9592934 9592934 20260329035712_lFl3U BE000G 2026-03-30T12:02:21.993Z 2026-04-06T12:34:41.192Z
9592859 9592859 20260329034046_GZWbD BE000G 2026-03-30T12:02:07.459Z 2026-04-06T12:34:37.559Z
9588681 9588681 20260327003259_IyBCU BE000G 2026-03-28T12:11:38.818Z 2026-04-04T12:42:26.627Z
9588675 9588675 20260327002620_i0M3J BE000G 2026-03-28T12:11:38.295Z 2026-04-04T12:42:26.164Z
9588663 9588663 20260327002103_CeS9k BE000G 2026-03-28T12:11:36.799Z 2026-04-04T12:42:25.250Z
9588365 9588365 20260326221036_rBjV0 BE000G 2026-03-28T12:10:56.897Z 2026-04-04T12:42:01.264Z
9588333 9588333 20260326214915_wNeN2 BE000G 2026-03-28T12:10:53.996Z 2026-04-04T12:41:59.267Z
9588275 9588275 20260326203051_oRjjx BE000G 2026-03-28T12:10:44.864Z 2026-04-04T12:41:53.873Z
9588244 9588244 20260326194758_ubu3K BE000G 2026-03-28T12:10:36.504Z 2026-04-04T12:41:50.905Z
9588231 9588231 20260326191509_IeKsC BE000G 2026-03-28T12:10:31.807Z 2026-04-04T12:41:47.828Z
9586161 9586161 20260327041815_DbXwS BE000G 2026-03-28T12:02:22.917Z 2026-04-05T12:33:04.118Z
9586142 9586142 20260327041335_kg4Mz BE000G 2026-03-28T12:02:20.568Z 2026-04-05T12:33:03.398Z
9586096 9586096 20260327035412_0a56c BE000G 2026-03-28T12:02:09.895Z 2026-04-05T12:33:00.864Z
9586072 9586072 20260327034746_GoDQQ BE000G 2026-03-28T12:02:06.859Z 2026-04-05T12:32:59.682Z
9586001 9586001 20260327032652_hH1ka BE000G 2026-03-28T12:01:56.236Z 2026-04-05T12:32:56.034Z
9585776 9585776 20260327022741_ykLaD BE000G 2026-03-28T12:01:17.799Z 2026-04-05T12:32:44.875Z
9585754 9585754 20260327022250_jaMdS BE000G 2026-03-28T12:01:12.876Z 2026-04-05T12:32:37.656Z
9585659 9585659 20260327020309_styAQ BE000G 2026-03-28T12:00:57.047Z 2026-04-05T12:32:33.621Z
9585506 9585506 20260327012301_7HGIR BE000G 2026-03-28T12:00:31.667Z 2026-04-05T12:32:24.370Z
9585397 9585397 20260327004756_xAmCF BE000G 2026-03-28T12:00:12.908Z 2026-04-05T12:32:19.377Z
9585067 9585067 20260325232021_2U3Y9 BE000G 2026-03-27T12:16:39.194Z 2026-04-03T12:39:48.579Z
9579987 9579987 20260324234424_clHRT BE000G 2026-03-26T12:14:49.287Z 2026-04-02T12:37:38.054Z
9579962 9579962 20260324233629_6qgmK BE000G 2026-03-26T12:14:46.027Z 2026-04-02T12:37:36.575Z
9579939 9579939 20260324232853_0nsUi BE000G 2026-03-26T12:14:43.151Z 2026-04-02T12:37:35.396Z
9579936 9579936 20260324232704_6Spy3 BE000G 2026-03-26T12:14:42.780Z 2026-04-02T12:37:35.228Z
9579637 9579637 20260324220156_APKlA BE000G 2026-03-26T12:14:06.582Z 2026-04-02T12:37:18.574Z
9579520 9579520 20260324211203_Uio9d BE000G 2026-03-26T12:13:52.388Z 2026-04-02T12:37:13.494Z
9575758 9575758 20260320190618_cevIE BE000G 2026-03-25T12:35:47.108Z 2026-03-28T12:36:41.742Z
9575743 9575743 20260321205359_go3jT BE000G 2026-03-25T12:31:36.486Z 2026-03-29T12:20:58.840Z
9575687 9575687 20260322221428_9WAPx BE000G 2026-03-25T12:27:03.056Z 2026-03-30T12:30:46.473Z
9575627 9575627 20260323235821_b2bTG BE000G 2026-03-25T12:21:32.604Z 2026-03-31T12:29:03.529Z
9575612 9575612 20260323234154_K3LtU BE000G 2026-03-25T12:21:30.745Z 2026-03-31T12:29:03.024Z
9575379 9575379 20260323213504_X1IHx BE000G 2026-03-25T12:20:58.103Z 2026-03-31T12:28:56.286Z
9571076 9571076 20260322234333_lhLiY BE000G 2026-03-24T12:24:19.052Z 2026-03-30T12:30:54.848Z
9570753 9570753 20260322224005_SH1IN BE000G 2026-03-24T12:23:46.479Z 2026-03-30T12:30:48.739Z
9570563 9570563 20260322220211_7Zh3P BE000G 2026-03-24T12:23:28.331Z 2026-03-30T12:30:45.592Z
9570539 9570539 20260322215655_HyM72 BE000G 2026-03-24T12:23:25.890Z 2026-03-30T12:30:45.044Z
9570517 9570517 20260322214503_uytRE BE000G 2026-03-24T12:23:23.367Z 2026-03-30T12:30:44.579Z
9570173 9570173 20260322193612_XInEJ BE000G 2026-03-24T12:22:44.980Z 2026-03-30T12:30:29.024Z
9562987 9562987 20260323042217_p4GV4 BE000G 2026-03-24T12:04:39.450Z 2026-03-31T12:26:31.619Z
9562971 9562971 20260323041804_xvNm3 BE000G 2026-03-24T12:04:36.738Z 2026-03-31T12:26:31.179Z
9562892 9562892 20260323033418_ufeRZ BE000G 2026-03-24T12:04:20.971Z 2026-03-31T12:26:28.603Z
9562804 9562804 20260323031643_8ND4G BE000G 2026-03-24T12:04:07.028Z 2026-03-31T12:26:26.386Z
9562775 9562775 20260323031314_Hm4W7 BE000G 2026-03-24T12:04:01.059Z 2026-03-31T12:26:25.702Z
9562607 9562607 20260323024617_i93BF BE000G 2026-03-24T12:03:32.867Z 2026-03-31T12:26:15.499Z
9562566 9562566 20260323023440_Yhs2M BE000G 2026-03-24T12:03:26.946Z 2026-03-31T12:26:14.488Z
9562546 9562546 20260323023200_xS1Uy BE000G 2026-03-24T12:03:23.405Z 2026-03-31T12:26:13.885Z
9562449 9562449 20260323022147_Jo39u BE000G 2026-03-24T12:03:08.765Z 2026-03-31T12:26:10.556Z
9562398 9562398 20260323021646_fOCzZ BE000G 2026-03-24T12:02:59.096Z 2026-03-31T12:26:09.292Z
9561839 9561839 20260323004928_eIDRF BE000G 2026-03-24T12:01:26.735Z 2026-03-31T12:25:54.831Z
9561720 9561720 20260323003316_Oezoo BE000G 2026-03-24T12:01:03.943Z 2026-03-31T12:25:51.819Z
9561426 9561426 20260321233147_yNAPw BE000G 2026-03-23T12:12:18.790Z 2026-03-29T12:21:07.141Z
9561382 9561382 20260321232642_AdKWR BE000G 2026-03-23T12:12:17.868Z 2026-03-29T12:21:06.848Z
9561215 9561215 20260321230906_ybUYw BE000G 2026-03-23T12:12:13.918Z 2026-03-29T12:21:05.724Z
9561116 9561116 20260321230226_HaT0l BE000G 2026-03-23T12:12:11.977Z 2026-03-24T12:29:07.695Z
9561107 9561107 20260321230118_YmuKo BE000G 2026-03-23T12:12:11.765Z 2026-03-29T12:21:05.202Z
9561091 9561091 20260321225537_HoiTO BE000G 2026-03-23T12:12:11.513Z 2026-03-29T12:21:05.147Z
9560906 9560906 20260321223402_3m9HC BE000G 2026-03-23T12:12:06.900Z 2026-03-29T12:21:03.834Z
9560505 9560505 20260321213404_3liJs BE000G 2026-03-23T12:11:49.500Z 2026-03-29T12:21:00.847Z
9560314 9560314 20260321210136_E7Vk2 BE000G 2026-03-23T12:11:42.505Z 2026-03-29T12:20:59.230Z
9560273 9560273 20260321205521_vAIvy BE000G 2026-03-23T12:11:40.962Z 2026-03-29T12:20:58.859Z
9560197 9560197 20260321204652_YRSEA BE000G 2026-03-23T12:11:40.181Z 2026-03-29T12:20:58.556Z
9559971 9559971 20260321201429_pfg9w BE000G 2026-03-23T12:11:35.025Z 2026-03-29T12:20:57.009Z
9559929 9559929 20260321201124_ltnjI BE000G 2026-03-23T12:11:34.033Z 2026-03-29T12:20:56.674Z
9552968 9552968 20260322010048_ujQ0r BE000G 2026-03-23T12:01:05.350Z 2026-03-30T12:27:33.230Z
9552111 9552111 20260320230052_CfSqU BE000G 2026-03-22T12:27:27.935Z 2026-03-28T12:37:07.032Z
9552062 9552062 20260320224956_mlAqG BE000G 2026-03-22T12:27:25.321Z 2026-03-28T12:37:06.409Z
9552053 9552053 20260320224456_xD1W8 BE000G 2026-03-22T12:27:24.787Z 2026-03-28T12:37:06.143Z
9552038 9552038 20260320224050_Kel31 BE000G 2026-03-22T12:27:23.763Z 2026-03-28T12:37:05.755Z
9551814 9551814 20260320214825_qecwV BE000G 2026-03-22T12:27:04.487Z 2026-03-28T12:37:02.492Z

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