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 = "AU001A" 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
8719655 8719655 20251207165031_v2Qa8 AU001A 2025-12-11T14:24:51.839Z 2025-12-11T14:24:51.839Z
8698785 8698785 20251206165737_Ug2FY AU001A 2025-12-08T14:18:57.179Z 2025-12-11T14:30:44.831Z
8698771 8698771 20251206163838_oeS9m AU001A 2025-12-08T14:18:53.949Z 2025-12-11T14:30:43.335Z
8698749 8698749 20251206161851_dN3ta AU001A 2025-12-08T14:18:49.512Z 2025-12-11T14:30:42.076Z
8698745 8698745 20251206161739_BKdPg AU001A 2025-12-08T14:18:47.847Z 2025-12-11T14:30:41.687Z
8698709 8698709 20251206153655_Hu7fK AU001A 2025-12-08T14:18:32.806Z 2025-12-11T14:30:38.323Z
8698684 8698684 20251206151937_77P3W AU001A 2025-12-08T14:18:25.194Z 2025-12-11T14:30:35.541Z
8698682 8698682 20251206151220_LH0M2 AU001A 2025-12-08T14:18:22.497Z 2025-12-11T14:30:33.561Z
8698675 8698675 20251206145657_qU6BO AU001A 2025-12-08T14:18:19.890Z 2025-12-11T14:30:32.475Z
8698671 8698671 20251206143849_p6ITY AU001A 2025-12-08T14:18:15.243Z 2025-12-11T14:30:29.864Z
8698666 8698666 20251206143443_Km2qn AU001A 2025-12-08T14:18:14.093Z 2025-12-11T14:30:29.286Z
8698664 8698664 20251206143425_JuI13 AU001A 2025-12-08T14:18:13.602Z 2025-12-11T14:30:28.953Z
8698661 8698661 20251206143121_azoNu AU001A 2025-12-08T14:18:08.548Z 2025-12-11T14:30:28.527Z
8698658 8698658 20251206142305_qLMq8 AU001A 2025-12-08T14:18:06.760Z 2025-12-11T14:30:27.083Z
8698656 8698656 20251206141519_WdLoi AU001A 2025-12-08T14:18:05.253Z 2025-12-11T14:30:22.821Z
8698651 8698651 20251206141134_D3AzW AU001A 2025-12-08T14:18:04.605Z 2025-12-11T14:30:18.490Z
8698639 8698639 20251206140316_ugCh8 AU001A 2025-12-08T14:18:00.148Z 2025-12-11T14:30:12.822Z
8698632 8698632 20251206134659_ysqiK AU001A 2025-12-08T14:17:52.147Z 2025-12-11T14:30:10.022Z
8698628 8698628 20251206134212_NphhU AU001A 2025-12-08T14:17:49.823Z 2025-12-11T14:30:09.314Z
8698274 8698274 20251207180510_J5adx AU001A 2025-12-08T14:14:31.893Z 2025-12-11T14:25:04.669Z
8698243 8698243 20251207175020_PFZWD AU001A 2025-12-08T14:14:26.575Z 2025-12-11T14:25:00.617Z
8698171 8698171 20251207170403_hN63n AU001A 2025-12-08T14:14:06.729Z 2025-12-11T14:24:54.558Z
8698103 8698103 20251207163804_9H1QI AU001A 2025-12-08T14:13:55.061Z 2025-12-11T14:24:48.676Z
8698081 8698081 20251207160817_R5dM1 AU001A 2025-12-08T14:13:50.372Z 2025-12-11T14:24:46.814Z
8698071 8698071 20251207155832_qAyfI AU001A 2025-12-08T14:13:49.081Z 2025-12-11T14:24:46.394Z
8697884 8697884 20251207152342_gZyNg AU001A 2025-12-08T14:13:11.905Z 2025-12-11T14:24:28.828Z
8697622 8697622 20251207144823_dztxa AU001A 2025-12-08T14:12:13.923Z 2025-12-11T14:24:17.065Z
8697592 8697592 20251207144106_4Btka AU001A 2025-12-08T14:12:06.716Z 2025-12-11T14:24:15.089Z
8697438 8697438 20251207141733_2eP1c AU001A 2025-12-08T14:11:37.727Z 2025-12-11T14:24:03.337Z
8697126 8697126 20251207133911_W32Ze AU001A 2025-12-08T14:10:32.821Z 2025-12-11T14:23:44.963Z
8687370 8687370 20251201163108_Hfcq2 AU001A 2025-12-05T14:25:55.821Z 2025-12-10T14:38:11.467Z
8683624 8683624 20251130192333_Mz4lr AU001A 2025-12-04T14:31:33.051Z 2025-12-09T14:57:15.014Z
8683429 8683429 20251201200036_ByyPT AU001A 2025-12-04T14:24:25.704Z 2025-12-10T14:38:25.160Z
8683359 8683359 20251201170628_bIHx6 AU001A 2025-12-04T14:23:38.762Z 2025-12-10T14:38:13.177Z
8678660 8678660 20251202164315_AiWqO AU001A 2025-12-04T14:07:47.657Z 2025-12-11T14:43:55.082Z
8673560 8673560 20251201200546_D7EDs AU001A 2025-12-03T14:19:18.136Z 2025-12-10T14:38:25.522Z
8673552 8673552 20251201200140_3C5rZ AU001A 2025-12-03T14:19:14.536Z 2025-12-10T14:38:25.317Z
8673529 8673529 20251201195346_JdEKu AU001A 2025-12-03T14:19:08.252Z 2025-12-10T14:38:24.769Z
8673525 8673525 20251201195227_bri4F AU001A 2025-12-03T14:19:07.352Z 2025-12-10T14:38:24.649Z
8673499 8673499 20251201194115_CzzbP AU001A 2025-12-03T14:19:00.958Z 2025-12-10T14:38:24.056Z
8673496 8673496 20251201194006_yik46 AU001A 2025-12-03T14:19:00.749Z 2025-12-10T14:38:23.993Z
8673478 8673478 20251201192450_dAYmR AU001A 2025-12-03T14:18:58.130Z 2025-12-10T14:38:23.482Z
8673476 8673476 20251201192355_QIKIi AU001A 2025-12-03T14:18:57.736Z 2025-12-03T14:18:57.736Z
8673474 8673474 20251201192337_9kfR3 AU001A 2025-12-03T14:18:57.022Z 2025-12-10T14:38:23.322Z
8673471 8673471 20251201192320_s7tWJ AU001A 2025-12-03T14:18:56.864Z 2025-12-10T14:38:23.292Z
8673446 8673446 20251201191540_xoTr2 AU001A 2025-12-03T14:18:53.325Z 2025-12-10T14:38:22.774Z
8673440 8673440 20251201191235_2KrXt AU001A 2025-12-03T14:18:51.997Z 2025-12-10T14:38:22.558Z
8673396 8673396 20251201185510_y3d44 AU001A 2025-12-03T14:18:45.203Z 2025-12-10T14:38:20.116Z
8673383 8673383 20251201185007_hMF7O AU001A 2025-12-03T14:18:40.933Z 2025-12-10T14:38:19.747Z
8673378 8673378 20251201184827_Nej2W AU001A 2025-12-03T14:18:40.498Z 2025-12-10T14:38:19.647Z
8673363 8673363 20251201184546_MOJA9 AU001A 2025-12-03T14:18:28.332Z 2025-12-10T14:38:19.264Z
8673355 8673355 20251201183900_fT2y0 AU001A 2025-12-03T14:18:27.380Z 2025-12-10T14:38:19.025Z
8673342 8673342 20251201183352_gSyxw AU001A 2025-12-03T14:18:25.566Z 2025-12-10T14:38:18.727Z
8673340 8673340 20251201183156_W2e83 AU001A 2025-12-03T14:18:25.009Z 2025-12-10T14:38:18.622Z
8673311 8673311 20251201182129_Dwh2w AU001A 2025-12-03T14:18:15.106Z 2025-12-10T14:38:18.175Z
8673291 8673291 20251201181038_haeFW AU001A 2025-12-03T14:18:12.305Z 2025-12-10T14:38:17.661Z
8673281 8673281 20251201180829_7Ygp9 AU001A 2025-12-03T14:18:10.931Z 2025-12-10T14:38:17.506Z
8673272 8673272 20251201175927_9yYTZ AU001A 2025-12-03T14:18:09.464Z 2025-12-10T14:38:17.181Z
8673235 8673235 20251201174040_Y78CT AU001A 2025-12-03T14:18:03.248Z 2025-12-10T14:38:15.930Z
8673210 8673210 20251201173046_EVE6w AU001A 2025-12-03T14:17:59.378Z 2025-12-10T14:38:15.048Z
8673192 8673192 20251201172604_7Akak AU001A 2025-12-03T14:17:49.589Z 2025-12-10T14:38:14.655Z
8673191 8673191 20251201172538_2bbt3 AU001A 2025-12-03T14:17:49.364Z 2025-12-10T14:38:14.629Z
8673186 8673186 20251201172400_3ZtGR AU001A 2025-12-03T14:17:48.740Z 2025-12-10T14:38:14.538Z
8673177 8673177 20251201172109_GZvFc AU001A 2025-12-03T14:17:47.130Z 2025-12-10T14:38:14.189Z
8673168 8673168 20251201172019_i7GlD AU001A 2025-12-03T14:17:44.344Z 2025-12-10T14:38:13.996Z
8673151 8673151 20251201171023_QQ4Zr AU001A 2025-12-03T14:17:40.787Z 2025-12-10T14:38:13.491Z
8673134 8673134 20251201170629_HtZMV AU001A 2025-12-03T14:17:38.547Z 2025-12-10T14:38:13.208Z
8673114 8673114 20251201165859_Vq1ta AU001A 2025-12-03T14:17:35.770Z 2025-12-10T14:38:12.934Z
8673098 8673098 20251201165436_5cwyD AU001A 2025-12-03T14:17:33.174Z 2025-12-10T14:38:12.580Z
8673048 8673048 20251201163108_AbN3c AU001A 2025-12-03T14:17:14.714Z 2025-12-10T14:38:11.493Z
8672998 8672998 20251201161512_wvFJO AU001A 2025-12-03T14:17:05.958Z 2025-12-10T14:38:10.662Z
8672993 8672993 20251201161309_nCROj AU001A 2025-12-03T14:17:04.888Z 2025-12-10T14:38:10.431Z
8672989 8672989 20251201161029_CK5yN AU001A 2025-12-03T14:17:04.543Z 2025-12-10T14:38:10.405Z
8672987 8672987 20251201160702_4odtA AU001A 2025-12-03T14:17:04.045Z 2025-12-10T14:38:10.372Z
8672981 8672981 20251201160539_2clOc AU001A 2025-12-03T14:17:03.443Z 2025-12-10T14:38:10.345Z
8672980 8672980 20251201160506_g3Tm6 AU001A 2025-12-03T14:17:03.078Z 2025-12-10T14:38:10.290Z
8672960 8672960 20251201155501_T2TtB AU001A 2025-12-03T14:17:01.002Z 2025-12-10T14:38:09.804Z
8672861 8672861 20251201153131_NM26H AU001A 2025-12-03T14:16:43.166Z 2025-12-10T14:38:07.960Z
8672852 8672852 20251201152858_xj7rm AU001A 2025-12-03T14:16:41.925Z 2025-12-10T14:38:07.830Z
8672561 8672561 20251201144649_IpJR0 AU001A 2025-12-03T14:15:54.648Z 2025-12-10T14:37:56.982Z
8672490 8672490 20251201143609_ld5WL AU001A 2025-12-03T14:15:39.440Z 2025-12-10T14:37:55.786Z
8672315 8672315 20251201141455_11uxH AU001A 2025-12-03T14:15:16.762Z 2025-12-10T14:37:46.839Z
8666733 8666733 20251130194551_eapww AU001A 2025-12-02T14:27:13.762Z 2025-12-09T14:57:21.128Z
8666725 8666725 20251130192608_oPuLX AU001A 2025-12-02T14:27:12.667Z 2025-12-09T14:57:15.973Z
8666717 8666717 20251130191258_mO9BA AU001A 2025-12-02T14:27:11.906Z 2025-12-09T14:57:03.757Z
8666712 8666712 20251130190903_U35Az AU001A 2025-12-02T14:27:11.421Z 2025-12-09T14:56:53.386Z
8666704 8666704 20251130184804_xaco9 AU001A 2025-12-02T14:27:10.660Z 2025-12-09T14:56:39.741Z
8666692 8666692 20251130184145_8rc5w AU001A 2025-12-02T14:27:09.343Z 2025-12-09T14:56:38.951Z
8666671 8666671 20251130183028_oWAXI AU001A 2025-12-02T14:27:06.002Z 2025-12-09T14:56:36.594Z
8666665 8666665 20251130182455_rEvQC AU001A 2025-12-02T14:27:05.290Z 2025-12-09T14:56:33.888Z
8666653 8666653 20251130175249_ry3nN AU001A 2025-12-02T14:27:03.632Z 2025-12-09T14:56:28.640Z
8666646 8666646 20251130173031_aeqYC AU001A 2025-12-02T14:27:02.532Z 2025-12-09T14:56:23.835Z
8666627 8666627 20251130164838_PyW2T AU001A 2025-12-02T14:27:00.301Z 2025-12-09T14:56:17.190Z
8663044 8663044 20251130195951_e59t8 AU001A 2025-12-02T14:17:19.731Z 2025-12-09T14:57:23.738Z
8662894 8662894 20251130194620_uM1RI AU001A 2025-12-02T14:16:58.453Z 2025-12-09T14:57:21.336Z
8662840 8662840 20251130193844_hHboM AU001A 2025-12-02T14:16:50.246Z 2025-12-09T14:57:19.638Z
8662812 8662812 20251130193453_85l7x AU001A 2025-12-02T14:16:47.117Z 2025-12-09T14:57:18.889Z
8662638 8662638 20251130191715_7vU2F AU001A 2025-12-02T14:16:05.641Z 2025-12-09T14:57:09.888Z
8662495 8662495 20251130185908_Zk2eB AU001A 2025-12-02T14:15:44.015Z 2025-12-09T14:56:41.810Z
8662439 8662439 20251130185016_O3Dq1 AU001A 2025-12-02T14:15:28.721Z 2025-12-09T14:56:40.331Z

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