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

4,981 rows where station_code = "AU001N" 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
8678320 8678320 20251203174913_Upxj8 AU001N 2025-12-04T14:04:19.875Z 2025-12-04T14:04:19.875Z
8678317 8678317 20251203174748_MWLXr AU001N 2025-12-04T14:04:19.325Z 2025-12-04T14:04:19.325Z
8678309 8678309 20251203172742_Agshp AU001N 2025-12-04T14:04:16.837Z 2025-12-04T14:04:16.837Z
8678276 8678276 20251203164652_wLJS9 AU001N 2025-12-04T14:04:10.065Z 2025-12-04T14:04:10.065Z
8678264 8678264 20251203163017_aZbJ2 AU001N 2025-12-04T14:04:06.789Z 2025-12-04T14:04:06.789Z
8678262 8678262 20251203162841_6d06H AU001N 2025-12-04T14:04:06.206Z 2025-12-04T14:04:06.206Z
8678252 8678252 20251203160332_bOUvD AU001N 2025-12-04T14:04:03.662Z 2025-12-04T14:04:03.662Z
8678246 8678246 20251203155940_Pn0G8 AU001N 2025-12-04T14:04:02.401Z 2025-12-04T14:04:02.401Z
8678181 8678181 20251203151953_d20Ee AU001N 2025-12-04T14:03:44.549Z 2025-12-04T14:03:44.549Z
8678094 8678094 20251203144158_HFrVX AU001N 2025-12-04T14:03:30.773Z 2025-12-04T14:03:30.773Z
8678029 8678029 20251203140952_OAbhU AU001N 2025-12-04T14:03:15.769Z 2025-12-04T14:03:15.769Z
8677966 8677966 20251203134750_AxRw7 AU001N 2025-12-04T14:03:06.945Z 2025-12-04T14:03:06.945Z
8673231 8673231 20251201173852_qYh0t AU001N 2025-12-03T14:18:02.518Z 2025-12-04T14:23:51.611Z
8673225 8673225 20251201173457_4ABfi AU001N 2025-12-03T14:18:01.413Z 2025-12-04T14:23:51.143Z
8673183 8673183 20251201172214_jrmSB AU001N 2025-12-03T14:17:48.241Z 2025-12-04T14:23:48.083Z
8673086 8673086 20251201165150_bS0ud AU001N 2025-12-03T14:17:30.562Z 2025-12-04T14:23:33.840Z
8672995 8672995 20251201161320_6151L AU001N 2025-12-03T14:17:05.312Z 2025-12-04T14:23:28.083Z
8672559 8672559 20251201144647_ryQIx AU001N 2025-12-03T14:15:54.187Z 2025-12-04T14:22:58.079Z
8672552 8672552 20251201144550_mXN7O AU001N 2025-12-03T14:15:53.534Z 2025-12-04T14:22:57.615Z
8670324 8670324 20251202165116_VCm1X AU001N 2025-12-03T14:07:59.373Z 2025-12-04T14:19:08.172Z
8670318 8670318 20251202164335_zOFay AU001N 2025-12-03T14:07:57.969Z 2025-12-04T14:19:08.166Z
8670312 8670312 20251202163434_beToz AU001N 2025-12-03T14:07:56.477Z 2025-12-04T14:19:08.162Z
8670290 8670290 20251202161024_5kPPh AU001N 2025-12-03T14:07:51.693Z 2025-12-04T14:19:08.153Z
8670274 8670274 20251202155559_c0b3n AU001N 2025-12-03T14:07:48.010Z 2025-12-04T14:19:08.143Z
8670239 8670239 20251202153944_nWBjw AU001N 2025-12-03T14:07:34.998Z 2025-12-04T14:19:08.128Z
8670216 8670216 20251202152702_yq8iP AU001N 2025-12-03T14:07:27.816Z 2025-12-04T14:19:08.071Z
8670195 8670195 20251202151520_Rd20c AU001N 2025-12-03T14:07:22.384Z 2025-12-04T14:19:08.061Z
8670191 8670191 20251202151356_Njrue AU001N 2025-12-03T14:07:21.535Z 2025-12-04T14:19:08.060Z
8670168 8670168 20251202141507_SOewD AU001N 2025-12-03T14:07:16.579Z 2025-12-04T14:19:08.037Z
8670156 8670156 20251202140234_GCYR1 AU001N 2025-12-03T14:07:05.241Z 2025-12-04T14:19:08.032Z
8670132 8670132 20251202131803_YskPf AU001N 2025-12-03T14:07:00.421Z 2025-12-04T14:19:08.019Z
8670114 8670114 20251202131306_u2rky AU001N 2025-12-03T14:06:57.616Z 2025-12-04T14:19:08.013Z
8670087 8670087 20251202130633_pG5X3 AU001N 2025-12-03T14:06:52.119Z 2025-12-04T14:19:08.003Z
8669747 8669747 20251202120716_rKD9s AU001N 2025-12-03T14:05:20.917Z 2025-12-04T14:19:07.900Z
8669196 8669196 20251202103002_LBzgK AU001N 2025-12-03T14:02:49.864Z 2025-12-04T14:19:07.648Z
8662016 8662016 20251130174244_Dupxe AU001N 2025-12-02T14:13:58.770Z 2025-12-04T14:30:48.004Z
8661766 8661766 20251130170843_W7TCG AU001N 2025-12-02T14:12:58.092Z 2025-12-04T14:30:22.570Z
8661712 8661712 20251130165653_UX1uD AU001N 2025-12-02T14:12:41.990Z 2025-12-04T14:30:18.863Z
8661708 8661708 20251130165625_ENVob AU001N 2025-12-02T14:12:41.095Z 2025-12-04T14:30:18.644Z
8661682 8661682 20251130165228_cMYtB AU001N 2025-12-02T14:12:35.426Z 2025-12-04T14:30:17.168Z
8661674 8661674 20251130164935_JU46z AU001N 2025-12-02T14:12:33.536Z 2025-12-04T14:30:16.795Z
8661643 8661643 20251130164034_5zurM AU001N 2025-12-02T14:12:26.947Z 2025-12-04T14:30:13.879Z
8661637 8661637 20251130163748_lbFw7 AU001N 2025-12-02T14:12:25.410Z 2025-12-04T14:30:13.175Z
8661603 8661603 20251130161752_BuoZR AU001N 2025-12-02T14:12:10.708Z 2025-12-04T14:30:10.765Z
8661536 8661536 20251130154455_XD3kl AU001N 2025-12-02T14:11:49.830Z 2025-12-04T14:30:05.297Z
8661492 8661492 20251130153518_iNU11 AU001N 2025-12-02T14:11:39.050Z 2025-12-04T14:29:55.177Z
8661449 8661449 20251130152342_JZCx1 AU001N 2025-12-02T14:11:30.821Z 2025-12-04T14:29:53.043Z
8661294 8661294 20251130150610_J8YZ4 AU001N 2025-12-02T14:11:01.957Z 2025-12-04T14:29:43.817Z
8661189 8661189 20251130145700_YQcJY AU001N 2025-12-02T14:10:40.329Z 2025-12-04T14:29:39.252Z
8661075 8661075 20251130144009_nE27j AU001N 2025-12-02T14:10:16.844Z 2025-12-04T14:29:34.336Z
8660975 8660975 20251130142017_4Cf6W AU001N 2025-12-02T14:09:52.145Z 2025-12-04T14:29:21.860Z
8660378 8660378 20251130124325_88b0x AU001N 2025-12-02T14:07:41.307Z 2025-12-04T14:28:42.893Z
8659822 8659822 20251130111940_L73Yu AU001N 2025-12-02T14:05:24.909Z 2025-12-04T14:28:09.799Z
8659721 8659721 20251130110742_QWuXg AU001N 2025-12-02T14:05:07.682Z 2025-12-04T14:28:06.234Z
8659438 8659438 20251130102715_ZSRo3 AU001N 2025-12-02T14:03:53.772Z 2025-12-04T14:27:49.361Z
8649422 8649422 20251129172327_4lfGR AU001N 2025-12-01T14:12:29.827Z 2025-12-04T14:37:57.147Z
8649397 8649397 20251129172128_ITF7e AU001N 2025-12-01T14:12:25.177Z 2025-12-04T14:37:55.846Z
8649392 8649392 20251129171952_syfqt AU001N 2025-12-01T14:12:23.978Z 2025-12-04T14:37:55.652Z
8649275 8649275 20251129165707_9gUNL AU001N 2025-12-01T14:11:51.753Z 2025-12-04T14:37:51.045Z
8649258 8649258 20251129165152_Zh6Bs AU001N 2025-12-01T14:11:48.166Z 2025-12-04T14:37:50.624Z
8649199 8649199 20251129163624_8P6kT AU001N 2025-12-01T14:11:25.200Z 2025-12-04T14:37:48.051Z
8649160 8649160 20251129162831_nBwnP AU001N 2025-12-01T14:11:14.948Z 2025-12-04T14:37:46.446Z
8649027 8649027 20251129154736_U3drF AU001N 2025-12-01T14:10:31.468Z 2025-12-04T14:37:25.737Z
8648985 8648985 20251129153825_aoiOD AU001N 2025-12-01T14:10:18.017Z 2025-12-04T14:37:21.274Z
8640533 8640533 20251129144331_WHCCH AU001N 2025-11-30T14:08:40.196Z 2025-12-04T14:37:11.550Z
8640451 8640451 20251129142421_E2r76 AU001N 2025-11-30T14:08:26.792Z 2025-12-04T14:37:08.312Z
8640440 8640440 20251129141947_HW36P AU001N 2025-11-30T14:08:25.429Z 2025-12-04T14:37:07.319Z
8640429 8640429 20251129141811_Y9CMe AU001N 2025-11-30T14:08:23.484Z 2025-11-30T14:08:23.484Z
8640197 8640197 20251129130442_xHc23 AU001N 2025-11-30T14:07:31.174Z 2025-11-30T14:07:31.174Z
8639836 8639836 20251129121126_FfBCM AU001N 2025-11-30T14:06:14.078Z 2025-11-30T14:06:14.078Z
8639636 8639636 20251129113409_gPqra AU001N 2025-11-30T14:05:39.240Z 2025-11-30T14:05:39.240Z
8639449 8639449 20251129110747_Y9r73 AU001N 2025-11-30T14:04:58.129Z 2025-12-04T14:36:10.730Z
8639295 8639295 20251129105145_cgJnz AU001N 2025-11-30T14:04:24.628Z 2025-12-04T14:36:03.489Z
8639248 8639248 20251129104909_AkFOW AU001N 2025-11-30T14:04:14.956Z 2025-12-04T14:36:02.102Z
8639158 8639158 20251129103339_T5HL9 AU001N 2025-11-30T14:03:59.222Z 2025-12-04T14:35:58.907Z
8622077 8622077 20251126174541_174XR AU001N 2025-11-28T14:17:37.698Z 2025-12-04T15:01:51.307Z
8621997 8621997 20251126172622_jXlXN AU001N 2025-11-28T14:17:14.790Z 2025-12-04T15:01:49.522Z
8621988 8621988 20251126172318_3mzJ7 AU001N 2025-11-28T14:17:13.452Z 2025-12-04T15:01:49.400Z
8621964 8621964 20251126171940_bGDKQ AU001N 2025-11-28T14:17:09.272Z 2025-12-04T15:01:48.849Z
8621797 8621797 20251126162724_A4tQ2 AU001N 2025-11-28T14:16:37.856Z 2025-12-04T15:01:43.671Z
8621787 8621787 20251126162441_cxFRB AU001N 2025-11-28T14:16:36.464Z 2025-12-04T15:01:43.464Z
8621717 8621717 20251126161043_G028N AU001N 2025-11-28T14:16:27.025Z 2025-12-04T15:01:42.407Z
8621649 8621649 20251126155747_OWe23 AU001N 2025-11-28T14:16:19.604Z 2025-12-04T15:01:41.362Z
8621295 8621295 20251126145225_FPooC AU001N 2025-11-28T14:15:15.103Z 2025-12-04T15:01:35.630Z
8621196 8621196 20251126144202_jv8nw AU001N 2025-11-28T14:15:04.557Z 2025-12-04T15:01:34.209Z
8620128 8620128 20251126115203_vDelt AU001N 2025-11-28T14:11:49.871Z 2025-12-04T15:00:38.949Z
8619054 8619054 20251127173933_DNHG0 AU001N 2025-11-28T14:07:04.259Z 2025-12-04T14:54:21.134Z
8619052 8619052 20251127173911_HAM0t AU001N 2025-11-28T14:07:03.754Z 2025-12-04T14:54:20.900Z
8619028 8619028 20251127171004_66Zs4 AU001N 2025-11-28T14:06:58.745Z 2025-12-04T14:54:17.133Z
8605919 8605919 20251125173056_ako0p AU001N 2025-11-27T14:08:25.949Z 2025-12-04T15:05:51.007Z
8604312 8604312 20251123163614_2x1cn AU001N 2025-11-26T14:31:34.326Z 2025-12-02T15:09:59.159Z
8604310 8604310 20251123160313_JX28Y AU001N 2025-11-26T14:31:24.701Z 2025-12-02T15:09:58.383Z
8604304 8604304 20251123152242_TdvcI AU001N 2025-11-26T14:30:59.479Z 2025-12-02T15:09:56.804Z
8604300 8604300 20251123145904_krNht AU001N 2025-11-26T14:30:50.125Z 2025-12-02T15:09:54.522Z
8604296 8604296 20251123143814_dEkC7 AU001N 2025-11-26T14:30:33.739Z 2025-12-02T15:09:53.661Z
8604294 8604294 20251123142027_TlLkv AU001N 2025-11-26T14:30:30.024Z 2025-12-02T15:09:53.258Z
8604284 8604284 20251123120213_g5R5d AU001N 2025-11-26T14:29:25.719Z 2025-12-02T15:09:48.337Z
8604276 8604276 20251123104926_GsZmt AU001N 2025-11-26T14:29:18.493Z 2025-12-02T15:09:45.953Z
8585764 8585764 20251123174136_x3W9N AU001N 2025-11-25T14:10:47.672Z 2025-12-02T15:10:19.457Z
8576332 8576332 20251122145135_ba9xi AU001N 2025-11-24T14:05:35.073Z 2025-12-01T15:18:35.652Z

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