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,193 rows where station_code = "AU000L" 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
9271764 9271764 20260127195500_s1D39 AU000L 2026-01-29T14:23:22.281Z 2026-01-29T14:30:25.105Z
9271741 9271741 20260127194831_qi3t9 AU000L 2026-01-29T14:23:14.224Z 2026-01-29T14:30:25.086Z
9271729 9271729 20260127194500_JWbMo AU000L 2026-01-29T14:23:02.134Z 2026-01-29T14:30:25.070Z
9271714 9271714 20260127192855_2VeUg AU000L 2026-01-29T14:22:46.917Z 2026-01-29T14:30:25.040Z
9271677 9271677 20260127191018_KciyQ AU000L 2026-01-29T14:22:17.800Z 2026-01-29T14:30:25.018Z
9271533 9271533 20260127173539_BA5kf AU000L 2026-01-29T14:21:12.708Z 2026-01-29T14:30:24.892Z
9271475 9271475 20260127165248_dfADP AU000L 2026-01-29T14:20:47.657Z 2026-01-29T14:30:24.829Z
9271473 9271473 20260127164828_kTVej AU000L 2026-01-29T14:20:46.978Z 2026-01-29T14:30:24.828Z
9271419 9271419 20260127152950_k9pAt AU000L 2026-01-29T14:19:54.098Z 2026-01-29T14:30:24.600Z
9271395 9271395 20260127150029_Bjgsa AU000L 2026-01-29T14:19:31.214Z 2026-01-29T14:30:24.527Z
9271362 9271362 20260127134648_SQxev AU000L 2026-01-29T14:18:49.517Z 2026-01-29T14:30:24.407Z
9266898 9266898 20260126160433_TZsLo AU000L 2026-01-28T14:17:24.012Z 2026-01-29T14:33:40.578Z
9263303 9263303 20260124165955_BbSBj AU000L 2026-01-27T14:20:52.455Z 2026-01-29T14:42:09.418Z
9263272 9263272 20260124162044_hl6p2 AU000L 2026-01-27T14:20:34.918Z 2026-01-29T14:41:57.734Z
9263244 9263244 20260124150321_w1M04 AU000L 2026-01-27T14:20:03.149Z 2026-01-29T14:41:39.418Z
9263233 9263233 20260124143156_a1AmT AU000L 2026-01-27T14:19:47.579Z 2026-01-29T14:41:26.442Z
9262548 9262548 20260125200017_ATrFM AU000L 2026-01-27T14:13:29.713Z 2026-01-29T14:38:12.652Z
9262546 9262546 20260125195814_Nhezv AU000L 2026-01-27T14:13:28.382Z 2026-01-29T14:38:12.392Z
9262532 9262532 20260125182858_Qxl3l AU000L 2026-01-27T14:12:39.976Z 2026-01-29T14:38:02.033Z
9258566 9258566 20260124143627_3f4zw AU000L 2026-01-26T14:13:01.990Z 2026-01-29T14:41:29.564Z
9254302 9254302 20260123180050_KHIOx AU000L 2026-01-25T14:08:24.613Z 2026-01-29T14:46:05.051Z
9254240 9254240 20260123171941_Y4zWC AU000L 2026-01-25T14:08:04.217Z 2026-01-29T14:46:00.469Z
9254219 9254219 20260123165919_064Oo AU000L 2026-01-25T14:07:54.403Z 2026-01-29T14:45:58.749Z
9246925 9246925 20260121153806_k8wb4 AU000L 2026-01-23T14:08:29.755Z 2026-01-29T14:55:20.442Z
9244725 9244725 20260119151013_PCyi0 AU000L 2026-01-22T14:29:59.030Z 2026-01-28T14:55:58.750Z
9241374 9241374 20260120201520_hgemj AU000L 2026-01-22T14:12:51.599Z 2026-01-29T15:02:33.995Z
9241212 9241212 20260120192859_eFvdD AU000L 2026-01-22T14:12:09.753Z 2026-01-29T15:02:27.127Z
9240964 9240964 20260120183805_oW1ar AU000L 2026-01-22T14:11:04.069Z 2026-01-29T15:02:07.187Z
9240862 9240862 20260120180744_Iw1DL AU000L 2026-01-22T14:10:27.329Z 2026-01-29T15:01:58.990Z
9240500 9240500 20260120162821_A3X0B AU000L 2026-01-22T14:08:39.763Z 2026-01-29T15:01:28.443Z
9240469 9240469 20260120161836_G2HYn AU000L 2026-01-22T14:08:32.884Z 2026-01-29T15:01:26.773Z
9240381 9240381 20260120154337_HIrjT AU000L 2026-01-22T14:08:06.257Z 2026-01-29T15:01:20.897Z
9240352 9240352 20260120152433_BUrKd AU000L 2026-01-22T14:07:58.315Z 2026-01-29T15:01:18.956Z
9240249 9240249 20260120142149_eeRdN AU000L 2026-01-22T14:07:13.234Z 2026-01-29T15:00:54.221Z
9240239 9240239 20260120141313_8ilC4 AU000L 2026-01-22T14:07:10.522Z 2026-01-29T15:00:53.309Z
9234111 9234111 20260119194210_DWw38 AU000L 2026-01-21T14:12:25.989Z 2026-01-28T14:57:06.951Z
9233971 9233971 20260119190449_WyJVQ AU000L 2026-01-21T14:11:35.353Z 2026-01-28T14:56:56.399Z
9233667 9233667 20260119163130_TaxZ1 AU000L 2026-01-21T14:09:39.982Z 2026-01-28T14:56:19.889Z
9233660 9233660 20260119162347_nTEBb AU000L 2026-01-21T14:09:38.087Z 2026-01-28T14:56:19.607Z
9233615 9233615 20260119153055_0b5he AU000L 2026-01-21T14:09:09.839Z 2026-01-28T14:56:11.485Z
9227683 9227683 20260118162934_GlgGO AU000L 2026-01-20T14:13:05.980Z 2026-01-27T15:00:34.552Z
9227679 9227679 20260118162655_kJPWL AU000L 2026-01-20T14:13:04.732Z 2026-01-27T15:00:34.143Z
9227667 9227667 20260118160437_jHY9b AU000L 2026-01-20T14:12:57.651Z 2026-01-27T15:00:32.332Z
9227664 9227664 20260118155351_y3buS AU000L 2026-01-20T14:12:54.035Z 2026-01-27T15:00:30.858Z
9227655 9227655 20260118154500_G274y AU000L 2026-01-20T14:12:45.493Z 2026-01-27T15:00:27.297Z
9227628 9227628 20260118144414_LyolK AU000L 2026-01-20T14:11:48.975Z 2026-01-27T14:59:51.654Z
9227596 9227596 20260118134343_25K8b AU000L 2026-01-20T14:11:08.159Z 2026-01-27T14:59:27.460Z
9227594 9227594 20260118131545_Ag0iP AU000L 2026-01-20T14:10:54.718Z 2026-01-27T14:59:23.333Z
9227590 9227590 20260118130337_xN68a AU000L 2026-01-20T14:10:41.695Z 2026-01-27T14:59:18.403Z
9225856 9225856 20260116190422_fyF2q AU000L 2026-01-19T14:34:16.322Z 2026-01-25T14:57:43.113Z
9222695 9222695 20260117202227_eHj1C AU000L 2026-01-19T14:15:53.322Z 2026-01-26T15:01:17.850Z
9222647 9222647 20260117201235_nP4I2 AU000L 2026-01-19T14:15:41.358Z 2026-01-26T15:01:15.973Z
9222427 9222427 20260117193048_pOE2Y AU000L 2026-01-19T14:14:43.690Z 2026-01-26T15:00:53.445Z
9222299 9222299 20260117190100_nr9tx AU000L 2026-01-19T14:14:08.295Z 2026-01-26T15:00:47.031Z
9222282 9222282 20260117185551_4qT62 AU000L 2026-01-19T14:14:03.786Z 2026-01-26T15:00:46.353Z
9221906 9221906 20260117171415_Nbcr8 AU000L 2026-01-19T14:12:24.797Z 2026-01-26T15:00:29.956Z
9221878 9221878 20260117170540_hW7Ij AU000L 2026-01-19T14:12:19.952Z 2026-01-26T15:00:28.801Z
9221783 9221783 20260117162907_gVGS7 AU000L 2026-01-19T14:11:55.025Z 2026-01-26T15:00:09.805Z
9221756 9221756 20260117154012_vgFxU AU000L 2026-01-19T14:11:29.209Z 2026-01-26T15:00:02.739Z
9211795 9211795 20260115174914_pTDAq AU000L 2026-01-17T14:08:31.658Z 2026-01-24T15:09:55.850Z
9211518 9211518 20260115161853_2Nn4A AU000L 2026-01-17T14:07:03.666Z 2026-01-24T15:09:30.360Z
9211373 9211373 20260115150523_Tv5sj AU000L 2026-01-17T14:06:21.949Z 2026-01-24T15:09:11.140Z
9211250 9211250 20260115140942_U3SGH AU000L 2026-01-17T14:05:47.768Z 2026-01-24T15:08:56.530Z
9211232 9211232 20260115135446_69YFj AU000L 2026-01-17T14:05:41.842Z 2026-01-24T15:08:54.730Z
9211168 9211168 20260115125537_nwp66 AU000L 2026-01-17T14:05:07.509Z 2026-01-24T15:08:41.419Z
9211157 9211157 20260115122754_pxZUT AU000L 2026-01-17T14:04:42.583Z 2026-01-24T15:08:28.458Z
9206897 9206897 20260114193827_Mfora AU000L 2026-01-16T14:06:04.754Z 2026-01-22T15:02:42.718Z
9206842 9206842 20260114191520_EVo28 AU000L 2026-01-16T14:05:49.222Z 2026-01-22T15:02:38.367Z
9206784 9206784 20260114185515_7ijRc AU000L 2026-01-16T14:05:33.487Z 2026-01-22T15:02:36.474Z
9206684 9206684 20260114181859_39MkB AU000L 2026-01-16T14:05:04.105Z 2026-01-22T15:02:33.519Z
9206634 9206634 20260114180053_02VNA AU000L 2026-01-16T14:04:52.246Z 2026-01-22T15:02:32.244Z
9206568 9206568 20260114174440_f63EZ AU000L 2026-01-16T14:04:30.808Z 2026-01-22T15:02:30.225Z
9206489 9206489 20260114171245_JIu3Z AU000L 2026-01-16T14:04:10.779Z 2026-01-22T15:02:27.778Z
9206440 9206440 20260114165049_lZchQ AU000L 2026-01-16T14:03:55.346Z 2026-01-22T15:02:25.872Z
9206385 9206385 20260114163159_F2EEL AU000L 2026-01-16T14:03:39.119Z 2026-01-22T15:02:22.654Z
9206241 9206241 20260114145501_DvvAe AU000L 2026-01-16T14:02:54.990Z 2026-01-22T15:01:56.499Z
9206237 9206237 20260114145401_q4IAB AU000L 2026-01-16T14:02:53.711Z 2026-01-22T15:01:56.341Z
9206231 9206231 20260114144418_GXgIA AU000L 2026-01-16T14:02:50.866Z 2026-01-22T15:01:56.116Z
9205766 9205766 20260113130434_99180 AU000L 2026-01-15T14:41:23.285Z 2026-01-21T15:06:26.845Z
9198928 9198928 20260113183513_QQSGX AU000L 2026-01-15T14:08:24.609Z 2026-01-22T15:07:09.608Z
9198871 9198871 20260113181841_iH31l AU000L 2026-01-15T14:07:50.275Z 2026-01-22T15:07:07.106Z
9198861 9198861 20260113181628_zjH3P AU000L 2026-01-15T14:07:47.626Z 2026-01-22T15:07:06.828Z
9198691 9198691 20260113173651_k8Fml AU000L 2026-01-15T14:06:25.730Z 2026-01-22T15:07:00.877Z
9198665 9198665 20260113173057_q3VCd AU000L 2026-01-15T14:06:19.123Z 2026-01-22T15:07:00.107Z
9198645 9198645 20260113172655_na12d AU000L 2026-01-15T14:06:05.512Z 2026-01-22T15:06:59.575Z
9198504 9198504 20260113164854_MFekc AU000L 2026-01-15T14:04:59.527Z 2026-01-22T15:06:32.139Z
9198479 9198479 20260113164005_Hvahr AU000L 2026-01-15T14:04:42.101Z 2026-01-15T14:31:30.712Z
9198477 9198477 20260113164004_teBks AU000L 2026-01-15T14:04:41.558Z 2026-01-22T15:06:31.293Z
9198468 9198468 20260113163627_Sv6BE AU000L 2026-01-15T14:04:36.759Z 2026-01-22T15:06:30.859Z
9198434 9198434 20260113162442_eCACr AU000L 2026-01-15T14:04:26.253Z 2026-01-22T15:06:27.674Z
9198361 9198361 20260113155458_jYKoB AU000L 2026-01-15T14:03:37.480Z 2026-01-22T15:06:24.350Z
9198337 9198337 20260113154225_qDrsT AU000L 2026-01-15T14:03:23.738Z 2026-01-22T15:06:23.240Z
9198190 9198190 20260113142701_E9vCR AU000L 2026-01-15T14:01:53.533Z 2026-01-22T15:06:16.610Z
9198108 9198108 20260113132002_N4AKw AU000L 2026-01-15T14:00:45.240Z 2026-01-22T15:06:01.286Z
9193238 9193238 20260112124745_VVkrD AU000L 2026-01-13T14:30:55.769Z 2026-01-13T14:30:55.769Z
9188057 9188057 20260111200929_kQ2Wt AU000L 2026-01-13T14:10:14.569Z 2026-01-20T15:21:10.603Z
9188035 9188035 20260111200510_dLTTI AU000L 2026-01-13T14:10:07.872Z 2026-01-20T15:21:07.851Z
9187983 9187983 20260111195202_wVeGV AU000L 2026-01-13T14:09:52.541Z 2026-01-20T15:21:05.176Z
9187979 9187979 20260111195139_d3s6m AU000L 2026-01-13T14:09:51.387Z 2026-01-20T15:21:04.854Z
9187844 9187844 20260111190512_kmlu8 AU000L 2026-01-13T14:09:08.587Z 2026-01-20T15:20:57.141Z

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