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 = "AU003H" 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
9270642 9270642 20260128161741_sG3UC AU003H 2026-01-29T14:13:10.771Z 2026-01-29T14:13:10.771Z
9266634 9266634 20260127201130_gUHiR AU003H 2026-01-28T14:14:08.228Z 2026-01-29T14:30:25.145Z
9262430 9262430 20260126202454_feOpr AU003H 2026-01-27T14:09:00.396Z 2026-01-29T14:34:31.552Z
9258803 9258803 20260124171402_5oV3q AU003H 2026-01-26T14:14:29.705Z 2026-01-29T14:42:11.577Z
9258751 9258751 20260124163830_MpzOG AU003H 2026-01-26T14:14:12.416Z 2026-01-29T14:42:00.609Z
9254350 9254350 20260123183429_L5F5Q AU003H 2026-01-25T14:08:38.985Z 2026-01-29T14:46:11.048Z
9254347 9254347 20260123183429_P3dHN AU003H 2026-01-25T14:08:38.350Z 2026-01-29T14:46:10.940Z
9254013 9254013 20260123125131_pbpb6 AU003H 2026-01-25T14:06:18.755Z 2026-01-29T14:45:15.777Z
9247739 9247739 20260121194109_dI5bz AU003H 2026-01-23T14:11:00.926Z 2026-01-29T14:56:34.958Z
9247296 9247296 20260121175443_6Keql AU003H 2026-01-23T14:09:37.270Z 2026-01-29T14:56:02.641Z
9247244 9247244 20260121174239_TncFT AU003H 2026-01-23T14:09:30.056Z 2026-01-29T14:55:51.609Z
9247242 9247242 20260121174239_1CR2A AU003H 2026-01-23T14:09:29.754Z 2026-01-29T14:55:51.503Z
9247055 9247055 20260121163140_GLB60 AU003H 2026-01-23T14:08:55.488Z 2026-01-29T14:55:40.282Z
9246941 9246941 20260121154311_KNaPA AU003H 2026-01-23T14:08:32.746Z 2026-01-29T14:55:21.400Z
9241129 9241129 20260120191043_xcnT5 AU003H 2026-01-22T14:11:43.398Z 2026-01-29T15:02:23.388Z
9240921 9240921 20260120182737_qLRaq AU003H 2026-01-22T14:10:55.507Z 2026-01-29T15:02:02.842Z
9233571 9233571 20260119143038_du0RW AU003H 2026-01-21T14:08:24.562Z 2026-01-28T14:55:50.893Z
9232053 9232053 20260117195237_rbLD7 AU003H 2026-01-20T14:39:44.831Z 2026-01-26T15:01:13.080Z
9227442 9227442 20260119174203_9jYR3 AU003H 2026-01-20T14:08:20.704Z 2026-01-28T14:56:30.938Z
9225845 9225845 20260116145559_63lWF AU003H 2026-01-19T14:33:30.952Z 2026-01-25T14:57:15.515Z
9216257 9216257 20260115202454_f363i AU003H 2026-01-17T14:28:46.701Z 2026-01-24T15:10:46.804Z
9216244 9216244 20260115192830_2nO03 AU003H 2026-01-17T14:28:44.850Z 2026-01-24T15:10:28.419Z
9216240 9216240 20260115192401_B819u AU003H 2026-01-17T14:28:43.837Z 2026-01-24T15:10:26.011Z
9216230 9216230 20260115185622_OAV3e AU003H 2026-01-17T14:28:42.337Z 2026-01-24T15:10:21.435Z
9216216 9216216 20260115174407_7LzKq AU003H 2026-01-17T14:28:37.722Z 2026-01-24T15:09:54.427Z
9216206 9216206 20260115170711_Y9JZ0 AU003H 2026-01-17T14:28:35.737Z 2026-01-24T15:09:43.993Z
9216188 9216188 20260115161400_vgp8W AU003H 2026-01-17T14:28:16.289Z 2026-01-24T15:09:29.359Z
9216182 9216182 20260115160755_m3DNm AU003H 2026-01-17T14:28:14.952Z 2026-01-24T15:09:18.105Z
9216180 9216180 20260115153320_U1i1P AU003H 2026-01-17T14:28:14.452Z 2026-01-24T15:09:13.940Z
9216169 9216169 20260115143722_w55KW AU003H 2026-01-17T14:28:12.296Z 2026-01-24T15:09:06.458Z
9216159 9216159 20260115142102_VJltC AU003H 2026-01-17T14:28:07.604Z 2026-01-24T15:08:58.022Z
9216154 9216154 20260115125242_VaLEg AU003H 2026-01-17T14:28:05.900Z 2026-01-24T15:08:41.032Z
9211775 9211775 20260115174312_KYFP2 AU003H 2026-01-17T14:08:25.630Z 2026-01-24T15:09:54.300Z
9211370 9211370 20260115150139_uGjoJ AU003H 2026-01-17T14:06:18.694Z 2026-01-24T15:09:10.583Z
9211277 9211277 20260115142550_CVzXG AU003H 2026-01-17T14:05:56.988Z 2026-01-17T14:05:56.988Z
9207019 9207019 20260114202728_tLCmq AU003H 2026-01-16T14:06:42.122Z 2026-01-22T15:02:53.430Z
9207014 9207014 20260114202635_YiQ3D AU003H 2026-01-16T14:06:38.852Z 2026-01-22T15:02:51.707Z
9207001 9207001 20260114202007_Yvf0a AU003H 2026-01-16T14:06:34.263Z 2026-01-22T15:02:47.448Z
9206960 9206960 20260114200127_MkOzK AU003H 2026-01-16T14:06:21.084Z 2026-01-22T15:02:44.604Z
9206929 9206929 20260114195241_2g3yM AU003H 2026-01-16T14:06:12.202Z 2026-01-22T15:02:43.476Z
9206834 9206834 20260114191305_Ail22 AU003H 2026-01-16T14:05:46.974Z 2026-01-22T15:02:37.993Z
9206759 9206759 20260114184420_hPDgo AU003H 2026-01-16T14:05:26.123Z 2026-01-22T15:02:35.726Z
9206650 9206650 20260114180621_MfOLV AU003H 2026-01-16T14:04:56.202Z 2026-01-22T15:02:32.708Z
9206565 9206565 20260114174411_t0Tg2 AU003H 2026-01-16T14:04:29.260Z 2026-01-22T15:02:30.058Z
9206563 9206563 20260114174411_zJA3j AU003H 2026-01-16T14:04:28.526Z 2026-01-22T15:02:29.944Z
9206526 9206526 20260114172911_3xe2M AU003H 2026-01-16T14:04:19.429Z 2026-01-22T15:02:29.000Z
9206504 9206504 20260114171930_6B3pN AU003H 2026-01-16T14:04:13.567Z 2026-01-22T15:02:28.138Z
9206421 9206421 20260114164415_yr0ra AU003H 2026-01-16T14:03:49.112Z 2026-01-22T15:02:24.727Z
9206413 9206413 20260114164046_zLHhM AU003H 2026-01-16T14:03:46.470Z 2026-01-22T15:02:24.312Z
9206333 9206333 20260114160048_OZ346 AU003H 2026-01-16T14:03:22.834Z 2026-01-22T15:02:07.342Z
9206271 9206271 20260114150901_FL6ia AU003H 2026-01-16T14:03:02.393Z 2026-01-22T15:01:57.398Z
9206253 9206253 20260114145933_MtbLs AU003H 2026-01-16T14:02:57.498Z 2026-01-22T15:01:56.898Z
9206164 9206164 20260114135427_RelCR AU003H 2026-01-16T14:02:27.562Z 2026-01-22T15:01:51.377Z
9206146 9206146 20260114134207_Az0Ul AU003H 2026-01-16T14:02:23.199Z 2026-01-22T15:01:50.826Z
9206106 9206106 20260114131419_vdwLI AU003H 2026-01-16T14:02:05.826Z 2026-01-22T15:01:48.694Z
9206095 9206095 20260115200034_CbVt9 AU003H 2026-01-16T14:01:52.083Z 2026-01-24T15:10:33.820Z
9206093 9206093 20260115194504_hZnH6 AU003H 2026-01-16T14:01:50.991Z 2026-01-24T15:10:30.509Z
9206074 9206074 20260115161157_usSjA AU003H 2026-01-16T14:01:43.660Z 2026-01-24T15:09:26.692Z
9205763 9205763 20260113130349_DsO7z AU003H 2026-01-15T14:41:22.172Z 2026-01-21T15:06:26.757Z
9199082 9199082 20260113190101_7ZQS3 AU003H 2026-01-15T14:09:09.537Z 2026-01-22T15:07:13.528Z
9199008 9199008 20260113184923_6DYJu AU003H 2026-01-15T14:08:52.233Z 2026-01-22T15:07:11.442Z
9198842 9198842 20260113181453_VPR8t AU003H 2026-01-15T14:07:39.732Z 2026-01-22T15:07:06.333Z
9198796 9198796 20260113180345_4a5NM AU003H 2026-01-15T14:07:17.714Z 2026-01-22T15:07:04.644Z
9198790 9198790 20260113175948_5yLm2 AU003H 2026-01-15T14:07:14.824Z 2026-01-22T15:07:04.310Z
9198664 9198664 20260113173055_vGHFz AU003H 2026-01-15T14:06:18.529Z 2026-01-22T15:07:00.052Z
9198563 9198563 20260113170743_TW4do AU003H 2026-01-15T14:05:29.116Z 2026-01-22T15:06:34.307Z
9198546 9198546 20260113170139_Sfb3E AU003H 2026-01-15T14:05:22.194Z 2026-01-22T15:06:33.652Z
9198501 9198501 20260113164738_DWUyz AU003H 2026-01-15T14:04:57.129Z 2026-01-22T15:06:31.910Z
9198304 9198304 20260113152525_Xzn4D AU003H 2026-01-15T14:03:08.772Z 2026-01-22T15:06:21.793Z
9198299 9198299 20260113152319_IKGEa AU003H 2026-01-15T14:03:04.733Z 2026-01-22T15:06:21.526Z
9198244 9198244 20260113150521_0wpyN AU003H 2026-01-15T14:02:34.366Z 2026-01-22T15:06:19.609Z
9198178 9198178 20260113142136_KsrPi AU003H 2026-01-15T14:01:46.202Z 2026-01-22T15:06:15.973Z
9198146 9198146 20260113135509_oFbem AU003H 2026-01-15T14:01:26.085Z 2026-01-22T15:06:14.872Z
9197956 9197956 20260113131709_gUYUd AU003H 2026-01-14T14:25:04.364Z 2026-01-14T14:25:08.835Z
9194300 9194300 20260112194131_2nUZE AU003H 2026-01-14T14:08:34.214Z 2026-01-21T15:03:47.658Z
9194239 9194239 20260112190835_5Gbz5 AU003H 2026-01-14T14:08:14.818Z 2026-01-21T15:03:43.717Z
9194237 9194237 20260112190835_lpCHJ AU003H 2026-01-14T14:08:14.235Z 2026-01-21T15:03:43.709Z
9194226 9194226 20260112190416_Pz0L9 AU003H 2026-01-14T14:08:08.116Z 2026-01-21T15:03:42.917Z
9194184 9194184 20260112184134_jfqxJ AU003H 2026-01-14T14:07:52.761Z 2026-01-21T15:03:38.630Z
9194182 9194182 20260112184134_BKWag AU003H 2026-01-14T14:07:51.824Z 2026-01-21T15:03:38.169Z
9194180 9194180 20260112184125_UxUr1 AU003H 2026-01-14T14:07:47.415Z 2026-01-21T15:03:38.113Z
9194063 9194063 20260112171810_xWtBD AU003H 2026-01-14T14:06:55.944Z 2026-01-21T15:03:24.132Z
9194054 9194054 20260112171028_8y2UX AU003H 2026-01-14T14:06:53.528Z 2026-01-21T15:03:23.896Z
9193998 9193998 20260112161806_CmYqB AU003H 2026-01-14T14:06:30.217Z 2026-01-21T15:03:11.780Z
9193991 9193991 20260112161411_QGmqi AU003H 2026-01-14T14:06:28.810Z 2026-01-21T15:03:11.002Z
9193989 9193989 20260112161411_jQbAX AU003H 2026-01-14T14:06:28.231Z 2026-01-21T15:03:10.907Z
9193977 9193977 20260112160401_n2ojV AU003H 2026-01-14T14:06:20.913Z 2026-01-21T15:03:08.121Z
9193973 9193973 20260112160250_AP4mJ AU003H 2026-01-14T14:06:19.388Z 2026-01-21T15:03:07.977Z
9193970 9193970 20260112155845_zvnbt AU003H 2026-01-14T14:06:18.304Z 2026-01-21T15:03:07.940Z
9193928 9193928 20260112151243_u1jrJ AU003H 2026-01-14T14:05:05.182Z 2026-01-21T15:02:48.619Z
9193706 9193706 20260113173619_2c0fr AU003H 2026-01-14T14:02:58.571Z 2026-01-14T14:02:58.571Z
9193387 9193387 20260113141529_lk45c AU003H 2026-01-14T14:01:04.717Z 2026-01-22T15:06:15.893Z
9187820 9187820 20260111185654_WRj3m AU003H 2026-01-13T14:09:02.757Z 2026-01-20T15:20:56.163Z
9180398 9180398 20260110201858_Sfakb AU003H 2026-01-12T14:07:00.020Z 2026-01-19T15:16:00.718Z
9180369 9180369 20260110201117_lbfRD AU003H 2026-01-12T14:06:53.923Z 2026-01-19T15:15:59.598Z
9180320 9180320 20260110195748_1SGcc AU003H 2026-01-12T14:06:41.015Z 2026-01-19T15:15:57.580Z
9180271 9180271 20260110194949_lD80z AU003H 2026-01-12T14:06:30.768Z 2026-01-19T15:15:54.327Z
9180252 9180252 20260110194410_Foiy3 AU003H 2026-01-12T14:06:27.012Z 2026-01-19T15:15:53.547Z
9179984 9179984 20260110183233_5CXUm AU003H 2026-01-12T14:05:14.158Z 2026-01-19T15:15:39.641Z
9179982 9179982 20260110183232_CrmjN AU003H 2026-01-12T14:05:13.533Z 2026-01-19T15:15:39.529Z

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