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,524 rows where station_code = "AU004Q" 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
8678291 8678291 20251203165834_PRtsf AU004Q 2025-12-04T14:04:13.514Z 2025-12-06T14:21:03.822Z
8678232 8678232 20251203154618_oN64o AU004Q 2025-12-04T14:03:58.617Z 2025-12-06T14:20:50.704Z
8678189 8678189 20251203152223_3yuXm AU004Q 2025-12-04T14:03:45.962Z 2025-12-06T14:20:45.779Z
8678156 8678156 20251203150704_UlWqA AU004Q 2025-12-04T14:03:40.292Z 2025-12-06T14:20:37.719Z
8678079 8678079 20251203143610_TLpNj AU004Q 2025-12-04T14:03:29.001Z 2025-12-06T14:20:31.488Z
8671840 8671840 20251201130443_2HP4J AU004Q 2025-12-03T14:13:55.326Z 2025-12-06T14:31:22.026Z
8670364 8670364 20251202174746_OSAFk AU004Q 2025-12-03T14:08:16.228Z 2025-12-06T14:25:31.621Z
8670362 8670362 20251202174302_wD2Bb AU004Q 2025-12-03T14:08:10.707Z 2025-12-06T14:25:30.881Z
8670353 8670353 20251202173705_BTvqo AU004Q 2025-12-03T14:08:08.972Z 2025-12-06T14:25:29.204Z
8670349 8670349 20251202172924_hGAux AU004Q 2025-12-03T14:08:07.905Z 2025-12-06T14:25:26.335Z
8670332 8670332 20251202170726_L1hSz AU004Q 2025-12-03T14:08:00.965Z 2025-12-06T14:25:21.201Z
8670310 8670310 20251202162816_iX4Ww AU004Q 2025-12-03T14:07:55.943Z 2025-12-06T14:25:07.538Z
8670300 8670300 20251202162053_o12Ji AU004Q 2025-12-03T14:07:53.850Z 2025-12-06T14:25:06.072Z
8670283 8670283 20251202160222_HMxCw AU004Q 2025-12-03T14:07:49.916Z 2025-12-06T14:25:02.985Z
8670277 8670277 20251202155602_RyoZk AU004Q 2025-12-03T14:07:48.513Z 2025-12-06T14:25:01.867Z
8670248 8670248 20251202154303_lwSTJ AU004Q 2025-12-03T14:07:42.877Z 2025-12-06T14:24:57.392Z
8670154 8670154 20251202140149_IFgMR AU004Q 2025-12-03T14:07:04.628Z 2025-12-06T14:24:46.451Z
8670079 8670079 20251202130251_5v5jO AU004Q 2025-12-03T14:06:49.158Z 2025-12-06T14:24:35.275Z
8661927 8661927 20251130173330_BgDFK AU004Q 2025-12-02T14:13:38.346Z 2025-12-06T14:38:42.211Z
8619024 8619024 20251127164545_LrRYG AU004Q 2025-11-28T14:06:57.896Z 2025-12-06T14:59:12.754Z
8619022 8619022 20251127164534_2DziU AU004Q 2025-11-28T14:06:57.496Z 2025-12-06T14:59:12.739Z
8619009 8619009 20251127163354_nvyS2 AU004Q 2025-11-28T14:06:47.265Z 2025-12-06T14:59:08.853Z
8618985 8618985 20251127154546_YxyyZ AU004Q 2025-11-28T14:06:39.363Z 2025-12-06T14:59:01.846Z
8618974 8618974 20251127152331_KV22f AU004Q 2025-11-28T14:06:36.790Z 2025-12-06T14:59:00.578Z
8618912 8618912 20251127144027_05wao AU004Q 2025-11-28T14:06:24.619Z 2025-12-06T14:58:58.467Z
8618862 8618862 20251127141853_AfXpS AU004Q 2025-11-28T14:06:05.744Z 2025-12-06T14:58:55.570Z
8618859 8618859 20251127141822_EIogo AU004Q 2025-11-28T14:06:05.293Z 2025-12-06T14:58:55.563Z
8618824 8618824 20251127140043_uZhRO AU004Q 2025-11-28T14:05:59.594Z 2025-12-06T14:58:54.463Z
8618816 8618816 20251127135705_t3JRh AU004Q 2025-11-28T14:05:58.381Z 2025-12-06T14:58:54.371Z
8618786 8618786 20251127133928_9hkxo AU004Q 2025-11-28T14:05:52.957Z 2025-12-06T14:58:53.065Z
8618688 8618688 20251127130509_FszF4 AU004Q 2025-11-28T14:05:27.362Z 2025-12-06T14:58:50.063Z
8618539 8618539 20251127123338_Zl6bY AU004Q 2025-11-28T14:04:53.805Z 2025-12-06T14:58:46.842Z
8618041 8618041 20251127111914_QYBcj AU004Q 2025-11-28T14:03:13.987Z 2025-12-06T14:58:28.931Z
8618030 8618030 20251127111805_lHZqB AU004Q 2025-11-28T14:03:12.168Z 2025-12-06T14:58:28.745Z
8617858 8617858 20251127103910_mp1y2 AU004Q 2025-11-28T14:02:38.716Z 2025-12-06T14:58:25.616Z
8606060 8606060 20251125174636_KItIA AU004Q 2025-11-27T14:08:45.294Z 2025-12-04T15:06:01.703Z
8606058 8606058 20251125174632_oT6Nf AU004Q 2025-11-27T14:08:44.832Z 2025-12-04T15:06:01.482Z
8605922 8605922 20251125173109_2hsDH AU004Q 2025-11-27T14:08:26.633Z 2025-12-04T15:05:51.166Z
8605798 8605798 20251125171128_lI593 AU004Q 2025-11-27T14:07:56.138Z 2025-12-04T15:05:43.635Z
8605745 8605745 20251125164052_rS2uB AU004Q 2025-11-27T14:07:36.091Z 2025-12-04T15:05:38.175Z
8605633 8605633 20251125152428_QzJUg AU004Q 2025-11-27T14:06:48.133Z 2025-12-04T15:05:34.757Z
8605493 8605493 20251125131616_wQKuE AU004Q 2025-11-27T14:05:23.251Z 2025-12-04T15:05:26.354Z
8605481 8605481 20251125130150_2X06p AU004Q 2025-11-27T14:05:15.773Z 2025-12-04T15:05:25.569Z
8605479 8605479 20251125125956_UFPCS AU004Q 2025-11-27T14:05:14.928Z 2025-12-04T15:05:25.433Z
8605469 8605469 20251125124606_oAGYn AU004Q 2025-11-27T14:05:04.254Z 2025-12-04T15:05:23.998Z
8605465 8605465 20251125124501_zgDiO AU004Q 2025-11-27T14:05:02.650Z 2025-12-04T15:05:23.855Z
8605459 8605459 20251125123410_Mv0Un AU004Q 2025-11-27T14:04:57.355Z 2025-12-04T15:05:23.223Z
8605414 8605414 20251125105912_uwVgh AU004Q 2025-11-27T14:04:03.511Z 2025-12-04T15:05:15.307Z
8605401 8605401 20251125103048_NL2cD AU004Q 2025-11-27T14:03:46.282Z 2025-12-04T15:05:12.955Z
8595637 8595637 20251124172822_XJ94O AU004Q 2025-11-26T14:11:51.324Z 2025-12-02T15:06:04.143Z
8595618 8595618 20251124171449_2O3It AU004Q 2025-11-26T14:11:46.618Z 2025-12-02T15:06:02.391Z
8595305 8595305 20251124150220_CNR6u AU004Q 2025-11-26T14:10:34.291Z 2025-12-02T15:05:52.049Z
8595285 8595285 20251124145235_mp2fN AU004Q 2025-11-26T14:10:30.331Z 2025-12-02T15:05:51.240Z
8595211 8595211 20251124143235_mu6So AU004Q 2025-11-26T14:10:18.978Z 2025-12-02T15:05:44.808Z
8595074 8595074 20251124140144_Hn7wk AU004Q 2025-11-26T14:09:50.257Z 2025-12-02T15:05:40.672Z
8595037 8595037 20251124135013_e2BFi AU004Q 2025-11-26T14:09:44.115Z 2025-12-02T15:05:40.368Z
8594866 8594866 20251124125748_Ivb4j AU004Q 2025-11-26T14:09:02.019Z 2025-12-02T15:05:38.534Z
8594688 8594688 20251124122610_EPfFO AU004Q 2025-11-26T14:08:14.319Z 2025-12-02T15:05:35.171Z
8545812 8545812 20251120173300_JBSfj AU004Q 2025-11-22T14:11:23.434Z 2025-11-29T14:54:06.358Z
8544255 8544255 20251120150037_mogH2 AU004Q 2025-11-22T14:07:21.061Z 2025-11-29T14:53:43.216Z
8544164 8544164 20251120145431_b5hhb AU004Q 2025-11-22T14:07:09.278Z 2025-11-29T14:53:41.735Z
8544139 8544139 20251120145158_Sx9pi AU004Q 2025-11-22T14:07:01.755Z 2025-11-29T14:53:41.463Z
8543978 8543978 20251120143859_y2a9g AU004Q 2025-11-22T14:06:41.406Z 2025-11-29T14:53:33.564Z
8543964 8543964 20251120143626_tPiTq AU004Q 2025-11-22T14:06:38.885Z 2025-11-29T14:53:33.278Z
8543811 8543811 20251120142702_hGObD AU004Q 2025-11-22T14:06:12.994Z 2025-11-29T14:53:29.783Z
8543254 8543254 20251120133904_A79I2 AU004Q 2025-11-22T14:04:30.180Z 2025-11-29T14:53:21.684Z
8542620 8542620 20251120123326_rv49Q AU004Q 2025-11-22T14:02:41.073Z 2025-11-29T14:53:13.562Z
8542431 8542431 20251120121329_PmLYf AU004Q 2025-11-22T14:02:11.140Z 2025-11-29T14:53:11.910Z
8532628 8532628 20251119163124_9D1Nl AU004Q 2025-11-21T14:08:26.603Z 2025-11-28T14:53:59.610Z
8531926 8531926 20251119151410_TCOB2 AU004Q 2025-11-21T14:06:42.897Z 2025-11-28T14:53:46.996Z
8531464 8531464 20251119143219_yGLDA AU004Q 2025-11-21T14:05:17.728Z 2025-11-28T14:53:35.323Z
8518414 8518414 20251118140534_IGLNA AU004Q 2025-11-20T14:03:27.542Z 2025-11-27T15:11:03.107Z
8485696 8485696 20251115105903_jJ7Gk AU004Q 2025-11-17T14:34:00.538Z 2025-11-23T15:20:10.985Z
8485288 8485288 20251115103656_9Zjh6 AU004Q 2025-11-17T14:33:49.486Z 2025-11-23T15:19:59.022Z
8472038 8472038 20251114103930_r6tlC AU004Q 2025-11-16T14:32:56.448Z 2025-11-22T15:23:58.597Z
8446489 8446489 20251112173528_zpbZm AU004Q 2025-11-14T14:10:58.940Z 2025-11-21T15:11:11.126Z
8446451 8446451 20251112173234_OrFBc AU004Q 2025-11-14T14:10:50.364Z 2025-11-21T15:11:10.717Z
8446244 8446244 20251112170525_naYpB AU004Q 2025-11-14T14:10:00.674Z 2025-11-21T15:11:08.499Z
8446239 8446239 20251112170525_L3Q7q AU004Q 2025-11-14T14:10:00.441Z 2025-11-21T15:11:08.469Z
8446125 8446125 20251112164953_3wEG3 AU004Q 2025-11-14T14:09:33.052Z 2025-11-21T15:11:07.360Z
8446073 8446073 20251112164410_ya8QE AU004Q 2025-11-14T14:09:26.228Z 2025-11-21T15:11:06.943Z
8445835 8445835 20251112160750_lMBYB AU004Q 2025-11-14T14:08:39.040Z 2025-11-21T15:11:05.278Z
8445571 8445571 20251112154119_DSZD9 AU004Q 2025-11-14T14:07:59.614Z 2025-11-21T15:10:54.909Z
8445309 8445309 20251112151705_g4mne AU004Q 2025-11-14T14:07:13.266Z 2025-11-21T15:10:44.381Z
8445118 8445118 20251112144832_ETqh3 AU004Q 2025-11-14T14:06:34.973Z 2025-11-21T15:10:39.950Z
8445099 8445099 20251112144600_TXE2X AU004Q 2025-11-14T14:06:31.747Z 2025-11-21T15:10:38.466Z
8445007 8445007 20251112143133_FrWt3 AU004Q 2025-11-14T14:06:06.297Z 2025-11-21T15:10:35.601Z
8444982 8444982 20251112142613_g32iJ AU004Q 2025-11-14T14:06:00.328Z 2025-11-21T15:10:34.702Z
8444943 8444943 20251112141752_fP8E4 AU004Q 2025-11-14T14:05:52.649Z 2025-11-21T15:10:33.887Z
8444776 8444776 20251112134623_BGJvl AU004Q 2025-11-14T14:05:23.647Z 2025-11-21T15:10:29.336Z
8444754 8444754 20251112134200_r4X35 AU004Q 2025-11-14T14:05:19.684Z 2025-11-21T15:10:29.178Z
8444587 8444587 20251112131106_TD8BL AU004Q 2025-11-14T14:04:44.253Z 2025-11-21T15:10:25.849Z
8444544 8444544 20251112125740_3Ed2Z AU004Q 2025-11-14T14:04:28.439Z 2025-11-21T15:10:22.729Z
8444366 8444366 20251112121139_0B2Oq AU004Q 2025-11-14T14:03:28.319Z 2025-11-21T15:10:13.636Z
8443396 8443396 20251111115956_BgjWc AU004Q 2025-11-13T14:50:47.452Z 2025-11-19T15:19:15.381Z
8443225 8443225 20251111113409_JLUUd AU004Q 2025-11-13T14:50:40.044Z 2025-11-19T15:19:08.327Z
8443204 8443204 20251111113234_DxUtM AU004Q 2025-11-13T14:50:39.483Z 2025-11-19T15:19:07.965Z
8443188 8443188 20251111113043_ObNVK AU004Q 2025-11-13T14:50:38.937Z 2025-11-19T15:19:05.556Z
8443181 8443181 20251111112953_SJzZ2 AU004Q 2025-11-13T14:50:38.471Z 2025-11-19T15:19:05.227Z
8443105 8443105 20251111111640_3lc33 AU004Q 2025-11-13T14:50:28.116Z 2025-11-19T15:18:59.610Z

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