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 = "AU000V" 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
9271795 9271795 20260127201427_ml3in AU000V 2026-01-29T14:23:52.938Z 2026-01-29T14:30:25.147Z
9271786 9271786 20260127201057_fev5N AU000V 2026-01-29T14:23:50.364Z 2026-01-29T14:30:25.144Z
9271606 9271606 20260127183023_GUUZn AU000V 2026-01-29T14:21:44.916Z 2026-01-29T14:30:24.965Z
9271581 9271581 20260127181501_3sgOe AU000V 2026-01-29T14:21:37.437Z 2026-01-29T14:30:24.939Z
9271503 9271503 20260127171829_0kAcW AU000V 2026-01-29T14:20:58.980Z 2026-01-29T14:30:24.852Z
9271170 9271170 20260128201833_Cfh5H AU000V 2026-01-29T14:15:30.205Z 2026-01-29T14:15:30.205Z
9271083 9271083 20260128194820_sxQG8 AU000V 2026-01-29T14:15:09.509Z 2026-01-29T14:15:09.509Z
9270836 9270836 20260128180320_dqcm4 AU000V 2026-01-29T14:14:10.433Z 2026-01-29T14:14:10.433Z
9270277 9270277 20260128152343_Xx77d AU000V 2026-01-29T14:11:31.295Z 2026-01-29T14:11:31.295Z
9267199 9267199 20260126202637_8GbDg AU000V 2026-01-28T14:20:16.152Z 2026-01-29T14:34:33.000Z
9267189 9267189 20260126202224_Aqlhd AU000V 2026-01-28T14:20:11.588Z 2026-01-29T14:34:29.989Z
9267178 9267178 20260126201613_zaQM4 AU000V 2026-01-28T14:20:02.894Z 2026-01-29T14:34:28.812Z
9267162 9267162 20260126200427_b2b9g AU000V 2026-01-28T14:19:50.410Z 2026-01-29T14:34:26.796Z
9267150 9267150 20260126195109_9hzgt AU000V 2026-01-28T14:19:44.843Z 2026-01-29T14:34:25.094Z
9267110 9267110 20260126191853_MkaLb AU000V 2026-01-28T14:19:18.181Z 2026-01-29T14:34:18.541Z
9267067 9267067 20260126183741_rgs3o AU000V 2026-01-28T14:18:51.291Z 2026-01-29T14:34:12.328Z
9266990 9266990 20260126173958_OR2qz AU000V 2026-01-28T14:18:10.883Z 2026-01-29T14:33:52.886Z
9266661 9266661 20260127203003_6k2Bn AU000V 2026-01-28T14:14:13.163Z 2026-01-28T14:14:13.163Z
9266569 9266569 20260127195854_kgb50 AU000V 2026-01-28T14:13:54.937Z 2026-01-28T14:13:54.937Z
9266215 9266215 20260127180759_ix529 AU000V 2026-01-28T14:12:51.887Z 2026-01-29T14:30:24.926Z
9266030 9266030 20260127164334_s0i02 AU000V 2026-01-28T14:12:12.298Z 2026-01-29T14:30:24.824Z
9262195 9262195 20260126180416_TOKCd AU000V 2026-01-27T14:08:08.813Z 2026-01-29T14:33:56.051Z
9259165 9259165 20260124191735_2HNhx AU000V 2026-01-26T14:15:57.471Z 2026-01-29T14:42:40.021Z
9258951 9258951 20260124180804_yDGu8 AU000V 2026-01-26T14:15:09.111Z 2026-01-29T14:42:20.982Z
9258883 9258883 20260124174949_Gwvnb AU000V 2026-01-26T14:14:53.653Z 2026-01-29T14:42:16.628Z
9258811 9258811 20260124171659_bay2k AU000V 2026-01-26T14:14:31.996Z 2026-01-29T14:42:12.319Z
9258796 9258796 20260124171228_3kOg9 AU000V 2026-01-26T14:14:28.680Z 2026-01-29T14:42:11.071Z
9258781 9258781 20260124170007_S8c2m AU000V 2026-01-26T14:14:24.323Z 2026-01-29T14:42:09.520Z
9258643 9258643 20260124153248_WmSuP AU000V 2026-01-26T14:13:34.764Z 2026-01-29T14:41:45.740Z
9254560 9254560 20260123201153_uFAxs AU000V 2026-01-25T14:09:49.413Z 2026-01-29T14:46:30.190Z
9254494 9254494 20260123194750_3sztQ AU000V 2026-01-25T14:09:29.337Z 2026-01-29T14:46:26.626Z
9254453 9254453 20260123192409_kaDF5 AU000V 2026-01-25T14:09:12.976Z 2026-01-29T14:46:24.547Z
9254429 9254429 20260123191511_AkslH AU000V 2026-01-25T14:09:07.628Z 2026-01-29T14:46:23.389Z
9254311 9254311 20260123180905_2iI8S AU000V 2026-01-25T14:08:27.687Z 2026-01-29T14:46:05.901Z
9254270 9254270 20260123174521_uzI3N AU000V 2026-01-25T14:08:13.271Z 2026-01-29T14:46:02.741Z
9254028 9254028 20260123132643_ckfBu AU000V 2026-01-25T14:06:28.247Z 2026-01-29T14:45:25.572Z
9246987 9246987 20260121160901_OcmMG AU000V 2026-01-23T14:08:40.577Z 2026-01-29T14:55:36.346Z
9246903 9246903 20260121153330_eY7sy AU000V 2026-01-23T14:08:27.372Z 2026-01-29T14:55:19.515Z
9246882 9246882 20260121151729_8gkdz AU000V 2026-01-23T14:08:16.751Z 2026-01-29T14:55:18.367Z
9246850 9246850 20260121150335_GPeZn AU000V 2026-01-23T14:08:07.733Z 2026-01-29T14:55:14.691Z
9241071 9241071 20260120190156_RtBog AU000V 2026-01-22T14:11:35.301Z 2026-01-29T15:02:14.687Z
9240925 9240925 20260120182815_BQHA3 AU000V 2026-01-22T14:10:56.686Z 2026-01-29T15:02:03.212Z
9240884 9240884 20260120181510_IUiij AU000V 2026-01-22T14:10:37.025Z 2026-01-29T15:02:00.750Z
9240779 9240779 20260120174546_na6CF AU000V 2026-01-22T14:09:59.369Z 2026-01-29T15:01:54.473Z
9240696 9240696 20260120172650_wqPgc AU000V 2026-01-22T14:09:38.072Z 2026-01-29T15:01:48.729Z
9240300 9240300 20260120150205_4M08U AU000V 2026-01-22T14:07:39.494Z 2026-01-29T15:01:03.482Z
9240208 9240208 20260120134447_uDbDy AU000V 2026-01-22T14:06:58.405Z 2026-01-29T15:00:50.346Z
9234203 9234203 20260119200520_IcCyF AU000V 2026-01-21T14:12:59.789Z 2026-01-28T14:57:21.505Z
9234092 9234092 20260119193648_u38gL AU000V 2026-01-21T14:12:21.851Z 2026-01-28T14:57:05.586Z
9234052 9234052 20260119192516_U6Iub AU000V 2026-01-21T14:12:02.176Z 2026-01-28T14:57:01.149Z
9233981 9233981 20260119190752_XFVVB AU000V 2026-01-21T14:11:40.280Z 2026-01-28T14:56:57.112Z
9233949 9233949 20260119185435_uc37M AU000V 2026-01-21T14:11:30.335Z 2026-01-28T14:56:54.970Z
9233859 9233859 20260119182341_Qk2Np AU000V 2026-01-21T14:10:55.505Z 2026-01-28T14:56:48.317Z
9233683 9233683 20260119165324_A264J AU000V 2026-01-21T14:09:47.438Z 2026-01-28T14:56:21.876Z
9233643 9233643 20260119160854_SpJ0I AU000V 2026-01-21T14:09:28.343Z 2026-01-28T14:56:18.029Z
9233531 9233531 20260119125524_MOd21 AU000V 2026-01-21T14:07:29.817Z 2026-01-28T14:55:24.249Z
9233527 9233527 20260119124239_ZeXuJ AU000V 2026-01-21T14:07:23.256Z 2026-01-28T14:55:21.395Z
9227981 9227981 20260118190337_N3gZo AU000V 2026-01-20T14:15:17.364Z 2026-01-27T15:01:09.350Z
9227967 9227967 20260118185625_ofHme AU000V 2026-01-20T14:15:12.154Z 2026-01-27T15:01:08.415Z
9227935 9227935 20260118184657_J427v AU000V 2026-01-20T14:14:59.514Z 2026-01-27T15:01:04.440Z
9227894 9227894 20260118182935_hCotf AU000V 2026-01-20T14:14:44.280Z 2026-01-27T15:01:01.363Z
9227890 9227890 20260118182845_jLHYr AU000V 2026-01-20T14:14:42.805Z 2026-01-27T15:01:01.126Z
9227735 9227735 20260118171316_zrQn8 AU000V 2026-01-20T14:13:39.366Z 2026-01-27T15:00:41.829Z
9227731 9227731 20260118171207_u2FYf AU000V 2026-01-20T14:13:36.858Z 2026-01-27T15:00:41.554Z
9227700 9227700 20260118164028_m2AJL AU000V 2026-01-20T14:13:16.631Z 2026-01-27T15:00:38.089Z
9227694 9227694 20260118163425_SvU3n AU000V 2026-01-20T14:13:13.180Z 2026-01-27T15:00:37.477Z
9227690 9227690 20260118163423_3T4GL AU000V 2026-01-20T14:13:11.244Z 2026-01-27T15:00:37.334Z
9227672 9227672 20260118161431_WWirp AU000V 2026-01-20T14:13:00.335Z 2026-01-27T15:00:33.318Z
9227647 9227647 20260118152618_YxUfw AU000V 2026-01-20T14:12:26.802Z 2026-01-27T15:00:06.447Z
9227633 9227633 20260118145140_3f34u AU000V 2026-01-20T14:11:54.651Z 2026-01-27T14:59:54.136Z
9227608 9227608 20260118140953_Gk6DA AU000V 2026-01-20T14:11:21.009Z 2026-01-27T14:59:33.044Z
9225933 9225933 20260115173448_J0J1A AU000V 2026-01-19T14:39:18.737Z 2026-01-24T15:09:50.588Z
9225899 9225899 20260115155751_sJi4g AU000V 2026-01-19T14:38:36.596Z 2026-01-24T15:09:16.828Z
9225858 9225858 20260115132027_vI0r4 AU000V 2026-01-19T14:37:54.652Z 2026-01-24T15:08:50.783Z
9222587 9222587 20260117200222_WJngQ AU000V 2026-01-19T14:15:25.043Z 2026-01-26T15:01:14.384Z
9222429 9222429 20260117193147_ok47u AU000V 2026-01-19T14:14:44.212Z 2026-01-26T15:00:53.515Z
9222302 9222302 20260117190102_NM2s4 AU000V 2026-01-19T14:14:12.018Z 2026-01-26T15:00:47.165Z
9222274 9222274 20260117185542_Bhf7R AU000V 2026-01-19T14:14:02.461Z 2026-01-26T15:00:46.180Z
9222143 9222143 20260117182713_2EYi8 AU000V 2026-01-19T14:13:29.131Z 2026-01-26T15:00:41.508Z
9221758 9221758 20260117154123_VNozD AU000V 2026-01-19T14:11:30.313Z 2026-01-26T15:00:03.080Z
9221723 9221723 20260117143540_MiFBm AU000V 2026-01-19T14:10:54.799Z 2026-01-26T14:59:56.649Z
9217892 9217892 20260116202250_qLXSy AU000V 2026-01-18T14:09:29.812Z 2026-01-25T14:57:51.058Z
9216251 9216251 20260115200416_8ZKxC AU000V 2026-01-17T14:28:46.231Z 2026-01-24T15:10:44.237Z
9216248 9216248 20260115200121_QAxS4 AU000V 2026-01-17T14:28:45.809Z 2026-01-24T15:10:36.757Z
9216245 9216245 20260115195603_KjXAo AU000V 2026-01-17T14:28:45.263Z 2026-01-24T15:10:31.980Z
9216234 9216234 20260115191413_XXZ7k AU000V 2026-01-17T14:28:43.324Z 2026-01-24T15:10:24.339Z
9216231 9216231 20260115190200_tnhDQ AU000V 2026-01-17T14:28:42.740Z 2026-01-24T15:10:21.697Z
9216211 9216211 20260115174334_qk52j AU000V 2026-01-17T14:28:36.978Z 2026-01-24T15:09:54.365Z
9216207 9216207 20260115172516_323sX AU000V 2026-01-17T14:28:36.347Z 2026-01-24T15:09:47.881Z
9216201 9216201 20260115170552_fspPY AU000V 2026-01-17T14:28:35.223Z 2026-01-24T15:09:43.737Z
9216197 9216197 20260115170039_X2Fxb AU000V 2026-01-17T14:28:31.455Z 2026-01-24T15:09:42.074Z
9216194 9216194 20260115163923_FSvYE AU000V 2026-01-17T14:28:25.811Z 2026-01-24T15:09:36.911Z
9216191 9216191 20260115163812_Gv9Wp AU000V 2026-01-17T14:28:21.715Z 2026-01-24T15:09:36.489Z
9212288 9212288 20260115201731_xqFIo AU000V 2026-01-17T14:11:03.406Z 2026-01-24T15:10:46.290Z
9212283 9212283 20260115201559_yF9BR AU000V 2026-01-17T14:11:01.683Z 2026-01-24T15:10:45.960Z
9212215 9212215 20260115195935_xTy5h AU000V 2026-01-17T14:10:40.254Z 2026-01-24T15:10:32.426Z
9212052 9212052 20260115185518_UuNzh AU000V 2026-01-17T14:09:42.279Z 2026-01-24T15:10:20.959Z
9212033 9212033 20260115185051_jhrGf AU000V 2026-01-17T14:09:35.262Z 2026-01-24T15:10:20.052Z
9211958 9211958 20260115183307_NtTaO AU000V 2026-01-17T14:09:16.987Z 2026-01-24T15:10:14.489Z
9211955 9211955 20260115183016_g0Q5z AU000V 2026-01-17T14:09:16.447Z 2026-01-24T15:10:13.840Z

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