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

2,068 rows where station_code = "AU0043" 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
9717127 9717127 20260419210408_Zia8i AU0043 2026-04-21T12:18:49.005Z 2026-04-28T13:37:04.402Z
9717017 9717017 20260419204832_udVwX AU0043 2026-04-21T12:18:24.126Z 2026-04-28T13:37:02.489Z
9716302 9716302 20260419180823_ONArn AU0043 2026-04-21T12:15:27.403Z 2026-04-28T13:36:01.662Z
9714953 9714953 20260419125729_HoW0r AU0043 2026-04-21T12:09:14.819Z 2026-04-28T13:34:37.770Z
9714950 9714950 20260419125641_VVUE7 AU0043 2026-04-21T12:09:14.053Z 2026-04-28T13:34:37.706Z
9706709 9706709 20260418185419_3PwPQ AU0043 2026-04-20T12:11:13.588Z 2026-04-27T13:45:31.964Z
9693837 9693837 20260416170853_w8CZl AU0043 2026-04-18T12:17:57.638Z 2026-04-25T13:56:56.101Z
9693744 9693744 20260416165735_KxdQQ AU0043 2026-04-18T12:17:38.710Z 2026-04-25T13:56:53.049Z
9688938 9688938 20260415214011_TrLvH AU0043 2026-04-17T12:26:52.612Z 2026-04-24T12:24:42.367Z
9688848 9688848 20260415212335_oj2DI AU0043 2026-04-17T12:26:27.465Z 2026-04-24T12:24:41.520Z
9688095 9688095 20260415183940_Vj2ko AU0043 2026-04-17T12:23:43.533Z 2026-04-24T12:24:14.803Z
9687115 9687115 20260415143335_SdDpF AU0043 2026-04-17T12:19:12.010Z 2026-04-24T12:23:55.136Z
9686760 9686760 20260415121307_XJeg0 AU0043 2026-04-17T12:16:51.498Z 2026-04-24T12:23:25.639Z
9679027 9679027 20260414180015_ZHbE5 AU0043 2026-04-16T12:18:03.887Z 2026-04-23T13:10:50.317Z
9678951 9678951 20260414164536_Ixjav AU0043 2026-04-16T12:16:26.548Z 2026-04-23T13:10:26.702Z
9678942 9678942 20260414162816_MwCKP AU0043 2026-04-16T12:16:10.139Z 2026-04-23T13:10:23.823Z
9678876 9678876 20260414153713_IJaiq AU0043 2026-04-16T12:14:48.469Z 2026-04-23T13:09:53.919Z
9671545 9671545 20260413194452_WcNDL AU0043 2026-04-15T12:25:09.095Z 2026-04-22T13:14:16.538Z
9671528 9671528 20260413193339_bU3TS AU0043 2026-04-15T12:25:01.996Z 2026-04-22T13:14:15.985Z
9671432 9671432 20260413185059_4e9be AU0043 2026-04-15T12:24:45.651Z 2026-04-22T13:14:11.755Z
9671257 9671257 20260413173417_1ELB3 AU0043 2026-04-15T12:23:27.826Z 2026-04-22T13:14:05.797Z
9670933 9670933 20260413154755_p0vIx AU0043 2026-04-15T12:19:59.389Z 2026-04-22T13:12:57.883Z
9663682 9663682 20260412213242_jcZnE AU0043 2026-04-14T12:25:12.475Z 2026-04-21T13:17:10.596Z
9663371 9663371 20260412200007_k6hiu AU0043 2026-04-14T12:23:59.523Z 2026-04-21T13:17:02.751Z
9663313 9663313 20260412193039_RbLKi AU0043 2026-04-14T12:23:47.558Z 2026-04-21T13:17:01.256Z
9663270 9663270 20260412185940_Tgj0q AU0043 2026-04-14T12:23:21.006Z 2026-04-21T13:16:59.881Z
9663225 9663225 20260412183600_bQwWI AU0043 2026-04-14T12:23:10.031Z 2026-04-21T13:16:58.537Z
9662731 9662731 20260412141105_LI10x AU0043 2026-04-14T12:16:58.984Z 2026-04-21T13:15:21.507Z
9662691 9662691 20260412135252_ohq1Z AU0043 2026-04-14T12:16:26.942Z 2026-04-21T13:15:18.828Z
9662624 9662624 20260412123708_Heo89 AU0043 2026-04-14T12:15:32.533Z 2026-04-21T13:15:13.372Z
9656636 9656636 20260411214739_LbmL2 AU0043 2026-04-13T12:23:33.053Z 2026-04-20T13:06:46.172Z
9656150 9656150 20260411201034_KWHQ7 AU0043 2026-04-13T12:21:41.833Z 2026-04-20T13:06:38.834Z
9656148 9656148 20260411201015_d2vVz AU0043 2026-04-13T12:21:41.312Z 2026-04-20T13:06:38.777Z
9655951 9655951 20260411192916_lHfsv AU0043 2026-04-13T12:20:47.412Z 2026-04-20T13:06:35.562Z
9655287 9655287 20260411153025_yu4WD AU0043 2026-04-13T12:17:23.959Z 2026-04-20T13:05:54.194Z
9655030 9655030 20260411125509_cle4K AU0043 2026-04-13T12:15:57.398Z 2026-04-20T13:05:27.589Z
9655005 9655005 20260411124241_H3G9a AU0043 2026-04-13T12:15:51.021Z 2026-04-20T13:05:22.573Z
9644149 9644149 20260410203320_OkPoX AU0043 2026-04-12T12:16:56.319Z 2026-04-19T13:20:47.367Z
9643041 9643041 20260410152821_njw7D AU0043 2026-04-12T12:12:25.579Z 2026-04-19T13:19:11.172Z
9642840 9642840 20260410144429_hth25 AU0043 2026-04-12T12:11:42.321Z 2026-04-19T13:18:58.882Z
9642495 9642495 20260410131612_O4xDL AU0043 2026-04-12T12:10:18.201Z 2026-04-19T13:18:32.722Z
9642485 9642485 20260410131410_l6TZv AU0043 2026-04-12T12:10:16.105Z 2026-04-19T13:18:32.164Z
9634024 9634024 20260408160747_S8Umf AU0043 2026-04-10T12:03:33.883Z 2026-04-17T13:09:31.315Z
9633996 9633996 20260408143037_yFInB AU0043 2026-04-10T12:03:10.279Z 2026-04-17T13:08:54.798Z
9627940 9627940 20260407190517_qNVK6 AU0043 2026-04-09T12:14:27.042Z 2026-04-16T12:58:49.546Z
9627774 9627774 20260407165137_7XZ0e AU0043 2026-04-09T12:13:33.430Z 2026-04-16T12:58:15.853Z
9627648 9627648 20260407144052_Uogor AU0043 2026-04-09T12:12:44.397Z 2026-04-16T12:58:04.279Z
9613274 9613274 20260405174209_Hgmnv AU0043 2026-04-07T12:06:08.279Z 2026-04-14T13:02:24.445Z
9613261 9613261 20260405165736_oPyP0 AU0043 2026-04-07T12:06:03.582Z 2026-04-14T13:02:24.097Z
9612654 9612654 20260406151000_8GcJP AU0043 2026-04-07T12:02:29.821Z 2026-04-15T13:06:23.206Z
9612525 9612525 20260406134032_CRVoB AU0043 2026-04-07T12:02:05.324Z 2026-04-15T13:06:22.366Z
9606727 9606727 20260402194307_8fKJQ AU0043 2026-04-04T12:11:15.789Z 2026-04-11T12:43:22.015Z
9606694 9606694 20260402180047_Oqe9a AU0043 2026-04-04T12:10:57.909Z 2026-04-11T12:43:16.991Z
9606673 9606673 20260402162914_87d8s AU0043 2026-04-04T12:10:25.015Z 2026-04-11T12:43:04.261Z
9606670 9606670 20260402162556_xZ5gF AU0043 2026-04-04T12:10:23.781Z 2026-04-11T12:42:57.660Z
9605804 9605804 20260403120823_zaYBL AU0043 2026-04-04T12:03:59.301Z 2026-04-12T13:01:23.411Z
9604519 9604519 20260401154759_Ignsr AU0043 2026-04-03T12:09:06.607Z 2026-04-10T12:35:41.100Z
9602080 9602080 20260401191445_sX0gR AU0043 2026-04-02T12:04:47.198Z 2026-04-10T12:36:03.350Z
9599224 9599224 20260331130428_qLNe4 AU0043 2026-04-01T12:02:47.553Z 2026-04-09T12:46:44.280Z
9594108 9594108 20260329201813_kHPQ1 AU0043 2026-03-30T12:06:10.317Z 2026-04-07T12:27:46.338Z
9584505 9584505 20260325201820_OaTHX AU0043 2026-03-27T12:15:30.807Z 2026-04-03T12:39:17.403Z
9584497 9584497 20260325200913_UT6dm AU0043 2026-03-27T12:15:28.745Z 2026-04-03T12:39:16.652Z
9584300 9584300 20260325183703_F55eh AU0043 2026-03-27T12:14:54.277Z 2026-04-03T12:39:07.917Z
9584205 9584205 20260325172930_uSgq8 AU0043 2026-03-27T12:14:31.891Z 2026-04-03T12:38:50.135Z
9575127 9575127 20260323185024_YYbPz AU0043 2026-03-25T12:20:21.303Z 2026-03-31T12:28:49.119Z
9574719 9574719 20260323153838_EcXJn AU0043 2026-03-25T12:17:35.180Z 2026-03-31T12:28:17.183Z
9574711 9574711 20260323151127_xG3wZ AU0043 2026-03-25T12:17:01.131Z 2026-03-31T12:28:13.245Z
9574705 9574705 20260323144937_VimzN AU0043 2026-03-25T12:16:37.852Z 2026-03-31T12:28:09.846Z
9569728 9569728 20260322171005_wbl5t AU0043 2026-03-24T12:21:55.755Z 2026-03-30T12:30:18.339Z
9501083 9501083 20260315205215_Cdcwf AU0043 2026-03-17T12:24:23.273Z 2026-03-23T12:22:42.974Z
9500836 9500836 20260315194342_xDatP AU0043 2026-03-17T12:23:58.154Z 2026-03-23T12:22:41.842Z
9500669 9500669 20260315181527_6OXYY AU0043 2026-03-17T12:23:36.017Z 2026-03-23T12:22:40.736Z
9492547 9492547 20260314211427_kJSup AU0043 2026-03-16T12:28:41.503Z 2026-03-22T12:42:52.922Z
9492495 9492495 20260314210617_Siyq6 AU0043 2026-03-16T12:28:38.266Z 2026-03-22T12:42:52.704Z
9491849 9491849 20260315203525_yEaOy AU0043 2026-03-16T12:21:58.941Z 2026-03-23T12:22:42.707Z
9489739 9489739 20260315134133_Nz1Rq AU0043 2026-03-16T12:17:44.174Z 2026-03-23T12:22:34.593Z
9488975 9488975 20260315123647_M7mOW AU0043 2026-03-16T12:16:14.162Z 2026-03-23T12:22:32.810Z
9488407 9488407 20260315115019_qaWXK AU0043 2026-03-16T12:15:06.177Z 2026-03-23T12:22:29.329Z
9462212 9462212 20260311212119_ow7xA AU0043 2026-03-12T12:18:42.341Z 2026-03-19T12:45:51.649Z
9462022 9462022 20260311194738_yTYAO AU0043 2026-03-12T12:18:21.037Z 2026-03-19T12:45:47.387Z
9461813 9461813 20260311185707_tUJ3p AU0043 2026-03-12T12:18:01.884Z 2026-03-19T12:45:44.400Z
9461338 9461338 20260311154705_AXehE AU0043 2026-03-12T12:17:01.075Z 2026-03-19T12:45:17.176Z
9461091 9461091 20260311135735_6y677 AU0043 2026-03-12T12:16:19.052Z 2026-03-19T12:45:11.241Z
9460990 9460990 20260311130246_pR0sh AU0043 2026-03-12T12:16:04.834Z 2026-03-19T12:45:09.136Z
9460948 9460948 20260311122653_RJIIE AU0043 2026-03-12T12:15:58.582Z 2026-03-19T12:45:07.583Z
9431275 9431275 20260303203730_m1Oh5 AU0043 2026-03-06T14:29:34.956Z 2026-03-11T12:29:01.865Z
9431076 9431076 20260303130103_2T8z3 AU0043 2026-03-06T14:28:13.668Z 2026-03-11T12:28:38.323Z
9430262 9430262 20260304153644_YlRIR AU0043 2026-03-06T14:21:52.468Z 2026-03-12T12:33:10.404Z
9430258 9430258 20260304153644_xmGhs AU0043 2026-03-06T14:21:51.844Z 2026-03-12T12:33:10.346Z
9430251 9430251 20260304151816_ZEhWU AU0043 2026-03-06T14:21:47.274Z 2026-03-12T12:33:09.616Z
9430219 9430219 20260304141652_tPo2o AU0043 2026-03-06T14:21:28.517Z 2026-03-12T12:33:06.775Z
9429086 9429086 20260305144913_cjnGX AU0043 2026-03-06T14:15:03.930Z 2026-03-13T12:35:28.978Z
9418695 9418695 20260301204852_QM222 AU0043 2026-03-03T14:12:04.371Z 2026-03-09T12:41:07.811Z
9418674 9418674 20260301204017_2jP0b AU0043 2026-03-03T14:12:00.921Z 2026-03-09T12:41:07.350Z
9418447 9418447 20260301191116_WngPD AU0043 2026-03-03T14:11:19.204Z 2026-03-09T12:40:57.988Z
9418390 9418390 20260301184232_M9JBR AU0043 2026-03-03T14:11:11.793Z 2026-03-09T12:40:56.152Z
9418015 9418015 20260302202306_mY3p7 AU0043 2026-03-03T14:07:37.173Z 2026-03-10T12:36:52.636Z
9417984 9417984 20260302194955_zHxwu AU0043 2026-03-03T14:07:32.084Z 2026-03-10T12:36:51.294Z
9416797 9416797 20260302122914_TgeKR AU0043 2026-03-03T14:04:42.905Z 2026-03-10T12:36:19.115Z
9415108 9415108 20260228200735_h2hfD AU0043 2026-03-02T14:07:24.513Z 2026-03-08T12:43:01.889Z

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