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

1,449 rows where station_code = "BE001A" 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
9262581 9262581 20260125202707_Q7DDP BE001A 2026-01-27T14:13:46.399Z 2026-01-29T14:38:21.217Z
9262543 9262543 20260125194713_Yri1F BE001A 2026-01-27T14:13:17.744Z 2026-01-29T14:38:10.915Z
9260611 9260611 20260125055329_8Apy7 BE001A 2026-01-26T14:22:35.168Z 2026-01-29T14:44:30.970Z
9260609 9260609 20260125055321_K2gId BE001A 2026-01-26T14:22:34.784Z 2026-01-29T14:44:30.829Z
9260517 9260517 20260125050252_fbV0x BE001A 2026-01-26T14:22:03.472Z 2026-01-29T14:44:19.583Z
9260488 9260488 20260125044850_FAS2G BE001A 2026-01-26T14:21:57.589Z 2026-01-29T14:44:17.729Z
9260452 9260452 20260125043452_UNANJ BE001A 2026-01-26T14:21:52.059Z 2026-01-29T14:44:13.916Z
9260439 9260439 20260125042715_6pgKe BE001A 2026-01-26T14:21:49.699Z 2026-01-29T14:44:13.178Z
9260404 9260404 20260125041526_uqk82 BE001A 2026-01-26T14:21:35.395Z 2026-01-29T14:44:10.749Z
9260376 9260376 20260125040531_SZAG7 BE001A 2026-01-26T14:21:26.995Z 2026-01-29T14:44:08.985Z
9260365 9260365 20260125035947_f6YK2 BE001A 2026-01-26T14:21:24.673Z 2026-01-29T14:44:08.209Z
9260324 9260324 20260125033921_Vd3A3 BE001A 2026-01-26T14:21:17.463Z 2026-01-29T14:44:05.724Z
9260319 9260319 20260125033847_n07ag BE001A 2026-01-26T14:21:16.456Z 2026-01-29T14:44:05.512Z
9260287 9260287 20260125032522_16d2l BE001A 2026-01-26T14:21:04.554Z 2026-01-29T14:44:03.995Z
9260202 9260202 20260125030702_aGg6M BE001A 2026-01-26T14:20:46.792Z 2026-01-29T14:43:59.190Z
9260200 9260200 20260125030532_dhVa3 BE001A 2026-01-26T14:20:46.167Z 2026-01-29T14:43:59.041Z
9260104 9260104 20260125023740_IqGfn BE001A 2026-01-26T14:20:17.745Z 2026-01-29T14:43:48.766Z
9260088 9260088 20260125023157_x7P5N BE001A 2026-01-26T14:20:14.182Z 2026-01-29T14:43:45.971Z
9260086 9260086 20260125023026_KXStE BE001A 2026-01-26T14:20:13.622Z 2026-01-29T14:43:45.888Z
9260083 9260083 20260125023025_TsBgS BE001A 2026-01-26T14:20:12.434Z 2026-01-29T14:43:45.751Z
9260067 9260067 20260125022110_VHKzU BE001A 2026-01-26T14:20:08.957Z 2026-01-29T14:43:44.800Z
9260012 9260012 20260125020307_FqKqI BE001A 2026-01-26T14:19:46.343Z 2026-01-29T14:43:41.173Z
9259972 9259972 20260125013720_qk2dc BE001A 2026-01-26T14:19:37.268Z 2026-01-29T14:43:38.135Z
9259947 9259947 20260125012308_PtWsy BE001A 2026-01-26T14:19:26.619Z 2026-01-29T14:43:36.591Z
9259840 9259840 20260125004404_Qd2Ky BE001A 2026-01-26T14:18:52.609Z 2026-01-29T14:43:25.008Z
9259822 9259822 20260125002811_Ryxdg BE001A 2026-01-26T14:18:43.112Z 2026-01-29T14:43:23.513Z
9259809 9259809 20260125002611_CrZoK BE001A 2026-01-26T14:18:40.043Z 2026-01-29T14:43:22.724Z
9259749 9259749 20260124235350_f2OT9 BE001A 2026-01-26T14:18:27.329Z 2026-01-29T14:43:17.037Z
9259709 9259709 20260124233018_RmxlR BE001A 2026-01-26T14:18:10.836Z 2026-01-29T14:43:14.378Z
9259661 9259661 20260124225938_EFRiW BE001A 2026-01-26T14:18:00.954Z 2026-01-29T14:43:11.833Z
9259251 9259251 20260124200119_8zTMf BE001A 2026-01-26T14:16:21.327Z 2026-01-29T14:42:44.809Z
9259202 9259202 20260124193812_XeCfv BE001A 2026-01-26T14:16:05.554Z 2026-01-29T14:42:42.270Z
9259177 9259177 20260124192501_i3M2F BE001A 2026-01-26T14:16:01.025Z 2026-01-29T14:42:40.805Z
9259057 9259057 20260124183450_CuTy7 BE001A 2026-01-26T14:15:32.712Z 2026-01-29T14:42:28.302Z
9259023 9259023 20260124182351_doipk BE001A 2026-01-26T14:15:27.279Z 2026-01-29T14:42:26.513Z
9259008 9259008 20260124182227_TGujU BE001A 2026-01-26T14:15:24.492Z 2026-01-29T14:42:25.555Z
9258906 9258906 20260124175413_4hpef BE001A 2026-01-26T14:14:58.173Z 2026-01-29T14:42:18.099Z
9256231 9256231 20260124062456_G2GEa BE001A 2026-01-25T14:16:15.963Z 2026-01-29T14:48:30.139Z
9256199 9256199 20260124061735_2yBgU BE001A 2026-01-25T14:16:11.323Z 2026-01-29T14:48:28.207Z
9255987 9255987 20260124053502_cRSRO BE001A 2026-01-25T14:15:28.667Z 2026-01-29T14:48:16.635Z
9255891 9255891 20260124051253_cbWn1 BE001A 2026-01-25T14:15:04.056Z 2026-01-29T14:48:03.923Z
9255841 9255841 20260124050716_6fvCg BE001A 2026-01-25T14:14:57.140Z 2026-01-29T14:48:01.139Z
9255766 9255766 20260124045210_3SeYa BE001A 2026-01-25T14:14:38.132Z 2026-01-29T14:47:56.402Z
9252327 9252327 20260123021751_hLh5L BE001A 2026-01-24T14:15:09.049Z 2026-01-29T14:52:45.340Z
9252053 9252053 20260123004830_YsNhP BE001A 2026-01-24T14:14:13.032Z 2026-01-29T14:52:26.095Z
9252022 9252022 20260123003542_mqDic BE001A 2026-01-24T14:14:05.817Z 2026-01-29T14:52:24.588Z
9251978 9251978 20260123001836_UwNOW BE001A 2026-01-24T14:13:52.322Z 2026-01-29T14:52:19.954Z
9251973 9251973 20260123001140_0X0ZR BE001A 2026-01-24T14:13:51.354Z 2026-01-29T14:52:19.538Z
9251907 9251907 20260122235154_Fq8bN BE001A 2026-01-24T14:13:38.007Z 2026-01-29T14:52:16.636Z
9251807 9251807 20260122230602_lg3yj BE001A 2026-01-24T14:13:18.490Z 2026-01-29T14:52:11.432Z
9251686 9251686 20260122220502_zUE5U BE001A 2026-01-24T14:12:54.638Z 2026-01-29T14:51:59.018Z
9251676 9251676 20260122215435_qMcrg BE001A 2026-01-24T14:12:50.025Z 2026-01-29T14:51:58.388Z
9249336 9249336 20260122045513_24hx0 BE001A 2026-01-23T14:15:12.047Z 2026-01-29T14:58:26.537Z
9249318 9249318 20260122044550_B9Pjt BE001A 2026-01-23T14:15:09.952Z 2026-01-29T14:58:25.564Z
9248927 9248927 20260122024709_QMWTq BE001A 2026-01-23T14:14:07.226Z 2026-01-29T14:57:54.950Z
9248922 9248922 20260122024422_mOeM2 BE001A 2026-01-23T14:14:06.867Z 2026-01-29T14:57:54.791Z
9248895 9248895 20260122023826_pAw64 BE001A 2026-01-23T14:14:04.552Z 2026-01-29T14:57:53.803Z
9248838 9248838 20260122022325_2KAHe BE001A 2026-01-23T14:13:57.598Z 2026-01-29T14:57:49.029Z
9248818 9248818 20260122022033_ZIqyv BE001A 2026-01-23T14:13:54.833Z 2026-01-29T14:57:47.947Z
9248575 9248575 20260122004840_PkQIU BE001A 2026-01-23T14:13:11.240Z 2026-01-29T14:57:34.558Z
9248539 9248539 20260122003414_pncFW BE001A 2026-01-23T14:13:02.968Z 2026-01-29T14:57:25.753Z
9248427 9248427 20260121234256_hYHKZ BE001A 2026-01-23T14:12:46.440Z 2026-01-29T14:57:18.309Z
9248414 9248414 20260121233944_0gVC5 BE001A 2026-01-23T14:12:45.573Z 2026-01-29T14:57:18.073Z
9248365 9248365 20260121231309_AnQ2L BE001A 2026-01-23T14:12:39.101Z 2026-01-29T14:57:15.753Z
9248172 9248172 20260121220236_ZHSh9 BE001A 2026-01-23T14:12:11.157Z 2026-01-29T14:57:06.798Z
9247875 9247875 20260121202021_M4gMs BE001A 2026-01-23T14:11:20.033Z 2026-01-29T14:56:41.699Z
9236735 9236735 20260120035315_EgjU3 BE001A 2026-01-21T14:23:51.650Z 2026-01-28T15:00:32.588Z
9236721 9236721 20260120035140_BvLOi BE001A 2026-01-21T14:23:45.663Z 2026-01-28T15:00:31.897Z
9236636 9236636 20260120034255_FNL3x BE001A 2026-01-21T14:23:35.519Z 2026-01-28T15:00:26.578Z
9236477 9236477 20260120032427_he3Pp BE001A 2026-01-21T14:22:56.806Z 2026-01-28T15:00:03.813Z
9236322 9236322 20260120025951_Nijoe BE001A 2026-01-21T14:22:21.791Z 2026-01-28T14:59:55.284Z
9236282 9236282 20260120025542_E3oUI BE001A 2026-01-21T14:22:15.132Z 2026-01-28T14:59:53.239Z
9236253 9236253 20260120025158_gdO3V BE001A 2026-01-21T14:22:11.227Z 2026-01-28T14:59:52.088Z
9235738 9235738 20260120015515_X8kA2 BE001A 2026-01-21T14:20:07.280Z 2026-01-28T14:59:18.421Z
9235602 9235602 20260120013753_Mz8Sm BE001A 2026-01-21T14:19:34.342Z 2026-01-28T14:59:11.914Z
9235450 9235450 20260120011446_NrB1p BE001A 2026-01-21T14:18:56.566Z 2026-01-28T14:58:55.910Z
9235245 9235245 20260120004718_eSGrJ BE001A 2026-01-21T14:18:06.618Z 2026-01-28T14:58:45.555Z
9235162 9235162 20260120003918_1Ximr BE001A 2026-01-21T14:17:47.684Z 2026-01-28T14:58:33.676Z
9235056 9235056 20260120001940_SFDO1 BE001A 2026-01-21T14:17:19.461Z 2026-01-28T14:58:27.082Z
9234880 9234880 20260119234519_QIOhG BE001A 2026-01-21T14:16:33.690Z 2026-01-28T14:58:18.549Z
9234375 9234375 20260119210643_e9WRn BE001A 2026-01-21T14:14:02.976Z 2026-01-28T14:57:34.591Z
9234369 9234369 20260119210352_wOuNs BE001A 2026-01-21T14:14:00.610Z 2026-01-28T14:57:34.038Z
9234367 9234367 20260119210308_K5w2s BE001A 2026-01-21T14:14:00.025Z 2026-01-28T14:57:33.880Z
9228207 9228207 20260118203952_3rN2G BE001A 2026-01-20T14:16:39.335Z 2026-01-27T15:01:33.921Z
9228014 9228014 20260118190911_cBrr7 BE001A 2026-01-20T14:15:28.059Z 2026-01-27T15:01:11.306Z
9227975 9227975 20260118190331_yaXnk BE001A 2026-01-20T14:15:15.531Z 2026-01-27T15:01:09.013Z
9227767 9227767 20260118173534_kUlke BE001A 2026-01-20T14:13:55.224Z 2026-01-27T15:00:52.114Z
9207488 9207488 20260115015213_EQMJG BE001A 2026-01-16T14:08:58.066Z 2026-01-22T15:03:23.099Z
9195582 9195582 20260113015310_fonft BE001A 2026-01-14T14:13:55.475Z 2026-01-21T15:04:42.621Z
9195576 9195576 20260113015001_nEZ2b BE001A 2026-01-14T14:13:52.236Z 2026-01-21T15:04:42.438Z
9195159 9195159 20260113003121_JmAa7 BE001A 2026-01-14T14:12:15.562Z 2026-01-21T15:04:37.143Z
9155746 9155746 20260104061939_IL39k BE001A 2026-01-06T14:37:58.528Z 2026-01-12T15:11:26.239Z
9155740 9155740 20260104061917_bONLm BE001A 2026-01-06T14:37:58.135Z 2026-01-12T15:11:26.045Z
9155401 9155401 20260104055429_f8scH BE001A 2026-01-06T14:37:20.144Z 2026-01-12T15:10:59.806Z
9149634 9149634 20260104224028_ok0Pi BE001A 2026-01-06T14:06:26.343Z 2026-01-13T15:12:23.789Z
9149574 9149574 20260104220144_kfA5m BE001A 2026-01-06T14:06:09.110Z 2026-01-13T15:12:18.959Z
9130487 9130487 20260103032804_hfLHY BE001A 2026-01-04T14:10:22.042Z 2026-01-10T14:59:15.179Z
9127569 9127569 20260102043141_SgK71 BE001A 2026-01-03T14:10:50.591Z 2026-01-09T14:49:58.678Z
9127278 9127278 20260102032634_kbFIA BE001A 2026-01-03T14:09:33.678Z 2026-01-09T14:49:36.486Z
9127265 9127265 20260102032117_3eBmq BE001A 2026-01-03T14:09:29.317Z 2026-01-09T14:49:35.773Z

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