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
8683624 8683624 20251130192333_Mz4lr AU001A 2025-12-04T14:31:33.051Z 2025-12-04T14:31:33.051Z
8683429 8683429 20251201200036_ByyPT AU001A 2025-12-04T14:24:25.704Z 2025-12-04T14:24:25.704Z
8683359 8683359 20251201170628_bIHx6 AU001A 2025-12-04T14:23:38.762Z 2025-12-04T14:23:38.762Z
8678660 8678660 20251202164315_AiWqO AU001A 2025-12-04T14:07:47.657Z 2025-12-04T14:19:08.166Z
8673560 8673560 20251201200546_D7EDs AU001A 2025-12-03T14:19:18.136Z 2025-12-04T14:24:26.775Z
8673552 8673552 20251201200140_3C5rZ AU001A 2025-12-03T14:19:14.536Z 2025-12-04T14:24:26.204Z
8673529 8673529 20251201195346_JdEKu AU001A 2025-12-03T14:19:08.252Z 2025-12-04T14:24:24.700Z
8673525 8673525 20251201195227_bri4F AU001A 2025-12-03T14:19:07.352Z 2025-12-04T14:24:24.172Z
8673499 8673499 20251201194115_CzzbP AU001A 2025-12-03T14:19:00.958Z 2025-12-04T14:24:22.439Z
8673496 8673496 20251201194006_yik46 AU001A 2025-12-03T14:19:00.749Z 2025-12-04T14:24:22.336Z
8673478 8673478 20251201192450_dAYmR AU001A 2025-12-03T14:18:58.130Z 2025-12-04T14:24:21.323Z
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-04T14:24:20.715Z
8673471 8673471 20251201192320_s7tWJ AU001A 2025-12-03T14:18:56.864Z 2025-12-04T14:24:20.568Z
8673446 8673446 20251201191540_xoTr2 AU001A 2025-12-03T14:18:53.325Z 2025-12-04T14:24:18.622Z
8673440 8673440 20251201191235_2KrXt AU001A 2025-12-03T14:18:51.997Z 2025-12-04T14:24:17.917Z
8673396 8673396 20251201185510_y3d44 AU001A 2025-12-03T14:18:45.203Z 2025-12-04T14:24:13.353Z
8673383 8673383 20251201185007_hMF7O AU001A 2025-12-03T14:18:40.933Z 2025-12-04T14:24:08.322Z
8673378 8673378 20251201184827_Nej2W AU001A 2025-12-03T14:18:40.498Z 2025-12-04T14:24:07.987Z
8673363 8673363 20251201184546_MOJA9 AU001A 2025-12-03T14:18:28.332Z 2025-12-04T14:24:06.937Z
8673355 8673355 20251201183900_fT2y0 AU001A 2025-12-03T14:18:27.380Z 2025-12-04T14:24:05.545Z
8673342 8673342 20251201183352_gSyxw AU001A 2025-12-03T14:18:25.566Z 2025-12-04T14:24:04.821Z
8673340 8673340 20251201183156_W2e83 AU001A 2025-12-03T14:18:25.009Z 2025-12-04T14:24:04.694Z
8673311 8673311 20251201182129_Dwh2w AU001A 2025-12-03T14:18:15.106Z 2025-12-04T14:24:00.209Z
8673291 8673291 20251201181038_haeFW AU001A 2025-12-03T14:18:12.305Z 2025-12-04T14:23:57.652Z
8673281 8673281 20251201180829_7Ygp9 AU001A 2025-12-03T14:18:10.931Z 2025-12-04T14:23:57.141Z
8673272 8673272 20251201175927_9yYTZ AU001A 2025-12-03T14:18:09.464Z 2025-12-04T14:23:55.860Z
8673235 8673235 20251201174040_Y78CT AU001A 2025-12-03T14:18:03.248Z 2025-12-04T14:23:52.018Z
8673210 8673210 20251201173046_EVE6w AU001A 2025-12-03T14:17:59.378Z 2025-12-04T14:23:50.012Z
8673192 8673192 20251201172604_7Akak AU001A 2025-12-03T14:17:49.589Z 2025-12-04T14:23:48.761Z
8673191 8673191 20251201172538_2bbt3 AU001A 2025-12-03T14:17:49.364Z 2025-12-04T14:23:48.642Z
8673186 8673186 20251201172400_3ZtGR AU001A 2025-12-03T14:17:48.740Z 2025-12-04T14:23:48.330Z
8673177 8673177 20251201172109_GZvFc AU001A 2025-12-03T14:17:47.130Z 2025-12-04T14:23:47.147Z
8673168 8673168 20251201172019_i7GlD AU001A 2025-12-03T14:17:44.344Z 2025-12-04T14:23:46.247Z
8673151 8673151 20251201171023_QQ4Zr AU001A 2025-12-03T14:17:40.787Z 2025-12-04T14:23:39.878Z
8673134 8673134 20251201170629_HtZMV AU001A 2025-12-03T14:17:38.547Z 2025-12-04T14:23:38.913Z
8673114 8673114 20251201165859_Vq1ta AU001A 2025-12-03T14:17:35.770Z 2025-12-04T14:23:37.598Z
8673098 8673098 20251201165436_5cwyD AU001A 2025-12-03T14:17:33.174Z 2025-12-04T14:23:34.652Z
8673048 8673048 20251201163108_AbN3c AU001A 2025-12-03T14:17:14.714Z 2025-12-04T14:23:31.081Z
8672998 8672998 20251201161512_wvFJO AU001A 2025-12-03T14:17:05.958Z 2025-12-04T14:23:28.776Z
8672993 8672993 20251201161309_nCROj AU001A 2025-12-03T14:17:04.888Z 2025-12-04T14:23:27.810Z
8672989 8672989 20251201161029_CK5yN AU001A 2025-12-03T14:17:04.543Z 2025-12-04T14:23:27.694Z
8672987 8672987 20251201160702_4odtA AU001A 2025-12-03T14:17:04.045Z 2025-12-04T14:23:27.486Z
8672981 8672981 20251201160539_2clOc AU001A 2025-12-03T14:17:03.443Z 2025-12-04T14:23:27.145Z
8672980 8672980 20251201160506_g3Tm6 AU001A 2025-12-03T14:17:03.078Z 2025-12-04T14:23:26.980Z
8672960 8672960 20251201155501_T2TtB AU001A 2025-12-03T14:17:01.002Z 2025-12-04T14:23:25.664Z
8672861 8672861 20251201153131_NM26H AU001A 2025-12-03T14:16:43.166Z 2025-12-04T14:23:18.230Z
8672852 8672852 20251201152858_xj7rm AU001A 2025-12-03T14:16:41.925Z 2025-12-04T14:23:14.467Z
8672561 8672561 20251201144649_IpJR0 AU001A 2025-12-03T14:15:54.648Z 2025-12-04T14:22:58.262Z
8672490 8672490 20251201143609_ld5WL AU001A 2025-12-03T14:15:39.440Z 2025-12-04T14:22:53.633Z
8672315 8672315 20251201141455_11uxH AU001A 2025-12-03T14:15:16.762Z 2025-12-04T14:22:41.633Z
8666733 8666733 20251130194551_eapww AU001A 2025-12-02T14:27:13.762Z 2025-12-04T14:31:40.245Z
8666725 8666725 20251130192608_oPuLX AU001A 2025-12-02T14:27:12.667Z 2025-12-04T14:31:34.071Z
8666717 8666717 20251130191258_mO9BA AU001A 2025-12-02T14:27:11.906Z 2025-12-04T14:31:28.661Z
8666712 8666712 20251130190903_U35Az AU001A 2025-12-02T14:27:11.421Z 2025-12-04T14:31:26.922Z
8666704 8666704 20251130184804_xaco9 AU001A 2025-12-02T14:27:10.660Z 2025-12-04T14:31:16.520Z
8666692 8666692 20251130184145_8rc5w AU001A 2025-12-02T14:27:09.343Z 2025-12-04T14:31:08.581Z
8666671 8666671 20251130183028_oWAXI AU001A 2025-12-02T14:27:06.002Z 2025-12-04T14:31:02.527Z
8666665 8666665 20251130182455_rEvQC AU001A 2025-12-02T14:27:05.290Z 2025-12-04T14:31:00.725Z
8666653 8666653 20251130175249_ry3nN AU001A 2025-12-02T14:27:03.632Z 2025-12-04T14:30:52.029Z
8666646 8666646 20251130173031_aeqYC AU001A 2025-12-02T14:27:02.532Z 2025-12-04T14:30:32.006Z
8666627 8666627 20251130164838_PyW2T AU001A 2025-12-02T14:27:00.301Z 2025-12-04T14:30:16.700Z
8663044 8663044 20251130195951_e59t8 AU001A 2025-12-02T14:17:19.731Z 2025-12-04T14:31:47.384Z
8662894 8662894 20251130194620_uM1RI AU001A 2025-12-02T14:16:58.453Z 2025-12-04T14:31:40.591Z
8662840 8662840 20251130193844_hHboM AU001A 2025-12-02T14:16:50.246Z 2025-12-04T14:31:38.339Z
8662812 8662812 20251130193453_85l7x AU001A 2025-12-02T14:16:47.117Z 2025-12-04T14:31:37.459Z
8662638 8662638 20251130191715_7vU2F AU001A 2025-12-02T14:16:05.641Z 2025-12-04T14:31:30.141Z
8662495 8662495 20251130185908_Zk2eB AU001A 2025-12-02T14:15:44.015Z 2025-12-04T14:31:24.618Z
8662439 8662439 20251130185016_O3Dq1 AU001A 2025-12-02T14:15:28.721Z 2025-12-04T14:31:22.034Z
8662391 8662391 20251130184249_ynOlU AU001A 2025-12-02T14:15:20.593Z 2025-12-04T14:31:08.795Z
8662362 8662362 20251130183903_m0KNc AU001A 2025-12-02T14:15:14.860Z 2025-12-04T14:31:07.376Z
8662225 8662225 20251130181946_wwjSy AU001A 2025-12-02T14:14:44.542Z 2025-12-04T14:30:59.198Z
8662177 8662177 20251130181331_IvRxk AU001A 2025-12-02T14:14:37.104Z 2025-12-04T14:30:57.190Z
8662125 8662125 20251130180223_v3ctR AU001A 2025-12-02T14:14:23.560Z 2025-12-04T14:30:54.278Z
8662051 8662051 20251130174804_eCc99 AU001A 2025-12-02T14:14:06.105Z 2025-12-04T14:30:50.326Z
8661929 8661929 20251130173353_KY72p AU001A 2025-12-02T14:13:38.803Z 2025-12-04T14:30:42.942Z
8661915 8661915 20251130173044_WBK4q AU001A 2025-12-02T14:13:36.617Z 2025-12-04T14:30:40.001Z
8661889 8661889 20251130172948_8ThfZ AU001A 2025-12-02T14:13:32.781Z 2025-12-04T14:30:31.255Z
8661866 8661866 20251130172454_5VENF AU001A 2025-12-02T14:13:20.326Z 2025-12-04T14:30:29.500Z
8661826 8661826 20251130171916_oTCFH AU001A 2025-12-02T14:13:10.121Z 2025-12-04T14:30:27.006Z
8661809 8661809 20251130171553_zUKNd AU001A 2025-12-02T14:13:06.956Z 2025-12-04T14:30:24.186Z
8661691 8661691 20251130165434_52yF1 AU001A 2025-12-02T14:12:37.561Z 2025-12-04T14:30:17.754Z
8661657 8661657 20251130164414_silEw AU001A 2025-12-02T14:12:29.692Z 2025-12-04T14:30:14.910Z
8661614 8661614 20251130162921_L6pXC AU001A 2025-12-02T14:12:19.529Z 2025-12-04T14:30:11.972Z
8661389 8661389 20251130151454_m8Atg AU001A 2025-12-02T14:11:13.760Z 2025-12-04T14:29:47.877Z
8661247 8661247 20251130150240_VHYPj AU001A 2025-12-02T14:10:56.370Z 2025-12-04T14:29:41.988Z
8661206 8661206 20251130145949_oyNn3 AU001A 2025-12-02T14:10:49.410Z 2025-12-04T14:29:40.250Z
8661158 8661158 20251130145118_BFSAo AU001A 2025-12-02T14:10:34.175Z 2025-12-04T14:29:37.776Z
8661116 8661116 20251130144427_uwquc AU001A 2025-12-02T14:10:27.114Z 2025-12-04T14:29:36.154Z
8660839 8660839 20251130140010_s2S1i AU001A 2025-12-02T14:09:23.433Z 2025-12-04T14:29:14.433Z
8648516 8648516 20251127142128_STqTz AU001A 2025-11-30T14:33:15.862Z 2025-12-04T14:53:28.513Z
8644808 8644808 20251128195957_b4zgO AU001A 2025-11-30T14:22:44.135Z 2025-12-04T14:48:35.891Z
8644744 8644744 20251128195103_NW7Ah AU001A 2025-11-30T14:22:22.030Z 2025-12-04T14:48:34.789Z
8644715 8644715 20251128194716_NSpOe AU001A 2025-11-30T14:22:20.060Z 2025-12-04T14:48:34.191Z
8644681 8644681 20251128194351_RyAK6 AU001A 2025-11-30T14:22:14.336Z 2025-12-04T14:48:33.491Z
8644661 8644661 20251128194133_2Ktg5 AU001A 2025-11-30T14:22:13.142Z 2025-12-04T14:48:33.146Z
8644638 8644638 20251128193845_7XIjf AU001A 2025-11-30T14:22:10.991Z 2025-12-04T14:48:32.633Z
8644636 8644636 20251128193832_apbKT AU001A 2025-11-30T14:22:10.788Z 2025-12-04T14:48:32.546Z
8644623 8644623 20251128193749_8wh3n AU001A 2025-11-30T14:22:10.202Z 2025-12-04T14:48:32.295Z
8644597 8644597 20251128193610_y4LaV AU001A 2025-11-30T14:22:08.369Z 2025-12-04T14:48:29.412Z

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