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 = "AU001Y" 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
9851768 9851768 20260504195348_DYWcA AU001Y 2026-05-06T12:16:48.152Z 2026-05-06T12:17:26.569Z
9851737 9851737 20260504194318_YYn2T AU001Y 2026-05-06T12:16:44.922Z 2026-05-06T12:17:26.555Z
9851655 9851655 20260504192015_dzHRa AU001Y 2026-05-06T12:16:37.285Z 2026-05-06T12:17:26.516Z
9851648 9851648 20260504191952_o7YCi AU001Y 2026-05-06T12:16:37.107Z 2026-05-06T12:17:26.513Z
9851624 9851624 20260504191120_nO4IY AU001Y 2026-05-06T12:16:32.508Z 2026-05-06T12:17:26.478Z
9851609 9851609 20260504190606_tUnc7 AU001Y 2026-05-06T12:16:31.014Z 2026-05-06T12:17:26.462Z
9851607 9851607 20260504190554_LpLCD AU001Y 2026-05-06T12:16:30.876Z 2026-05-06T12:17:26.461Z
9851589 9851589 20260504185033_TgP8S AU001Y 2026-05-06T12:16:27.152Z 2026-05-06T12:17:26.430Z
9851569 9851569 20260504184213_r2h9h AU001Y 2026-05-06T12:16:24.187Z 2026-05-06T12:17:26.406Z
9851563 9851563 20260504184053_KYsCT AU001Y 2026-05-06T12:16:23.295Z 2026-05-06T12:17:26.401Z
9851560 9851560 20260504184047_u2Twg AU001Y 2026-05-06T12:16:23.111Z 2026-05-06T12:17:26.400Z
9851520 9851520 20260504182801_vk0zI AU001Y 2026-05-06T12:15:48.935Z 2026-05-06T12:17:26.359Z
9851510 9851510 20260504182152_VNxCk AU001Y 2026-05-06T12:15:47.359Z 2026-05-06T12:17:26.347Z
9851504 9851504 20260504182019_3w0i7 AU001Y 2026-05-06T12:15:46.652Z 2026-05-06T12:17:26.338Z
9851471 9851471 20260504175521_2LcKn AU001Y 2026-05-06T12:15:34.139Z 2026-05-06T12:17:26.187Z
9851468 9851468 20260504175219_aJdxN AU001Y 2026-05-06T12:15:33.550Z 2026-05-06T12:17:26.181Z
9851466 9851466 20260504175208_v3bxA AU001Y 2026-05-06T12:15:33.378Z 2026-05-06T12:17:26.179Z
9851445 9851445 20260504173201_sVuio AU001Y 2026-05-06T12:15:02.360Z 2026-05-06T12:17:26.110Z
9851427 9851427 20260504171235_f2Fzg AU001Y 2026-05-06T12:14:50.965Z 2026-05-06T12:17:25.669Z
9851384 9851384 20260504161930_F73Qd AU001Y 2026-05-06T12:14:07.613Z 2026-05-06T12:17:25.511Z
9851364 9851364 20260504160519_ryb9V AU001Y 2026-05-06T12:14:01.869Z 2026-05-06T12:17:25.467Z
9851353 9851353 20260504155304_KggO3 AU001Y 2026-05-06T12:13:58.146Z 2026-05-06T12:17:25.442Z
9851347 9851347 20260504154623_uWoDw AU001Y 2026-05-06T12:13:54.916Z 2026-05-06T12:17:25.418Z
9851324 9851324 20260504151002_mDjnX AU001Y 2026-05-06T12:13:19.447Z 2026-05-06T12:17:25.308Z
9851278 9851278 20260504135936_lHCGa AU001Y 2026-05-06T12:12:34.056Z 2026-05-06T12:17:24.950Z
9851266 9851266 20260504134102_ahM0E AU001Y 2026-05-06T12:12:30.118Z 2026-05-06T12:17:24.918Z
9851259 9851259 20260504134029_p9Xaq AU001Y 2026-05-06T12:12:29.459Z 2026-05-06T12:17:24.913Z
9851246 9851246 20260504132430_3nMKI AU001Y 2026-05-06T12:12:07.406Z 2026-05-06T12:17:24.882Z
9851231 9851231 20260504130422_HqWgQ AU001Y 2026-05-06T12:11:58.468Z 2026-05-06T12:17:24.834Z
9851178 9851178 20260504120635_OXDZC AU001Y 2026-05-06T12:11:49.447Z 2026-05-06T12:17:24.741Z
9851169 9851169 20260504115917_lu2Zx AU001Y 2026-05-06T12:11:48.122Z 2026-05-06T12:17:24.729Z
9851159 9851159 20260504113953_LVCNX AU001Y 2026-05-06T12:11:45.538Z 2026-05-06T12:17:24.706Z
9851126 9851126 20260504102759_17r17 AU001Y 2026-05-06T12:11:29.763Z 2026-05-06T12:17:24.625Z
9846767 9846767 20260504202755_3YJAf AU001Y 2026-05-06T12:00:25.877Z 2026-05-06T12:17:20.872Z
9846727 9846727 20260504202224_Pcq2P AU001Y 2026-05-06T12:00:18.709Z 2026-05-06T12:17:20.859Z
9846683 9846683 20260504200721_apeNX AU001Y 2026-05-06T12:00:10.338Z 2026-05-06T12:17:20.843Z
9846614 9846614 20260503185120_n9NCZ AU001Y 2026-05-05T12:17:01.095Z 2026-05-06T12:21:25.295Z
9846608 9846608 20260503184909_y0W2n AU001Y 2026-05-05T12:17:00.848Z 2026-05-06T12:21:25.203Z
9846599 9846599 20260503184514_OIl31 AU001Y 2026-05-05T12:16:59.916Z 2026-05-06T12:21:24.958Z
9846590 9846590 20260503184137_5p2Ov AU001Y 2026-05-05T12:16:58.596Z 2026-05-06T12:21:23.071Z
9846528 9846528 20260503180228_bLKx3 AU001Y 2026-05-05T12:16:49.310Z 2026-05-06T12:21:20.626Z
9846522 9846522 20260503175732_H47bu AU001Y 2026-05-05T12:16:47.853Z 2026-05-06T12:21:20.272Z
9846505 9846505 20260503175019_JyHE3 AU001Y 2026-05-05T12:16:30.824Z 2026-05-06T12:21:19.645Z
9846441 9846441 20260503170111_WEYv3 AU001Y 2026-05-05T12:16:08.879Z 2026-05-06T12:21:14.665Z
9846416 9846416 20260503163741_VVHE3 AU001Y 2026-05-05T12:15:51.853Z 2026-05-06T12:21:12.931Z
9846384 9846384 20260503160044_jf8DW AU001Y 2026-05-05T12:15:35.859Z 2026-05-06T12:21:10.248Z
9846374 9846374 20260503154734_FgYcf AU001Y 2026-05-05T12:15:32.976Z 2026-05-06T12:21:09.389Z
9846352 9846352 20260503151947_rWpSI AU001Y 2026-05-05T12:15:27.424Z 2026-05-06T12:21:07.915Z
9846341 9846341 20260503151400_Fr4Hl AU001Y 2026-05-05T12:15:25.595Z 2026-05-06T12:20:59.976Z
9846329 9846329 20260503150127_xbqV8 AU001Y 2026-05-05T12:15:11.328Z 2026-05-06T12:20:49.574Z
9846296 9846296 20260503135016_esD0O AU001Y 2026-05-05T12:14:58.616Z 2026-05-06T12:20:45.813Z
9846292 9846292 20260503134624_pGfWb AU001Y 2026-05-05T12:14:58.049Z 2026-05-06T12:20:45.617Z
9846287 9846287 20260503133823_xtcyQ AU001Y 2026-05-05T12:14:57.443Z 2026-05-06T12:20:45.417Z
9846273 9846273 20260503131052_sWEhf AU001Y 2026-05-05T12:14:54.048Z 2026-05-06T12:20:42.616Z
9846271 9846271 20260503130349_1GD7H AU001Y 2026-05-05T12:14:53.294Z 2026-05-06T12:20:42.223Z
9846252 9846252 20260503121816_PuBra AU001Y 2026-05-05T12:14:48.935Z 2026-05-06T12:20:40.283Z
9846240 9846240 20260503113318_GELif AU001Y 2026-05-05T12:14:45.314Z 2026-05-06T12:20:38.728Z
9846238 9846238 20260503112858_RMJzL AU001Y 2026-05-05T12:14:41.547Z 2026-05-06T12:20:38.644Z
9846235 9846235 20260503111645_FMBkU AU001Y 2026-05-05T12:14:38.030Z 2026-05-06T12:20:38.303Z
9841648 9841648 20260503193458_O8xZe AU001Y 2026-05-05T12:00:20.174Z 2026-05-06T12:17:23.627Z
9841646 9841646 20260503193430_fU3e8 AU001Y 2026-05-05T12:00:19.814Z 2026-05-06T12:17:23.626Z
9841638 9841638 20260503192928_cSpPT AU001Y 2026-05-05T12:00:17.504Z 2026-05-06T12:17:23.621Z
9841465 9841465 20260501162742_uw55G AU001Y 2026-05-04T12:22:15.037Z 2026-05-06T12:27:28.940Z
9841463 9841463 20260501162444_nwGWD AU001Y 2026-05-04T12:22:14.554Z 2026-05-06T12:27:28.728Z
9841451 9841451 20260501160437_hjitL AU001Y 2026-05-04T12:22:03.200Z 2026-05-06T12:27:27.274Z
9841447 9841447 20260501155924_djlcr AU001Y 2026-05-04T12:22:02.250Z 2026-05-06T12:27:26.882Z
9841429 9841429 20260501153701_H3oGF AU001Y 2026-05-04T12:21:57.294Z 2026-05-06T12:27:24.044Z
9841422 9841422 20260501152539_TZP67 AU001Y 2026-05-04T12:21:55.376Z 2026-05-06T12:27:23.576Z
9841386 9841386 20260501140803_WRlK0 AU001Y 2026-05-04T12:21:43.879Z 2026-05-06T12:27:20.016Z
9841384 9841384 20260501134542_2ofUl AU001Y 2026-05-04T12:21:35.687Z 2026-05-06T12:27:19.218Z
9841379 9841379 20260501134326_JymL5 AU001Y 2026-05-04T12:21:35.200Z 2026-05-06T12:27:19.095Z
9841375 9841375 20260501132644_EjPe1 AU001Y 2026-05-04T12:21:33.373Z 2026-05-06T12:27:18.373Z
9841371 9841371 20260501125721_PFrDZ AU001Y 2026-05-04T12:21:31.884Z 2026-05-06T12:27:17.755Z
9841369 9841369 20260501124733_upR80 AU001Y 2026-05-04T12:21:28.435Z 2026-05-06T12:27:17.168Z
9841364 9841364 20260501124456_n3eWW AU001Y 2026-05-04T12:21:27.971Z 2026-05-06T12:27:17.053Z
9841361 9841361 20260501123811_FP12h AU001Y 2026-05-04T12:21:26.552Z 2026-05-06T12:27:16.586Z
9841350 9841350 20260501120421_okRWR AU001Y 2026-05-04T12:21:22.986Z 2026-05-06T12:27:15.201Z
9841346 9841346 20260501113633_1TIta AU001Y 2026-05-04T12:21:20.032Z 2026-05-06T12:27:14.332Z
9841338 9841338 20260501111923_hPiXs AU001Y 2026-05-04T12:21:15.866Z 2026-05-06T12:27:13.588Z
9841332 9841332 20260501111649_Qkfh2 AU001Y 2026-05-04T12:21:14.476Z 2026-05-06T12:27:13.396Z
9841257 9841257 20260502174502_xzlL4 AU001Y 2026-05-04T12:17:20.244Z 2026-05-06T12:24:14.625Z
9841239 9841239 20260502171847_2M3Z9 AU001Y 2026-05-04T12:16:58.340Z 2026-05-06T12:24:12.052Z
9841228 9841228 20260502170145_JAHiJ AU001Y 2026-05-04T12:16:45.850Z 2026-05-06T12:24:07.732Z
9841218 9841218 20260502164446_9qRr2 AU001Y 2026-05-04T12:16:32.965Z 2026-05-06T12:24:06.497Z
9841202 9841202 20260502161003_UuybS AU001Y 2026-05-04T12:16:11.469Z 2026-05-06T12:24:03.382Z
9841192 9841192 20260502154955_WzmqO AU001Y 2026-05-04T12:15:57.307Z 2026-05-06T12:24:01.222Z
9841179 9841179 20260502144053_XpZ8K AU001Y 2026-05-04T12:15:23.674Z 2026-05-06T12:23:56.154Z
9841174 9841174 20260502143349_U4Xxl AU001Y 2026-05-04T12:15:14.052Z 2026-05-06T12:23:54.931Z
9841169 9841169 20260502141951_vn1B4 AU001Y 2026-05-04T12:15:08.767Z 2026-05-06T12:23:54.273Z
9841165 9841165 20260502134340_PSMXi AU001Y 2026-05-04T12:15:00.365Z 2026-05-06T12:23:47.498Z
9838205 9838205 20260502183358_tXiYZ AU001Y 2026-05-04T12:00:15.781Z 2026-05-06T12:17:28.643Z
9833886 9833886 20260430151958_p32Hy AU001Y 2026-05-02T12:22:46.304Z 2026-05-06T12:31:22.306Z
9829604 9829604 20260429115921_Wa6Hx AU001Y 2026-05-01T12:26:48.736Z 2026-05-06T12:34:58.684Z
9824923 9824923 20260429215113_InOJS AU001Y 2026-05-01T12:06:34.626Z 2026-05-06T12:28:51.738Z
9824918 9824918 20260429214916_GwmWH AU001Y 2026-05-01T12:06:33.173Z 2026-05-06T12:28:51.669Z
9824764 9824764 20260429211315_TlZQ7 AU001Y 2026-05-01T12:05:53.501Z 2026-05-06T12:28:48.258Z
9804795 9804795 20260425132723_bEzN6 AU001Y 2026-04-27T12:52:23.801Z 2026-05-02T13:04:34.012Z
9804418 9804418 20260425125039_aw0RQ AU001Y 2026-04-27T12:51:44.215Z 2026-05-02T13:04:28.394Z
9803660 9803660 20260425112907_VS5YW AU001Y 2026-04-27T12:50:13.302Z 2026-05-02T13:04:04.043Z
9797662 9797662 20260425211510_9ThLn AU001Y 2026-04-27T12:20:25.844Z 2026-05-04T12:43:40.846Z

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