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

614 rows where station_code = "AU001G" 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
9841590 9841590 20260428125458_6V2rc AU001G 2026-05-04T12:35:58.418Z 2026-05-06T12:39:15.955Z
9841562 9841562 20260428191106_gLzmP AU001G 2026-05-04T12:28:53.704Z 2026-05-06T12:32:34.431Z
9810942 9810942 20260427154305_7Y1Ld AU001G 2026-04-29T12:04:52.537Z 2026-05-06T12:35:54.845Z
9803336 9803336 20260425103816_Tgqs5 AU001G 2026-04-27T12:49:18.110Z 2026-05-02T13:03:52.964Z
9794779 9794779 20260425161846_xl2MO AU001G 2026-04-27T12:10:37.262Z 2026-05-04T12:42:03.672Z
9791407 9791407 20260420180322_dY24j AU001G 2026-04-26T12:53:33.995Z 2026-04-29T13:18:59.142Z
9791397 9791397 20260420165509_MaY8j AU001G 2026-04-26T12:53:28.060Z 2026-04-29T13:18:12.594Z
9791393 9791393 20260420163451_e36hz AU001G 2026-04-26T12:53:27.272Z 2026-04-29T13:18:08.979Z
9791383 9791383 20260420134106_UQkPX AU001G 2026-04-26T12:53:21.992Z 2026-04-29T13:17:53.543Z
9747578 9747578 20260422184841_ez954 AU001G 2026-04-24T12:02:45.770Z 2026-04-30T13:06:56.316Z
9723116 9723116 20260420173354_nq1lH AU001G 2026-04-22T12:09:32.316Z 2026-04-29T13:18:51.039Z
9715707 9715707 20260419161333_bVOPq AU001G 2026-04-21T12:13:08.067Z 2026-04-28T13:35:09.882Z
9714731 9714731 20260419110238_zSvqE AU001G 2026-04-21T12:07:47.110Z 2026-04-28T13:33:43.712Z
9693301 9693301 20260416135515_0vLfG AU001G 2026-04-18T12:11:49.481Z 2026-04-25T13:54:47.365Z
9687973 9687973 20260415180827_0ET6X AU001G 2026-04-17T12:23:25.364Z 2026-04-24T12:24:13.370Z
9687710 9687710 20260415172426_hu3OG AU001G 2026-04-17T12:22:17.918Z 2026-04-24T12:24:09.166Z
9687602 9687602 20260415170155_EO4BV AU001G 2026-04-17T12:21:45.469Z 2026-04-24T12:24:07.087Z
9670393 9670393 20260414183715_29YRn AU001G 2026-04-15T12:15:12.102Z 2026-04-23T13:11:05.965Z
9661280 9661280 20260413154711_zqXb2 AU001G 2026-04-14T12:09:06.038Z 2026-04-22T13:12:57.699Z
9661179 9661179 20260413154101_tutY0 AU001G 2026-04-14T12:08:56.070Z 2026-04-22T13:12:56.350Z
9641027 9641027 20260411183703_J0Uye AU001G 2026-04-12T12:04:28.807Z 2026-04-20T13:06:32.131Z
9617790 9617790 20260407173538_KM22R AU001G 2026-04-08T12:04:51.362Z 2026-04-16T12:58:27.138Z
9617437 9617437 20260407144757_QIOEm AU001G 2026-04-08T12:03:31.344Z 2026-04-16T12:58:04.548Z
9610358 9610358 20260405170214_r5rF5 AU001G 2026-04-06T12:07:19.742Z 2026-04-14T13:02:24.119Z
9607732 9607732 20260404122946_M8gVY AU001G 2026-04-05T12:03:47.908Z 2026-04-13T13:22:11.776Z
9604258 9604258 20260402164809_QjUPj AU001G 2026-04-03T12:06:34.262Z 2026-04-11T12:43:11.316Z
9602025 9602025 20260401181837_Wy808 AU001G 2026-04-02T12:04:34.940Z 2026-04-10T12:35:54.432Z
9600070 9600070 20260331190726_0QDUW AU001G 2026-04-01T12:05:51.637Z 2026-04-09T12:48:06.598Z
9593666 9593666 20260329131819_b0Z6I AU001G 2026-03-30T12:04:43.504Z 2026-04-07T12:27:17.103Z
9591693 9591693 20260328191022_2P5cM AU001G 2026-03-29T12:04:51.543Z 2026-04-06T12:39:39.693Z
9591563 9591563 20260328171126_zAh1y AU001G 2026-03-29T12:04:37.125Z 2026-04-06T12:39:23.105Z
9591437 9591437 20260328163519_5G7Tk AU001G 2026-03-29T12:04:25.013Z 2026-04-06T12:39:15.666Z
9591428 9591428 20260328162834_Ha2kd AU001G 2026-03-29T12:04:24.053Z 2026-04-06T12:39:15.101Z
9591121 9591121 20260328133301_H34By AU001G 2026-03-29T12:03:52.378Z 2026-04-06T12:39:01.801Z
9579020 9579020 20260325174357_OOWbd AU001G 2026-03-26T12:09:09.814Z 2026-04-03T12:38:51.375Z
9578920 9578920 20260325155923_iqS50 AU001G 2026-03-26T12:08:50.649Z 2026-04-03T12:38:41.043Z
9578849 9578849 20260325151333_wqcDR AU001G 2026-03-26T12:08:41.190Z 2026-04-03T12:38:36.017Z
9578814 9578814 20260325150323_RvMTn AU001G 2026-03-26T12:08:36.209Z 2026-04-03T12:38:34.653Z
9575011 9575011 20260323181709_1CF3A AU001G 2026-03-25T12:20:04.337Z 2026-03-31T12:28:46.435Z
9574575 9574575 20260324181259_q7ZcL AU001G 2026-03-25T12:10:59.314Z 2026-03-25T12:10:59.314Z
9574430 9574430 20260324170615_bc1Ld AU001G 2026-03-25T12:10:36.298Z 2026-04-02T12:36:58.313Z
9574395 9574395 20260324165424_0AtVM AU001G 2026-03-25T12:10:29.997Z 2026-04-02T12:36:50.261Z
9574082 9574082 20260324150929_MQncC AU001G 2026-03-25T12:09:36.137Z 2026-04-02T12:36:37.255Z
9569746 9569746 20260322171508_7yox4 AU001G 2026-03-24T12:21:57.879Z 2026-03-30T12:30:18.908Z
9568843 9568843 20260322100150_MlUA6 AU001G 2026-03-24T12:18:28.965Z 2026-03-30T12:28:57.238Z
9568835 9568835 20260322095650_nCSRF AU001G 2026-03-24T12:18:26.479Z 2026-03-30T12:28:56.443Z
9568572 9568572 20260323165648_MpJhK AU001G 2026-03-24T12:15:18.838Z 2026-03-31T12:28:33.224Z
9568447 9568447 20260323164528_pnpV2 AU001G 2026-03-24T12:15:08.124Z 2026-03-31T12:28:29.363Z
9567135 9567135 20260323144412_vSMtw AU001G 2026-03-24T12:13:03.100Z 2026-03-31T12:28:08.868Z
9563666 9563666 20260323090020_wUElD AU001G 2026-03-24T12:06:31.177Z 2026-03-31T12:26:49.132Z
9549686 9549686 20260320152655_2poqS AU001G 2026-03-22T12:24:22.831Z 2026-03-28T12:36:13.073Z
9549495 9549495 20260320150520_ue4jC AU001G 2026-03-22T12:24:03.561Z 2026-03-28T12:36:04.846Z
9549383 9549383 20260320145350_gLsR6 AU001G 2026-03-22T12:23:55.679Z 2026-03-28T12:36:01.938Z
9536067 9536067 20260320090726_Z3VlV AU001G 2026-03-21T12:12:32.744Z 2026-03-28T12:34:56.982Z
9459221 9459221 20260311122406_1VJL2 AU001G 2026-03-12T12:07:56.136Z 2026-03-12T12:07:56.136Z
9454616 9454616 20260310163540_0AfU2 AU001G 2026-03-11T12:09:34.744Z 2026-03-18T12:39:47.723Z
9452952 9452952 20260310115722_G2l5w AU001G 2026-03-11T12:06:32.042Z 2026-03-18T12:39:18.645Z
9452822 9452822 20260310112839_rVe92 AU001G 2026-03-11T12:06:12.276Z 2026-03-18T12:39:15.979Z
9410884 9410884 20260228133642_T299v AU001G 2026-03-01T14:04:15.175Z 2026-03-08T12:42:22.608Z
9405790 9405790 20260227145540_9bGdM AU001G 2026-02-28T14:13:49.625Z 2026-03-07T14:49:45.398Z
9389007 9389007 20260224171034_w7T2M AU001G 2026-02-25T14:24:02.664Z 2026-03-04T14:19:11.746Z
9387336 9387336 20260224131304_7lw0f AU001G 2026-02-25T14:20:32.085Z 2026-03-04T14:18:32.078Z
9387293 9387293 20260224130141_YjPRW AU001G 2026-02-25T14:20:23.022Z 2026-03-04T14:18:31.031Z
9361853 9361853 20260221144216_5FlYh AU001G 2026-02-22T14:11:35.439Z 2026-03-02T14:21:57.050Z
9360376 9360376 20260221111637_1hRTk AU001G 2026-02-22T14:07:41.263Z 2026-03-02T14:21:26.421Z
9349420 9349420 20260218180830_q4CyE AU001G 2026-02-20T14:01:57.689Z 2026-02-27T14:35:49.601Z
9339345 9339345 20260216174801_fffev AU001G 2026-02-18T14:20:10.346Z 2026-02-25T14:42:33.214Z
9339122 9339122 20260216135054_P7BtO AU001G 2026-02-18T14:18:19.334Z 2026-02-25T14:42:13.965Z
9338861 9338861 20260217175213_2L3T0 AU001G 2026-02-18T14:12:54.788Z 2026-02-26T14:40:00.645Z
9338759 9338759 20260217171430_EtY4a AU001G 2026-02-18T14:12:27.071Z 2026-02-26T14:39:51.935Z
9338333 9338333 20260217145742_9S3CG AU001G 2026-02-18T14:10:44.506Z 2026-02-26T14:39:38.632Z
9338291 9338291 20260217143835_5kEEy AU001G 2026-02-18T14:10:30.500Z 2026-02-26T14:39:38.158Z
9338089 9338089 20260217124217_D8N03 AU001G 2026-02-18T14:09:42.743Z 2026-02-26T14:39:34.615Z
9333228 9333228 20260216180821_TXbWU AU001G 2026-02-17T14:15:13.328Z 2026-02-25T14:42:38.503Z
9316016 9316016 20260211161556_8nz3C AU001G 2026-02-12T14:11:55.625Z 2026-02-20T14:05:25.973Z
9315940 9315940 20260211155609_0hDyj AU001G 2026-02-12T14:11:31.025Z 2026-02-20T14:05:25.475Z
9291066 9291066 20260204174738_O3Xu6 AU001G 2026-02-05T14:12:39.397Z 2026-02-13T14:57:01.061Z
9276294 9276294 20260129153757_PK7Be AU001G 2026-01-30T14:11:35.281Z 2026-02-07T14:52:47.893Z
9270825 9270825 20260128175649_DhsVP AU001G 2026-01-29T14:14:07.815Z 2026-02-06T14:46:37.960Z
9245779 9245779 20260122142652_UDMGC AU001G 2026-01-23T14:03:28.565Z 2026-01-31T14:58:44.498Z
9245739 9245739 20260122141006_2SZ6s AU001G 2026-01-23T14:03:13.214Z 2026-01-23T14:03:13.214Z
9245731 9245731 20260122140500_v9gay AU001G 2026-01-23T14:03:11.297Z 2026-01-31T14:58:33.791Z
9245389 9245389 20260122120837_EPVZd AU001G 2026-01-23T14:01:48.856Z 2026-01-31T14:58:00.770Z
9233521 9233521 20260120175518_hfaWP AU001G 2026-01-21T14:06:08.980Z 2026-01-29T15:01:56.341Z
9233219 9233219 20260120133943_3aWpZ AU001G 2026-01-21T14:04:52.879Z 2026-01-29T15:00:50.069Z
9232896 9232896 20260120124654_CtIXi AU001G 2026-01-21T14:03:41.595Z 2026-01-29T15:00:23.498Z
9227251 9227251 20260119151921_BM5H1 AU001G 2026-01-20T14:07:24.336Z 2026-01-28T14:56:01.241Z
9227130 9227130 20260119144254_bWuOq AU001G 2026-01-20T14:06:42.905Z 2026-01-28T14:55:53.072Z
9227072 9227072 20260119142316_ldHmR AU001G 2026-01-20T14:06:27.163Z 2026-01-28T14:55:50.042Z
9174323 9174323 20260110171146_oDTJI AU001G 2026-01-11T14:02:11.127Z 2026-01-19T15:15:09.479Z
9168500 9168500 20260108110850_VZX4a AU001G 2026-01-09T14:11:15.653Z 2026-01-16T15:12:48.197Z
9166028 9166028 20260108161900_u3FT4 AU001G 2026-01-09T14:01:00.788Z 2026-01-17T15:22:54.639Z
9165979 9165979 20260108155302_3LvQI AU001G 2026-01-09T14:00:42.940Z 2026-01-17T15:22:50.111Z
9122951 9122951 20260101153258_PhWwi AU001G 2026-01-02T14:15:56.593Z 2026-01-09T14:54:04.732Z
9107897 9107897 20251229172908_PmFkz AU001G 2025-12-31T14:42:16.942Z 2026-01-06T15:21:04.670Z
9107405 9107405 20251229154635_1BJzt AU001G 2025-12-31T14:40:48.443Z 2026-01-06T15:20:45.174Z
9106033 9106033 20251230151027_ptGqv AU001G 2025-12-31T14:27:27.068Z 2026-01-07T15:11:40.938Z
9105987 9105987 20251230144951_XZAmv AU001G 2025-12-31T14:27:16.559Z 2026-01-01T14:58:01.344Z
9091038 9091038 20251228174244_Jq6KO AU001G 2025-12-30T14:51:38.017Z 2026-01-05T15:13:55.097Z
9090936 9090936 20251228172301_ozQGa AU001G 2025-12-30T14:51:28.239Z 2026-01-05T15:13:45.322Z

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