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,153 rows where station_code = "BE0013" 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
9610612 9610612 20260404205038_ViajQ BE0013 2026-04-06T12:10:23.625Z 2026-04-06T12:16:14.618Z
9606817 9606817 20260402213923_rPb5J BE0013 2026-04-04T12:11:49.164Z 2026-04-06T12:23:46.607Z
9606788 9606788 20260402211451_YNht6 BE0013 2026-04-04T12:11:42.707Z 2026-04-06T12:23:44.265Z
9606770 9606770 20260402204905_qQe0s BE0013 2026-04-04T12:11:33.534Z 2026-04-06T12:23:40.459Z
9606764 9606764 20260402204458_2hMTX BE0013 2026-04-04T12:11:32.231Z 2026-04-06T12:23:40.064Z
9595502 9595502 20260330042247_jYlyS BE0013 2026-03-31T12:01:36.007Z 2026-04-06T12:30:06.626Z
9592612 9592612 20260329024726_pm2hD BE0013 2026-03-30T12:01:26.701Z 2026-04-06T12:34:17.964Z
9592377 9592377 20260329015937_nK405 BE0013 2026-03-30T12:00:51.266Z 2026-04-06T12:34:08.723Z
9592338 9592338 20260329015637_KVxci BE0013 2026-03-30T12:00:44.350Z 2026-04-06T12:34:01.555Z
9589990 9589990 20260328042607_RoJ2b BE0013 2026-03-29T12:01:49.063Z 2026-04-06T12:37:40.205Z
9589826 9589826 20260328041052_Y9CFb BE0013 2026-03-29T12:01:39.505Z 2026-04-06T12:37:35.804Z
9589362 9589362 20260328032120_9KP7W BE0013 2026-03-29T12:01:09.403Z 2026-04-06T12:37:21.223Z
9588316 9588316 20260326212826_8z8uY BE0013 2026-03-28T12:10:51.759Z 2026-04-04T12:41:57.988Z
9588306 9588306 20260326211712_X0oyR BE0013 2026-03-28T12:10:49.903Z 2026-04-04T12:41:56.900Z
9588292 9588292 20260326205423_kktPs BE0013 2026-03-28T12:10:47.360Z 2026-04-04T12:41:55.266Z
9581372 9581372 20260326030104_tytl5 BE0013 2026-03-27T12:02:54.089Z 2026-04-04T12:38:54.697Z
9575763 9575763 20260320200643_CbjLo BE0013 2026-03-25T12:35:52.625Z 2026-03-28T12:36:57.365Z
9575746 9575746 20260321212023_2umni BE0013 2026-03-25T12:31:39.587Z 2026-03-29T12:21:00.036Z
9575716 9575716 20260321043429_LWeFO BE0013 2026-03-25T12:28:20.138Z 2026-03-29T12:19:09.652Z
9575712 9575712 20260321031555_EhFTG BE0013 2026-03-25T12:28:02.743Z 2026-03-29T12:19:05.090Z
9570567 9570567 20260322220211_7Zh3P BE0013 2026-03-24T12:23:28.331Z 2026-03-30T12:30:45.592Z
9570315 9570315 20260322203131_RALqf BE0013 2026-03-24T12:22:59.160Z 2026-03-30T12:30:39.658Z
9570204 9570204 20260322194836_SUDLo BE0013 2026-03-24T12:22:47.983Z 2026-03-24T12:24:28.249Z
9560950 9560950 20260321223916_oekKm BE0013 2026-03-23T12:12:08.425Z 2026-03-29T12:21:04.174Z
9560707 9560707 20260321220511_62hTb BE0013 2026-03-23T12:12:01.529Z 2026-03-29T12:21:02.328Z
9560424 9560424 20260321212207_5dyIC BE0013 2026-03-23T12:11:46.645Z 2026-03-29T12:21:00.098Z
9560223 9560223 20260321204918_HjP3E BE0013 2026-03-23T12:11:40.463Z 2026-03-29T12:20:58.710Z
9560200 9560200 20260321204652_YRSEA BE0013 2026-03-23T12:11:40.182Z 2026-03-29T12:20:58.556Z
9560067 9560067 20260321202919_hc20P BE0013 2026-03-23T12:11:37.160Z 2026-03-29T12:20:57.713Z
9560009 9560009 20260321202327_WpDTC BE0013 2026-03-23T12:11:36.319Z 2026-03-29T12:20:57.434Z
9559805 9559805 20260321195120_XtRxi BE0013 2026-03-23T12:11:30.893Z 2026-03-29T12:20:55.664Z
9554665 9554665 20260322032353_gKlQC BE0013 2026-03-23T12:02:45.050Z 2026-03-30T12:28:06.982Z
9554488 9554488 20260322031324_p5Pi4 BE0013 2026-03-23T12:02:36.742Z 2026-03-30T12:28:04.654Z
9554391 9554391 20260322030504_Ze8My BE0013 2026-03-23T12:02:29.950Z 2026-03-30T12:28:03.166Z
9553181 9553181 20260322012339_lUY3w BE0013 2026-03-23T12:01:18.677Z 2026-03-30T12:27:36.222Z
9553047 9553047 20260322010753_4jevh BE0013 2026-03-23T12:01:10.617Z 2026-03-30T12:27:34.100Z
9552071 9552071 20260320225216_EYRKU BE0013 2026-03-22T12:27:26.243Z 2026-03-28T12:37:06.667Z
9551613 9551613 20260320203537_fdym5 BE0013 2026-03-22T12:26:51.879Z 2026-03-28T12:36:58.774Z
9551484 9551484 20260320195534_QVWN7 BE0013 2026-03-22T12:26:43.000Z 2026-03-28T12:36:56.049Z
9551410 9551410 20260320194318_Q2wym BE0013 2026-03-22T12:26:38.836Z 2026-03-28T12:36:50.918Z
9543386 9543386 20260321034254_3yG0Z BE0013 2026-03-22T12:03:39.979Z 2026-03-29T12:19:07.059Z
9543300 9543300 20260321032710_sP6Mf BE0013 2026-03-22T12:03:21.612Z 2026-03-29T12:19:05.759Z
9543205 9543205 20260321030357_E6553 BE0013 2026-03-22T12:03:01.353Z 2026-03-29T12:19:04.281Z
9542815 9542815 20260321013028_bP3bo BE0013 2026-03-22T12:01:42.683Z 2026-03-29T12:18:58.670Z
9542812 9542812 20260321012717_S3nFD BE0013 2026-03-22T12:01:41.773Z 2026-03-29T12:18:58.622Z
9542770 9542770 20260321012143_fFGE3 BE0013 2026-03-22T12:01:35.443Z 2026-03-29T12:18:58.120Z
9534754 9534754 20260320041741_GVjzy BE0013 2026-03-21T12:08:48.034Z 2026-03-28T12:34:21.637Z
9534578 9534578 20260320040106_Rb9ru BE0013 2026-03-21T12:08:20.266Z 2026-03-28T12:34:19.439Z
9534512 9534512 20260320035631_uCTdr BE0013 2026-03-21T12:08:10.111Z 2026-03-28T12:34:18.961Z
9534001 9534001 20260320031707_eVajr BE0013 2026-03-21T12:06:53.270Z 2026-03-28T12:34:03.505Z
9533514 9533514 20260320023606_9QPqJ BE0013 2026-03-21T12:05:34.413Z 2026-03-28T12:33:54.242Z
9533121 9533121 20260320020328_2scFY BE0013 2026-03-21T12:04:31.648Z 2026-03-28T12:33:49.068Z
9532300 9532300 20260320004426_8Hx9S BE0013 2026-03-21T12:02:19.157Z 2026-03-28T12:33:27.285Z
9531995 9531995 20260320000706_Tx6BV BE0013 2026-03-21T12:01:23.238Z 2026-03-28T12:33:23.570Z
9531663 9531663 20260319233450_hcrxd BE0013 2026-03-21T12:00:27.023Z 2026-03-28T12:33:19.963Z
9531425 9531425 20260318230759_X3jmb BE0013 2026-03-20T12:25:10.225Z 2026-03-26T12:39:19.304Z
9531348 9531348 20260318225946_Zdi5H BE0013 2026-03-20T12:25:07.528Z 2026-03-26T12:39:18.973Z
9531279 9531279 20260318225208_w6TaD BE0013 2026-03-20T12:25:03.981Z 2026-03-26T12:39:18.492Z
9531001 9531001 20260318221221_ovJA0 BE0013 2026-03-20T12:24:54.106Z 2026-03-26T12:39:16.878Z
9530719 9530719 20260318213114_sJHa3 BE0013 2026-03-20T12:24:37.029Z 2026-03-26T12:39:15.004Z
9530617 9530617 20260318211813_ckAjH BE0013 2026-03-20T12:24:32.432Z 2026-03-26T12:39:14.324Z
9521522 9521522 20260319042500_ZrtfM BE0013 2026-03-20T12:08:10.347Z 2026-03-27T12:40:55.459Z
9521357 9521357 20260319040806_zbyhX BE0013 2026-03-20T12:07:52.802Z 2026-03-27T12:40:54.060Z
9521113 9521113 20260319035419_57NFj BE0013 2026-03-20T12:07:32.399Z 2026-03-27T12:40:51.777Z
9520871 9520871 20260319034310_JqM1R BE0013 2026-03-20T12:07:09.859Z 2026-03-27T12:40:48.418Z
9518525 9518525 20260319010630_yEJ0h BE0013 2026-03-20T12:02:46.310Z 2026-03-27T12:40:11.157Z
9518401 9518401 20260319005711_8k1SP BE0013 2026-03-20T12:02:28.596Z 2026-03-27T12:40:09.262Z
9518029 9518029 20260319002238_pbHoY BE0013 2026-03-20T12:01:46.647Z 2026-03-27T12:40:05.730Z
9517735 9517735 20260318235926_PDkqt BE0013 2026-03-20T12:01:09.491Z 2026-03-27T12:40:02.798Z
9517432 9517432 20260318232451_pNNe1 BE0013 2026-03-20T12:00:21.767Z 2026-03-27T12:39:59.479Z
9517274 9517274 20260317230149_J3vqJ BE0013 2026-03-19T12:27:24.669Z 2026-03-25T12:43:09.807Z
9516919 9516919 20260317221534_98YwW BE0013 2026-03-19T12:26:54.825Z 2026-03-25T12:43:07.563Z
9516820 9516820 20260317220143_DZolr BE0013 2026-03-19T12:26:49.037Z 2026-03-25T12:43:07.148Z
9516749 9516749 20260317215345_AN1t2 BE0013 2026-03-19T12:26:45.044Z 2026-03-25T12:43:06.730Z
9516517 9516517 20260317210453_0Q2Uf BE0013 2026-03-19T12:26:19.422Z 2026-03-25T12:43:00.407Z
9516506 9516506 20260317210237_mbPNX BE0013 2026-03-19T12:26:18.923Z 2026-03-25T12:43:00.274Z
9516406 9516406 20260317204543_n2Owm BE0013 2026-03-19T12:26:08.400Z 2026-03-25T12:42:57.971Z
9516262 9516262 20260317202137_SR86o BE0013 2026-03-19T12:25:50.828Z 2026-03-25T12:42:52.679Z
9516096 9516096 20260317200259_ecXyd BE0013 2026-03-19T12:25:40.317Z 2026-03-25T12:42:48.448Z
9516026 9516026 20260317194417_10c8o BE0013 2026-03-19T12:25:32.234Z 2026-03-25T12:42:46.195Z
9515916 9515916 20260317192152_iluCh BE0013 2026-03-19T12:25:17.374Z 2026-03-25T12:42:42.026Z
9512122 9512122 20260318044530_ZL0M3 BE0013 2026-03-19T12:11:46.006Z 2026-03-26T12:37:42.561Z
9511787 9511787 20260318041811_7ZfVI BE0013 2026-03-19T12:11:01.294Z 2026-03-26T12:37:39.700Z
9511680 9511680 20260318040919_iMhJr BE0013 2026-03-19T12:10:45.135Z 2026-03-26T12:37:38.870Z
9511326 9511326 20260318034705_GX3xT BE0013 2026-03-19T12:09:57.767Z 2026-03-26T12:37:35.970Z
9511273 9511273 20260318034346_NP9AA BE0013 2026-03-19T12:09:51.076Z 2026-03-26T12:37:33.610Z
9511080 9511080 20260318033543_LKPVu BE0013 2026-03-19T12:09:25.990Z 2026-03-26T12:37:20.017Z
9509904 9509904 20260318022028_hed4h BE0013 2026-03-19T12:06:25.945Z 2026-03-26T12:37:08.462Z
9509888 9509888 20260318022028_9WNl8 BE0013 2026-03-19T12:06:25.568Z 2026-03-26T12:37:08.441Z
9509795 9509795 20260318021528_jcU9e BE0013 2026-03-19T12:06:12.796Z 2026-03-26T12:37:07.910Z
9509549 9509549 20260318015816_uoop0 BE0013 2026-03-19T12:05:39.071Z 2026-03-26T12:37:06.386Z
9509254 9509254 20260318013751_iNRaT BE0013 2026-03-19T12:04:53.951Z 2026-03-26T12:37:04.231Z
9509246 9509246 20260318013751_RDKe8 BE0013 2026-03-19T12:04:53.645Z 2026-03-26T12:37:04.205Z
9508723 9508723 20260318010815_PU42n BE0013 2026-03-19T12:03:42.123Z 2026-03-26T12:37:00.425Z
9508431 9508431 20260318005351_Wk7as BE0013 2026-03-19T12:03:04.826Z 2026-03-26T12:36:58.426Z
9508429 9508429 20260318005351_eF2pa BE0013 2026-03-19T12:03:04.575Z 2026-03-26T12:36:58.408Z
9508239 9508239 20260318003608_PPrmm BE0013 2026-03-19T12:02:42.161Z 2026-03-26T12:36:57.191Z
9508118 9508118 20260318001858_9sOh3 BE0013 2026-03-19T12:02:17.913Z 2026-03-26T12:36:56.016Z
9507918 9507918 20260317235600_wVSr1 BE0013 2026-03-19T12:01:42.361Z 2026-03-26T12:36:54.470Z
9507810 9507810 20260317234423_8Y5aA BE0013 2026-03-19T12:01:20.463Z 2026-03-26T12:36:53.620Z

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