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,410 rows where station_code = "BA0002" 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
8826351 8826351 20251211033857_73TGa BA0002 2025-12-17T15:22:27.516Z 2025-12-19T15:16:41.920Z
8826327 8826327 20251211025529_b0oB1 BA0002 2025-12-17T15:22:06.137Z 2025-12-19T15:16:22.080Z
8826316 8826316 20251211015825_gDjI4 BA0002 2025-12-17T15:21:04.532Z 2025-12-19T15:15:29.730Z
8826303 8826303 20251211014124_t92BW BA0002 2025-12-17T15:21:01.173Z 2025-12-19T15:15:22.283Z
8826287 8826287 20251211002045_fIdHu BA0002 2025-12-17T15:20:44.111Z 2025-12-19T15:14:25.035Z
8826278 8826278 20251210233616_hEuYN BA0002 2025-12-17T15:20:36.669Z 2025-12-19T15:14:13.554Z
8826235 8826235 20251210204755_4HwIW BA0002 2025-12-17T15:18:22.241Z 2025-12-19T15:12:04.721Z
8826232 8826232 20251210204424_rMzN9 BA0002 2025-12-17T15:18:21.775Z 2025-12-19T15:12:04.019Z
8826229 8826229 20251210203013_Ws33V BA0002 2025-12-17T15:18:16.817Z 2025-12-19T15:11:58.692Z
8826219 8826219 20251210191029_ddYyl BA0002 2025-12-17T15:18:06.010Z 2025-12-19T15:11:24.451Z
8826215 8826215 20251210182429_6QFdW BA0002 2025-12-17T15:17:58.937Z 2025-12-19T15:11:10.682Z
8808265 8808265 20251210040833_L34Hc BA0002 2025-12-16T15:03:41.457Z 2025-12-17T15:29:29.241Z
8808261 8808261 20251210035611_20Fm4 BA0002 2025-12-16T15:03:38.427Z 2025-12-17T15:29:27.285Z
8808242 8808242 20251210012703_3Yd6p BA0002 2025-12-16T15:02:32.870Z 2025-12-17T15:28:24.615Z
8808131 8808131 20251211212021_UJQJH BA0002 2025-12-16T14:52:14.447Z 2025-12-20T14:25:18.080Z
8808116 8808116 20251211191320_lTxch BA0002 2025-12-16T14:51:30.598Z 2025-12-20T14:25:01.809Z
8767502 8767502 20251212001719_VWwIc BA0002 2025-12-14T15:12:10.947Z 2025-12-20T14:25:25.916Z
8767415 8767415 20251211223347_Z05EX BA0002 2025-12-14T15:10:36.018Z 2025-12-20T14:25:20.537Z
8767409 8767409 20251211222448_W6lI6 BA0002 2025-12-14T15:10:29.277Z 2025-12-20T14:25:20.216Z
8767373 8767373 20251211212329_dGa9M BA0002 2025-12-14T15:09:58.160Z 2025-12-14T15:16:16.575Z
8767363 8767363 20251211195402_lrNUv BA0002 2025-12-14T15:09:18.349Z 2025-12-14T15:16:16.324Z
8767350 8767350 20251211193056_QGKcD BA0002 2025-12-14T15:08:44.952Z 2025-12-14T15:16:16.259Z
8767345 8767345 20251211191306_ZG5v3 BA0002 2025-12-14T15:08:39.375Z 2025-12-20T14:25:01.687Z
8767341 8767341 20251211190810_R2382 BA0002 2025-12-14T15:08:37.623Z 2025-12-14T15:16:16.197Z
8767317 8767317 20251211175019_ODZ6D BA0002 2025-12-14T15:07:48.608Z 2025-12-14T15:16:15.914Z
8756250 8756250 20251210040944_32CpQ BA0002 2025-12-13T15:45:05.355Z 2025-12-17T15:29:29.451Z
8755784 8755784 20251210034018_cWCJC BA0002 2025-12-13T15:44:23.476Z 2025-12-17T15:29:24.437Z
8755661 8755661 20251210033345_3weDY BA0002 2025-12-13T15:44:18.442Z 2025-12-17T15:29:23.348Z
8755613 8755613 20251210032931_H1FYo BA0002 2025-12-13T15:44:17.150Z 2025-12-17T15:29:22.900Z
8755553 8755553 20251210032420_YimAm BA0002 2025-12-13T15:44:12.191Z 2025-12-17T15:29:22.072Z
8755492 8755492 20251210031841_4NZLH BA0002 2025-12-13T15:44:09.812Z 2025-12-17T15:29:21.383Z
8755327 8755327 20251210030542_jURVl BA0002 2025-12-13T15:44:05.175Z 2025-12-17T15:29:19.903Z
8755183 8755183 20251210025643_U3VR3 BA0002 2025-12-13T15:44:01.082Z 2025-12-17T15:29:18.346Z
8754112 8754112 20251210013148_xYtM3 BA0002 2025-12-13T15:42:43.311Z 2025-12-17T15:28:29.732Z
8753994 8753994 20251210011842_3ILqr BA0002 2025-12-13T15:42:26.270Z 2025-12-17T15:28:20.454Z
8753820 8753820 20251210010504_O1JzN BA0002 2025-12-13T15:41:59.333Z 2025-12-17T15:28:10.674Z
8753286 8753286 20251210002219_cWudZ BA0002 2025-12-13T15:41:40.602Z 2025-12-17T15:27:41.292Z
8753042 8753042 20251210000127_uPAGO BA0002 2025-12-13T15:41:34.336Z 2025-12-17T15:27:37.929Z
8752641 8752641 20251209231959_bV2dJ BA0002 2025-12-13T15:40:56.768Z 2025-12-17T15:27:30.894Z
8752584 8752584 20251209231640_0ZtYn BA0002 2025-12-13T15:40:55.500Z 2025-12-17T15:27:30.384Z
8752461 8752461 20251209230310_hAxAi BA0002 2025-12-13T15:40:51.640Z 2025-12-17T15:27:29.156Z
8752439 8752439 20251209225958_xsnRE BA0002 2025-12-13T15:40:51.187Z 2025-12-17T15:27:29.083Z
8752419 8752419 20251209225701_ZonC3 BA0002 2025-12-13T15:40:50.425Z 2025-12-17T15:27:28.778Z
8752385 8752385 20251209225503_9djt5 BA0002 2025-12-13T15:40:49.271Z 2025-12-17T15:27:28.459Z
8752351 8752351 20251209224837_SNM2e BA0002 2025-12-13T15:40:48.193Z 2025-12-17T15:27:28.003Z
8752276 8752276 20251209224316_hb1Lo BA0002 2025-12-13T15:40:46.337Z 2025-12-17T15:27:27.304Z
8752240 8752240 20251209224000_rGSr2 BA0002 2025-12-13T15:40:45.610Z 2025-12-17T15:27:26.965Z
8752132 8752132 20251209222912_fbjUC BA0002 2025-12-13T15:40:23.791Z 2025-12-17T15:27:26.092Z
8752121 8752121 20251209222654_5aXn2 BA0002 2025-12-13T15:40:22.190Z 2025-12-17T15:27:25.974Z
8751973 8751973 20251209220647_YU182 BA0002 2025-12-13T15:40:01.975Z 2025-12-17T15:27:24.499Z
8751879 8751879 20251209220036_jrVXc BA0002 2025-12-13T15:39:52.815Z 2025-12-17T15:27:23.718Z
8751825 8751825 20251209215832_1OKur BA0002 2025-12-13T15:39:51.401Z 2025-12-17T15:27:23.187Z
8751666 8751666 20251209213906_w7PiF BA0002 2025-12-13T15:39:44.300Z 2025-12-17T15:27:21.584Z
8751566 8751566 20251209212706_48eF7 BA0002 2025-12-13T15:39:41.400Z 2025-12-17T15:27:20.343Z
8751204 8751204 20251209203639_91pHx BA0002 2025-12-13T15:39:30.889Z 2025-12-17T15:27:16.131Z
8750472 8750472 20251209183931_21Ao7 BA0002 2025-12-13T15:38:04.988Z 2025-12-17T15:26:26.755Z
8750333 8750333 20251209180730_mLF52 BA0002 2025-12-13T15:37:56.728Z 2025-12-17T15:26:24.557Z
8750248 8750248 20251209175054_iUveu BA0002 2025-12-13T15:37:52.857Z 2025-12-17T15:26:22.841Z
8750158 8750158 20251209173036_zjCs6 BA0002 2025-12-13T15:37:47.701Z 2025-12-17T15:26:19.825Z
8750051 8750051 20251209165856_Jj2xg BA0002 2025-12-13T15:37:16.126Z 2025-12-17T15:26:17.500Z
8750004 8750004 20251209164428_fohIc BA0002 2025-12-13T15:37:08.724Z 2025-12-17T15:26:16.504Z
8749895 8749895 20251209161602_N0nEL BA0002 2025-12-13T15:37:02.590Z 2025-12-17T15:26:14.918Z
8747150 8747150 20251211035509_E7Po2 BA0002 2025-12-13T15:30:10.676Z 2025-12-19T15:16:48.848Z
8746461 8746461 20251211030424_wwWG4 BA0002 2025-12-13T15:28:48.588Z 2025-12-19T15:16:27.246Z
8745970 8745970 20251211022803_X9nEy BA0002 2025-12-13T15:28:26.104Z 2025-12-19T15:15:58.289Z
8745789 8745789 20251211021656_w6EVE BA0002 2025-12-13T15:28:05.274Z 2025-12-19T15:15:54.765Z
8745049 8745049 20251211012516_P58IC BA0002 2025-12-13T15:26:51.862Z 2025-12-19T15:15:16.285Z
8744560 8744560 20251211005334_qMm4F BA0002 2025-12-13T15:26:17.305Z 2025-12-19T15:14:46.698Z
8744536 8744536 20251211005127_s1Yb8 BA0002 2025-12-13T15:26:16.113Z 2025-12-19T15:14:43.784Z
8744521 8744521 20251211005103_mQv1w BA0002 2025-12-13T15:26:15.709Z 2025-12-19T15:14:43.178Z
8744510 8744510 20251211005016_eu0ua BA0002 2025-12-13T15:26:14.755Z 2025-12-19T15:14:40.755Z
8744209 8744209 20251211002255_HeWz7 BA0002 2025-12-13T15:25:34.241Z 2025-12-19T15:14:25.849Z
8743803 8743803 20251210234952_Wcxfh BA0002 2025-12-13T15:25:02.670Z 2025-12-19T15:14:17.459Z
8743624 8743624 20251210233948_IShAD BA0002 2025-12-13T15:24:23.157Z 2025-12-19T15:14:14.513Z
8743405 8743405 20251210232556_Rnl3v BA0002 2025-12-13T15:24:08.431Z 2025-12-19T15:14:10.675Z
8743400 8743400 20251210232555_Zk0iK BA0002 2025-12-13T15:24:08.218Z 2025-12-19T15:14:07.300Z
8743388 8743388 20251210232448_3b0Mk BA0002 2025-12-13T15:24:07.316Z 2025-12-19T15:13:51.650Z
8743291 8743291 20251210232013_3BG6D BA0002 2025-12-13T15:24:04.162Z 2025-12-19T15:13:42.997Z
8742867 8742867 20251210224809_q7h2M BA0002 2025-12-13T15:23:12.685Z 2025-12-19T15:13:25.158Z
8742865 8742865 20251210224808_kC6sJ BA0002 2025-12-13T15:23:12.589Z 2025-12-19T15:13:25.128Z
8742422 8742422 20251210221836_jd8vO BA0002 2025-12-13T15:22:35.580Z 2025-12-19T15:13:15.546Z
8742409 8742409 20251210221747_CNqOh BA0002 2025-12-13T15:22:30.019Z 2025-12-19T15:13:15.311Z
8742260 8742260 20251210221212_FsEeK BA0002 2025-12-13T15:22:14.407Z 2025-12-19T15:13:11.933Z
8742066 8742066 20251210215954_CeJGx BA0002 2025-12-13T15:22:04.424Z 2025-12-19T15:13:07.285Z
8742058 8742058 20251210215916_c721T BA0002 2025-12-13T15:22:03.749Z 2025-12-19T15:13:06.826Z
8742056 8742056 20251210215914_YFRcO BA0002 2025-12-13T15:22:03.551Z 2025-12-19T15:13:06.734Z
8742054 8742054 20251210215914_OTKSj BA0002 2025-12-13T15:22:03.397Z 2025-12-19T15:13:06.628Z
8741976 8741976 20251210215232_jq2fx BA0002 2025-12-13T15:21:59.272Z 2025-12-19T15:12:47.562Z
8741945 8741945 20251210214955_lzFaR BA0002 2025-12-13T15:21:54.350Z 2025-12-19T15:12:45.760Z
8741872 8741872 20251210214518_ZFKah BA0002 2025-12-13T15:21:30.280Z 2025-12-19T15:12:44.051Z
8741835 8741835 20251210214304_ogyF3 BA0002 2025-12-13T15:21:27.564Z 2025-12-19T15:12:43.204Z
8741610 8741610 20251210212649_i5OZ5 BA0002 2025-12-13T15:21:12.999Z 2025-12-19T15:12:34.910Z
8741304 8741304 20251210210610_fr33d BA0002 2025-12-13T15:20:33.111Z 2025-12-19T15:12:27.203Z
8741277 8741277 20251210210300_cjYdO BA0002 2025-12-13T15:20:31.454Z 2025-12-19T15:12:26.311Z
8741229 8741229 20251210205748_GG3l5 BA0002 2025-12-13T15:20:29.095Z 2025-12-19T15:12:25.124Z
8740984 8740984 20251210203224_OSllM BA0002 2025-12-13T15:19:51.003Z 2025-12-19T15:12:00.565Z
8740248 8740248 20251210185339_IHs3J BA0002 2025-12-13T15:18:10.396Z 2025-12-19T15:11:18.030Z
8740183 8740183 20251210184619_I1R4G BA0002 2025-12-13T15:18:07.632Z 2025-12-19T15:11:16.285Z
8740064 8740064 20251210182606_XROuN BA0002 2025-12-13T15:17:58.931Z 2025-12-19T15:11:11.411Z
8739984 8739984 20251210180547_07Tb9 BA0002 2025-12-13T15:17:36.622Z 2025-12-19T15:11:07.634Z

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