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

1,050 rows where station_code = "AU004H" 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
9816665 9816665 20260427133454_72sXD AU004H 2026-04-29T12:33:41.328Z 2026-04-29T12:33:41.328Z
9816226 9816226 20260428152433_bl74d AU004H 2026-04-29T12:23:32.435Z 2026-04-29T12:24:08.871Z
9816030 9816030 20260428144750_VBGQR AU004H 2026-04-29T12:22:53.056Z 2026-04-29T12:24:08.779Z
9815712 9815712 20260428140120_JSX2B AU004H 2026-04-29T12:22:12.035Z 2026-04-29T12:24:08.670Z
9815218 9815218 20260428121038_IL4Oe AU004H 2026-04-29T12:20:47.565Z 2026-04-29T12:24:08.467Z
9815056 9815056 20260428113334_DoO1v AU004H 2026-04-29T12:20:24.993Z 2026-04-29T12:24:08.398Z
9810212 9810212 20260428163206_nuXfN AU004H 2026-04-29T12:02:04.345Z 2026-04-29T12:02:04.345Z
9809709 9809709 20260428154244_zvb4Z AU004H 2026-04-29T12:00:15.814Z 2026-04-29T12:00:15.814Z
9809606 9809606 20260426125530_Itznj AU004H 2026-04-28T12:33:21.522Z 2026-04-29T12:42:58.245Z
9809582 9809582 20260426112138_3FyF2 AU004H 2026-04-28T12:32:57.232Z 2026-04-29T12:42:37.576Z
9809471 9809471 20260427120822_mDSaS AU004H 2026-04-28T12:23:10.944Z 2026-04-29T12:32:55.709Z
9805080 9805080 20260426170206_opigz AU004H 2026-04-28T12:04:29.085Z 2026-04-29T12:26:33.447Z
9805066 9805066 20260426165728_BBFlB AU004H 2026-04-28T12:04:23.957Z 2026-04-29T12:26:32.615Z
9805033 9805033 20260426163134_labQW AU004H 2026-04-28T12:03:37.520Z 2026-04-29T12:26:26.026Z
9805010 9805010 20260426161644_bsRoX AU004H 2026-04-28T12:03:09.093Z 2026-04-29T12:26:21.700Z
9804968 9804968 20260426153248_v0Qqj AU004H 2026-04-28T12:02:00.545Z 2026-04-29T12:24:51.415Z
9804938 9804938 20260426144830_5liLA AU004H 2026-04-28T12:00:50.304Z 2026-04-29T12:24:17.940Z
9804933 9804933 20260426143129_E3Smo AU004H 2026-04-28T12:00:34.259Z 2026-04-29T12:24:15.246Z
9803839 9803839 20260425114954_zfRhu AU004H 2026-04-27T12:50:41.573Z 2026-04-29T12:51:36.434Z
9803477 9803477 20260425110020_gGDZp AU004H 2026-04-27T12:49:34.432Z 2026-04-29T12:51:28.314Z
9791339 9791339 20260424125849_HPBvy AU004H 2026-04-26T12:34:58.271Z 2026-04-29T13:00:09.871Z
9790705 9790705 20260424121233_fo05p AU004H 2026-04-26T12:34:47.415Z 2026-04-29T12:59:55.387Z
9782616 9782616 20260424192640_zu28R AU004H 2026-04-26T12:12:19.909Z 2026-04-29T12:46:37.174Z
9782579 9782579 20260424191848_R2p9h AU004H 2026-04-26T12:12:15.327Z 2026-04-29T12:46:33.937Z
9781216 9781216 20260424171452_gk7ba AU004H 2026-04-26T12:09:10.987Z 2026-04-29T12:45:41.378Z
9779592 9779592 20260424154252_B4UmT AU004H 2026-04-26T12:05:58.633Z 2026-04-29T12:44:43.416Z
9778903 9778903 20260424150504_W37Ew AU004H 2026-04-26T12:04:31.310Z 2026-04-29T12:44:18.791Z
9777628 9777628 20260424135026_s24on AU004H 2026-04-26T12:01:41.175Z 2026-04-29T12:43:37.466Z
9777138 9777138 20260424132407_w9idk AU004H 2026-04-26T12:00:50.362Z 2026-04-29T12:43:18.756Z
9775413 9775413 20260423101837_39zX3 AU004H 2026-04-25T12:56:31.165Z 2026-04-29T13:09:52.897Z
9760844 9760844 20260423144445_9UzsZ AU004H 2026-04-25T12:04:56.919Z 2026-04-29T12:52:54.199Z
9744553 9744553 20260422152201_K3RCN AU004H 2026-04-24T12:01:36.192Z 2026-04-29T13:01:33.358Z
9743229 9743229 20260422135354_gGvya AU004H 2026-04-24T12:00:56.479Z 2026-04-29T13:00:50.685Z
9742469 9742469 20260422125509_hqRYB AU004H 2026-04-24T12:00:31.999Z 2026-04-29T13:00:38.288Z
9741791 9741791 20260421091126_IA7Pi AU004H 2026-04-23T12:37:57.379Z 2026-04-29T13:22:36.032Z
9731220 9731220 20260421161925_Lnzkc AU004H 2026-04-23T12:04:39.377Z 2026-04-29T13:11:16.397Z
9716655 9716655 20260419192946_6kKej AU004H 2026-04-21T12:16:52.159Z 2026-04-28T13:36:11.548Z
9716596 9716596 20260419191010_eaEny AU004H 2026-04-21T12:16:32.147Z 2026-04-28T13:36:10.099Z
9716292 9716292 20260419180523_yzBDE AU004H 2026-04-21T12:15:25.642Z 2026-04-28T13:36:01.498Z
9716003 9716003 20260419171703_s5Gs3 AU004H 2026-04-21T12:14:18.507Z 2026-04-28T13:35:55.272Z
9715917 9715917 20260419170251_HfWt3 AU004H 2026-04-21T12:14:04.325Z 2026-04-28T13:35:53.173Z
9715479 9715479 20260419152336_UzvhI AU004H 2026-04-21T12:12:04.765Z 2026-04-28T13:34:56.722Z
9715214 9715214 20260419140444_LyWAy AU004H 2026-04-21T12:10:42.306Z 2026-04-28T13:34:45.269Z
9715095 9715095 20260419133145_e71R8 AU004H 2026-04-21T12:09:55.700Z 2026-04-28T13:34:41.881Z
9714784 9714784 20260419112716_P6tu3 AU004H 2026-04-21T12:08:05.205Z 2026-04-28T13:33:46.941Z
9714692 9714692 20260419102735_dHZsT AU004H 2026-04-21T12:07:18.693Z 2026-04-28T13:33:36.383Z
9713504 9713504 20260420114603_0bvg4 AU004H 2026-04-21T12:01:32.141Z 2026-04-29T13:17:47.374Z
9713319 9713319 20260420110933_vYuQM AU004H 2026-04-21T12:00:52.996Z 2026-04-29T13:17:44.843Z
9713123 9713123 20260418091212_Mkx0V AU004H 2026-04-20T12:38:39.533Z 2026-04-26T13:14:14.081Z
9713107 9713107 20260418084031_AUcVt AU004H 2026-04-20T12:38:30.960Z 2026-04-26T13:13:36.985Z
9706671 9706671 20260418184430_pM4wS AU004H 2026-04-20T12:11:02.183Z 2026-04-27T13:45:30.697Z
9706657 9706657 20260418184153_3N28o AU004H 2026-04-20T12:10:58.847Z 2026-04-27T13:45:29.864Z
9706637 9706637 20260418183443_ReUtc AU004H 2026-04-20T12:10:52.300Z 2026-04-27T13:45:29.268Z
9706608 9706608 20260418182411_8OSnq AU004H 2026-04-20T12:10:46.142Z 2026-04-27T13:45:28.082Z
9706562 9706562 20260418181129_rchae AU004H 2026-04-20T12:10:25.975Z 2026-04-27T13:45:26.515Z
9706526 9706526 20260418175317_xF4rL AU004H 2026-04-20T12:10:17.875Z 2026-04-27T13:45:24.866Z
9706486 9706486 20260418174038_Xg9g7 AU004H 2026-04-20T12:10:09.516Z 2026-04-27T13:45:23.336Z
9706387 9706387 20260418170709_5RuoO AU004H 2026-04-20T12:09:38.930Z 2026-04-27T13:45:00.024Z
9706375 9706375 20260418170510_goz00 AU004H 2026-04-20T12:09:36.219Z 2026-04-27T13:44:59.679Z
9706103 9706103 20260418151622_jFLL4 AU004H 2026-04-20T12:08:20.766Z 2026-04-27T13:44:45.727Z
9706059 9706059 20260418145712_S4qKd AU004H 2026-04-20T12:08:00.470Z 2026-04-27T13:44:44.229Z
9705945 9705945 20260418134249_WIMwL AU004H 2026-04-20T12:07:26.239Z 2026-04-27T13:44:24.197Z
9705921 9705921 20260418133403_V9THW AU004H 2026-04-20T12:07:21.543Z 2026-04-27T13:44:23.401Z
9705884 9705884 20260418131242_XCTl1 AU004H 2026-04-20T12:07:06.037Z 2026-04-27T13:44:21.448Z
9705865 9705865 20260418130128_g4LtS AU004H 2026-04-20T12:07:00.333Z 2026-04-27T13:44:17.863Z
9705859 9705859 20260418125741_cPGxY AU004H 2026-04-20T12:06:58.968Z 2026-04-27T13:44:17.663Z
9705843 9705843 20260418125034_cmsc1 AU004H 2026-04-20T12:06:50.368Z 2026-04-27T13:44:17.045Z
9705710 9705710 20260418104712_JJYoC AU004H 2026-04-20T12:05:45.146Z 2026-04-27T13:43:44.588Z
9705664 9705664 20260418100726_yKArA AU004H 2026-04-20T12:05:17.664Z 2026-04-27T13:43:36.053Z
9705646 9705646 20260418094513_YCfyy AU004H 2026-04-20T12:05:02.389Z 2026-04-27T13:43:31.200Z
9699402 9699402 20260417181747_rELlN AU004H 2026-04-19T12:11:41.286Z 2026-04-26T13:10:06.767Z
9699266 9699266 20260417174321_IjwA2 AU004H 2026-04-19T12:11:10.564Z 2026-04-26T13:09:55.606Z
9699055 9699055 20260417164037_fvUt4 AU004H 2026-04-19T12:10:09.298Z 2026-04-26T13:09:32.766Z
9699003 9699003 20260417162133_BYUcG AU004H 2026-04-19T12:09:53.261Z 2026-04-26T13:09:27.297Z
9698974 9698974 20260417161650_OvTKi AU004H 2026-04-19T12:09:45.287Z 2026-04-26T13:09:23.540Z
9698576 9698576 20260417141334_3MRbd AU004H 2026-04-19T12:07:50.488Z 2026-04-26T13:08:50.780Z
9698494 9698494 20260417134244_8iBGJ AU004H 2026-04-19T12:07:20.903Z 2026-04-26T13:08:42.056Z
9698467 9698467 20260417133418_g1uxg AU004H 2026-04-19T12:07:15.129Z 2026-04-26T13:08:40.278Z
9698404 9698404 20260417131710_xk3nf AU004H 2026-04-19T12:06:57.123Z 2026-04-26T13:08:31.733Z
9698256 9698256 20260417121857_MWqXb AU004H 2026-04-19T12:06:05.381Z 2026-04-26T13:08:07.128Z
9694525 9694525 20260416190547_oRS4r AU004H 2026-04-18T12:19:45.671Z 2026-04-25T13:57:39.105Z
9694510 9694510 20260416185140_28fNP AU004H 2026-04-18T12:19:42.798Z 2026-04-25T13:57:38.213Z
9693959 9693959 20260416171551_unAxB AU004H 2026-04-18T12:18:13.343Z 2026-04-25T13:57:00.006Z
9693928 9693928 20260416171226_V0bbW AU004H 2026-04-18T12:18:07.377Z 2026-04-25T13:56:58.919Z
9693729 9693729 20260416165221_BQYUC AU004H 2026-04-18T12:17:29.038Z 2026-04-25T13:56:46.408Z
9693537 9693537 20260416153123_iqpOe AU004H 2026-04-18T12:15:06.632Z 2026-04-25T13:55:53.805Z
9693523 9693523 20260416152325_dbjJB AU004H 2026-04-18T12:14:53.835Z 2026-04-25T13:55:51.708Z
9693500 9693500 20260416151651_WRzKG AU004H 2026-04-18T12:14:40.565Z 2026-04-25T13:55:49.429Z
9693457 9693457 20260416145856_OUnHV AU004H 2026-04-18T12:13:59.677Z 2026-04-25T13:55:28.330Z
9693376 9693376 20260416142901_YNTU8 AU004H 2026-04-18T12:13:00.547Z 2026-04-25T13:55:14.712Z
9693247 9693247 20260416133441_29WDl AU004H 2026-04-18T12:10:50.611Z 2026-04-25T13:54:37.194Z
9693059 9693059 20260416115552_xJAkv AU004H 2026-04-18T12:08:57.361Z 2026-04-25T13:53:34.974Z
9692995 9692995 20260416111759_CqaQd AU004H 2026-04-18T12:08:17.037Z 2026-04-25T13:53:06.326Z
9688249 9688249 20260415190801_60poP AU004H 2026-04-17T12:24:19.176Z 2026-04-24T12:24:35.148Z
9688140 9688140 20260415184719_i03X1 AU004H 2026-04-17T12:23:59.823Z 2026-04-24T12:24:25.345Z
9688047 9688047 20260415182720_yUqq9 AU004H 2026-04-17T12:23:36.753Z 2026-04-24T12:24:14.384Z
9687733 9687733 20260415172727_wZZZ6 AU004H 2026-04-17T12:22:21.669Z 2026-04-24T12:24:10.034Z
9687606 9687606 20260415170249_tItTg AU004H 2026-04-17T12:21:46.203Z 2026-04-24T12:24:07.186Z
9687349 9687349 20260415155333_j2nQn AU004H 2026-04-17T12:20:33.567Z 2026-04-24T12:24:01.502Z
9687260 9687260 20260415152312_FXuzQ AU004H 2026-04-17T12:20:07.782Z 2026-04-24T12:23:59.540Z

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