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

>10,000 rows count all where station_code = "AU0010" 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
9270641 9270641 20260128161741_sG3UC AU0010 2026-01-29T14:13:10.761Z 2026-01-29T14:13:10.761Z
9266633 9266633 20260127201130_gUHiR AU0010 2026-01-28T14:14:08.228Z 2026-01-29T14:30:25.145Z
9266552 9266552 20260127195039_ZQT0L AU0010 2026-01-28T14:13:50.923Z 2026-01-29T14:30:25.099Z
9266409 9266409 20260127191503_ZT2a5 AU0010 2026-01-28T14:13:26.130Z 2026-01-29T14:30:25.023Z
9266320 9266320 20260127185223_cLzD8 AU0010 2026-01-28T14:13:13.492Z 2026-01-29T14:30:24.994Z
9266195 9266195 20260127175920_Zpvh5 AU0010 2026-01-28T14:12:47.310Z 2026-01-29T14:30:24.912Z
9262429 9262429 20260126202454_feOpr AU0010 2026-01-27T14:09:00.396Z 2026-01-29T14:34:31.552Z
9262426 9262426 20260126202349_mmfXh AU0010 2026-01-27T14:08:59.860Z 2026-01-29T14:34:30.731Z
9262342 9262342 20260126193904_sVSQk AU0010 2026-01-27T14:08:45.310Z 2026-01-29T14:34:22.792Z
9262291 9262291 20260126185126_mTIrm AU0010 2026-01-27T14:08:29.666Z 2026-01-27T14:08:29.666Z
9262237 9262237 20260126182808_PEPd2 AU0010 2026-01-27T14:08:17.906Z 2026-01-29T14:34:05.834Z
9261881 9261881 20260126142250_kKWDh AU0010 2026-01-27T14:06:14.501Z 2026-01-29T14:33:13.688Z
9258805 9258805 20260124171402_3gmJG AU0010 2026-01-26T14:14:30.182Z 2026-01-29T14:42:11.672Z
9258802 9258802 20260124171402_5oV3q AU0010 2026-01-26T14:14:29.705Z 2026-01-29T14:42:11.577Z
9258750 9258750 20260124163830_MpzOG AU0010 2026-01-26T14:14:12.416Z 2026-01-29T14:42:00.609Z
9258509 9258509 20260124140653_mOWoS AU0010 2026-01-26T14:12:37.527Z 2026-01-29T14:41:20.382Z
9258490 9258490 20260124134032_pkyXD AU0010 2026-01-26T14:12:29.390Z 2026-01-29T14:41:16.392Z
9254583 9254583 20260123201506_UFK9h AU0010 2026-01-25T14:09:57.841Z 2026-01-29T14:46:31.035Z
9254346 9254346 20260123183429_P3dHN AU0010 2026-01-25T14:08:38.350Z 2026-01-29T14:46:10.940Z
9254274 9254274 20260123174839_w9oSU AU0010 2026-01-25T14:08:14.807Z 2026-01-29T14:46:03.284Z
9254252 9254252 20260123172920_CjiRP AU0010 2026-01-25T14:08:07.784Z 2026-01-29T14:46:01.530Z
9254080 9254080 20260123145348_6zYCD AU0010 2026-01-25T14:06:54.471Z 2026-01-29T14:45:34.217Z
9254012 9254012 20260123125131_pbpb6 AU0010 2026-01-25T14:06:18.755Z 2026-01-29T14:45:15.777Z
9241387 9241387 20260120201838_qMDg2 AU0010 2026-01-22T14:12:54.171Z 2026-01-29T15:02:34.425Z
9241281 9241281 20260120194850_eujfd AU0010 2026-01-22T14:12:25.814Z 2026-01-29T15:02:30.326Z
9241128 9241128 20260120191043_xcnT5 AU0010 2026-01-22T14:11:43.398Z 2026-01-29T15:02:23.388Z
9241033 9241033 20260120185310_bqSSU AU0010 2026-01-22T14:11:26.218Z 2026-01-29T15:02:10.064Z
9240919 9240919 20260120182737_qLRaq AU0010 2026-01-22T14:10:55.507Z 2026-01-29T15:02:02.842Z
9240894 9240894 20260120181748_kmIAF AU0010 2026-01-22T14:10:46.172Z 2026-01-29T15:02:01.343Z
9240882 9240882 20260120181413_v0lHf AU0010 2026-01-22T14:10:36.492Z 2026-01-29T15:02:00.550Z
9233787 9233787 20260119175358_Y6ozF AU0010 2026-01-21T14:10:37.432Z 2026-01-28T14:56:34.208Z
9233774 9233774 20260119174929_Dzk2Y AU0010 2026-01-21T14:10:27.738Z 2026-01-28T14:56:32.326Z
9227527 9227527 20260119202659_08G4A AU0010 2026-01-20T14:08:52.482Z 2026-01-28T14:57:25.308Z
9227473 9227473 20260119184237_63exi AU0010 2026-01-20T14:08:30.999Z 2026-01-28T14:56:52.077Z
9227451 9227451 20260119175236_2kjgm AU0010 2026-01-20T14:08:23.980Z 2026-01-20T14:08:23.980Z
9227448 9227448 20260119174929_8yXo8 AU0010 2026-01-20T14:08:23.150Z 2026-01-20T14:08:23.150Z
9227441 9227441 20260119174203_9jYR3 AU0010 2026-01-20T14:08:20.704Z 2026-01-28T14:56:30.938Z
9227348 9227348 20260119155347_284sb AU0010 2026-01-20T14:07:53.177Z 2026-01-28T14:56:16.003Z
9212187 9212187 20260115194729_ZhfPZ AU0010 2026-01-17T14:10:28.474Z 2026-01-17T14:10:28.474Z
9211925 9211925 20260115182446_CNOtg AU0010 2026-01-17T14:09:05.506Z 2026-01-24T15:10:11.485Z
9211900 9211900 20260115181700_Adznr AU0010 2026-01-17T14:08:58.203Z 2026-01-24T15:10:09.701Z
9211601 9211601 20260115164848_aDrUi AU0010 2026-01-17T14:07:27.690Z 2026-01-24T15:09:38.758Z
9211544 9211544 20260115162850_DvJRZ AU0010 2026-01-17T14:07:11.581Z 2026-01-24T15:09:31.792Z
9211491 9211491 20260115161138_LKWt3 AU0010 2026-01-17T14:06:55.855Z 2026-01-24T15:09:19.234Z
9211478 9211478 20260115160113_6SUc7 AU0010 2026-01-17T14:06:52.656Z 2026-01-24T15:09:17.340Z
9211474 9211474 20260115160112_TeL2Y AU0010 2026-01-17T14:06:52.145Z 2026-01-24T15:09:17.203Z
9211452 9211452 20260115154315_Cyfo4 AU0010 2026-01-17T14:06:41.801Z 2026-01-24T15:09:15.365Z
9211319 9211319 20260115143711_Y7opy AU0010 2026-01-17T14:06:05.785Z 2026-01-24T15:09:06.200Z
9211213 9211213 20260115134407_lYUIe AU0010 2026-01-17T14:05:37.513Z 2026-01-24T15:08:54.280Z
9207016 9207016 20260114202651_1IU49 AU0010 2026-01-16T14:06:41.460Z 2026-01-22T15:02:51.833Z
9206991 9206991 20260114201704_l9QiS AU0010 2026-01-16T14:06:32.336Z 2026-01-22T15:02:46.425Z
9206958 9206958 20260114200127_MkOzK AU0010 2026-01-16T14:06:21.084Z 2026-01-22T15:02:44.604Z
9206938 9206938 20260114195415_tPbKi AU0010 2026-01-16T14:06:15.306Z 2026-01-22T15:02:43.951Z
9206875 9206875 20260114193242_KusHO AU0010 2026-01-16T14:05:58.915Z 2026-01-22T15:02:41.713Z
9206866 9206866 20260114192830_2bZL2 AU0010 2026-01-16T14:05:56.848Z 2026-01-22T15:02:41.500Z
9206856 9206856 20260114191919_BCnKm AU0010 2026-01-16T14:05:54.464Z 2026-01-22T15:02:41.159Z
9206799 9206799 20260114190123_tLSv3 AU0010 2026-01-16T14:05:37.299Z 2026-01-22T15:02:36.965Z
9206774 9206774 20260114184724_fACki AU0010 2026-01-16T14:05:29.820Z 2026-01-22T15:02:36.126Z
9206772 9206772 20260114184724_prXhR AU0010 2026-01-16T14:05:29.353Z 2026-01-22T15:02:36.038Z
9206682 9206682 20260114181853_3qpa4 AU0010 2026-01-16T14:05:03.446Z 2026-01-22T15:02:33.420Z
9206564 9206564 20260114174411_t0Tg2 AU0010 2026-01-16T14:04:29.260Z 2026-01-22T15:02:30.058Z
9206432 9206432 20260114164746_2NoNg AU0010 2026-01-16T14:03:53.308Z 2026-01-22T15:02:25.637Z
9206427 9206427 20260114164551_26iWi AU0010 2026-01-16T14:03:51.896Z 2026-01-22T15:02:25.407Z
9206349 9206349 20260114161614_kN8wk AU0010 2026-01-16T14:03:27.898Z 2026-01-22T15:02:11.962Z
9206321 9206321 20260114154402_1Jo5H AU0010 2026-01-16T14:03:18.290Z 2026-01-22T15:02:02.893Z
9206318 9206318 20260114154401_qAEQu AU0010 2026-01-16T14:03:17.572Z 2026-01-22T15:02:02.751Z
9206294 9206294 20260114153047_IkSEk AU0010 2026-01-16T14:03:08.815Z 2026-01-22T15:01:58.533Z
9206135 9206135 20260114133535_pS33Z AU0010 2026-01-16T14:02:19.572Z 2026-01-22T15:01:50.430Z
9206128 9206128 20260114133127_HfpU0 AU0010 2026-01-16T14:02:15.286Z 2026-01-22T15:01:49.863Z
9206111 9206111 20260114131708_1vrHe AU0010 2026-01-16T14:02:08.356Z 2026-01-22T15:01:48.980Z
9206094 9206094 20260115200034_CbVt9 AU0010 2026-01-16T14:01:52.083Z 2026-01-24T15:10:33.820Z
9206092 9206092 20260115194504_hZnH6 AU0010 2026-01-16T14:01:50.991Z 2026-01-24T15:10:30.509Z
9206073 9206073 20260115161157_usSjA AU0010 2026-01-16T14:01:43.660Z 2026-01-24T15:09:26.692Z
9205697 9205697 20260113122201_hP5jY AU0010 2026-01-15T14:40:49.138Z 2026-01-21T15:06:23.744Z
9199461 9199461 20260113200332_Txeu3 AU0010 2026-01-15T14:10:59.389Z 2026-01-22T15:07:24.779Z
9199419 9199419 20260113195754_cMrNR AU0010 2026-01-15T14:10:47.080Z 2026-01-22T15:07:23.886Z
9199417 9199417 20260113195740_3tetp AU0010 2026-01-15T14:10:46.453Z 2026-01-22T15:07:23.819Z
9199414 9199414 20260113195740_oY1fM AU0010 2026-01-15T14:10:45.884Z 2026-01-22T15:07:23.759Z
9199363 9199363 20260113195101_W41ZE AU0010 2026-01-15T14:10:36.092Z 2026-01-22T15:07:22.752Z
9199218 9199218 20260113192805_OBqPa AU0010 2026-01-15T14:09:51.969Z 2026-01-22T15:07:17.175Z
9199066 9199066 20260113185843_P5qu5 AU0010 2026-01-15T14:09:06.411Z 2026-01-22T15:07:13.273Z
9199036 9199036 20260113185321_rp9y3 AU0010 2026-01-15T14:08:58.786Z 2026-01-22T15:07:12.309Z
9199032 9199032 20260113185320_CMeTl AU0010 2026-01-15T14:08:58.298Z 2026-01-22T15:07:12.242Z
9198958 9198958 20260113184143_O2m24 AU0010 2026-01-15T14:08:33.403Z 2026-01-22T15:07:10.454Z
9198783 9198783 20260113175759_3H0vq AU0010 2026-01-15T14:07:13.436Z 2026-01-22T15:07:04.224Z
9198642 9198642 20260113172650_R6c0C AU0010 2026-01-15T14:06:03.215Z 2026-01-15T14:31:30.831Z
9198576 9198576 20260113171017_vLKht AU0010 2026-01-15T14:05:37.104Z 2026-01-22T15:06:38.069Z
9198538 9198538 20260113170033_Is6jS AU0010 2026-01-15T14:05:20.673Z 2026-01-22T15:06:33.429Z
9198526 9198526 20260113165645_E3DA4 AU0010 2026-01-15T14:05:10.969Z 2026-01-22T15:06:33.091Z
9198285 9198285 20260113151850_vNb4R AU0010 2026-01-15T14:02:56.792Z 2026-01-22T15:06:21.020Z
9198226 9198226 20260113145531_CzWu7 AU0010 2026-01-15T14:02:22.705Z 2026-01-22T15:06:18.827Z
9198192 9198192 20260113142813_VqP2S AU0010 2026-01-15T14:01:55.210Z 2026-01-22T15:06:16.684Z
9198119 9198119 20260113133110_46bpw AU0010 2026-01-15T14:01:02.355Z 2026-01-22T15:06:13.434Z
9197955 9197955 20260113131709_gUYUd AU0010 2026-01-14T14:25:04.364Z 2026-01-14T14:25:08.835Z
9194265 9194265 20260112192324_14zaF AU0010 2026-01-14T14:08:20.698Z 2026-01-21T15:03:46.409Z
9194238 9194238 20260112190835_5Gbz5 AU0010 2026-01-14T14:08:14.818Z 2026-01-21T15:03:43.717Z
9194087 9194087 20260112174217_lskeC AU0010 2026-01-14T14:07:11.287Z 2026-01-21T15:03:28.437Z
9194066 9194066 20260112172122_0jPx3 AU0010 2026-01-14T14:07:02.040Z 2026-01-21T15:03:27.499Z
9194058 9194058 20260112171712_Q4qXC AU0010 2026-01-14T14:06:55.025Z 2026-01-21T15:03:24.083Z
9194009 9194009 20260112162826_DhGJV AU0010 2026-01-14T14:06:34.195Z 2026-01-21T15:03:14.315Z

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