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

350 rows where station_code = "US002Z" 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
8800240 8800240 20251213055829_BQPiQ US002Z 2025-12-16T14:12:33.006Z 2025-12-16T14:21:14.303Z
8800181 8800181 20251213055746_T8CXK US002Z 2025-12-16T14:12:30.378Z 2025-12-16T14:21:14.288Z
8745987 8745987 20251211022839_7VG6B US002Z 2025-12-13T15:28:26.510Z 2025-12-15T15:06:45.041Z
8738531 8738531 20251212025836_Yeeuy US002Z 2025-12-13T15:03:02.004Z 2025-12-16T14:55:11.629Z
8727192 8727192 20251212063017_49nz3 US002Z 2025-12-13T14:07:03.945Z 2025-12-16T14:24:30.187Z
8727103 8727103 20251212062003_7Nh5P US002Z 2025-12-13T14:06:45.510Z 2025-12-16T14:24:26.068Z
8726326 8726326 20251212043606_4xwAD US002Z 2025-12-13T14:02:44.488Z 2025-12-16T14:22:57.148Z
8724529 8724529 20251211111258_HIKqd US002Z 2025-12-12T14:15:28.225Z 2025-12-16T14:47:30.202Z
8724480 8724480 20251211110736_tDc5K US002Z 2025-12-12T14:15:22.549Z 2025-12-16T14:47:28.599Z
8724306 8724306 20251211105735_Q6e3A US002Z 2025-12-12T14:14:48.851Z 2025-12-12T14:14:48.851Z
8724300 8724300 20251211105704_qtB22 US002Z 2025-12-12T14:14:48.109Z 2025-12-16T14:47:19.670Z
8724279 8724279 20251211105525_3eop2 US002Z 2025-12-12T14:14:45.838Z 2025-12-16T14:47:09.747Z
8723635 8723635 20251211100152_0bE6b US002Z 2025-12-12T14:12:51.691Z 2025-12-16T14:46:49.313Z
8722428 8722428 20251211080636_hlSo5 US002Z 2025-12-12T14:09:22.548Z 2025-12-16T14:46:02.999Z
8722296 8722296 20251211074821_9C6pn US002Z 2025-12-12T14:08:59.557Z 2025-12-16T14:45:42.970Z
8722003 8722003 20251211071611_LJiQF US002Z 2025-12-12T14:07:55.811Z 2025-12-16T14:45:30.099Z
8721304 8721304 20251211061436_Z8WQJ US002Z 2025-12-12T14:05:46.784Z 2025-12-16T14:45:16.020Z
8718175 8718175 20251210120915_3NvQu US002Z 2025-12-11T14:16:25.257Z 2025-12-15T15:00:10.329Z
8717294 8717294 20251210110346_uQr35 US002Z 2025-12-11T14:13:26.653Z 2025-12-15T14:59:25.896Z
8716945 8716945 20251210103835_Vh3p3 US002Z 2025-12-11T14:12:23.198Z 2025-12-15T14:59:00.766Z
8716943 8716943 20251210103821_ZX13x US002Z 2025-12-11T14:12:22.713Z 2025-12-15T14:59:00.659Z
8716708 8716708 20251210101639_y1JZg US002Z 2025-12-11T14:11:45.238Z 2025-12-15T14:58:55.060Z
8716215 8716215 20251210092155_VhAbf US002Z 2025-12-11T14:09:58.930Z 2025-12-15T14:58:38.886Z
8715746 8715746 20251210075625_tVbE9 US002Z 2025-12-11T14:08:05.968Z 2025-12-15T14:58:01.619Z
8715735 8715735 20251210075233_WfMTU US002Z 2025-12-11T14:08:00.906Z 2025-12-15T14:58:01.113Z
8715296 8715296 20251210063728_6DZ0o US002Z 2025-12-11T14:06:15.443Z 2025-12-15T14:57:47.708Z
8714321 8714321 20251210050803_ijzuk US002Z 2025-12-11T14:02:17.821Z 2025-12-15T14:56:40.291Z
8714057 8714057 20251210044704_x5IXJ US002Z 2025-12-11T14:01:13.025Z 2025-12-15T14:56:31.767Z
8712601 8712601 20251209002345_0kAma US002Z 2025-12-10T14:14:26.108Z 2025-12-16T15:08:21.464Z
8710162 8710162 20251209100833_xaHTR US002Z 2025-12-10T14:04:13.226Z 2025-12-16T14:56:59.868Z
8710085 8710085 20251209095030_3jnZB US002Z 2025-12-10T14:04:02.303Z 2025-12-16T14:56:55.932Z
8709833 8709833 20251209090852_FkcOq US002Z 2025-12-10T14:03:25.941Z 2025-12-16T14:56:20.589Z
8709236 8709236 20251209070716_pHqXK US002Z 2025-12-10T14:01:52.349Z 2025-12-16T14:56:02.582Z
8708786 8708786 20251209053549_I3Fmi US002Z 2025-12-10T14:00:49.023Z 2025-12-16T14:55:39.132Z
8708695 8708695 20251209051142_Ylvsn US002Z 2025-12-10T14:00:29.460Z 2025-12-16T14:55:26.612Z
8624400 8624400 20251127043428_rIvxi US002Z 2025-11-28T14:24:36.597Z 2025-12-05T15:05:04.142Z
8617308 8617308 20251127085941_vM8Xd US002Z 2025-11-28T14:00:21.974Z 2025-12-06T14:57:51.431Z
8613400 8613400 20251126031638_SqrdB US002Z 2025-11-27T14:25:47.005Z 2025-12-04T15:09:40.178Z
8339844 8339844 20251031105459_Xc5rd US002Z 2025-11-02T14:34:29.814Z 2025-11-08T15:17:48.600Z
8339599 8339599 20251031104145_nLZgJ US002Z 2025-11-02T14:34:21.100Z 2025-11-08T15:17:43.053Z
8339540 8339540 20251031103535_V3ttq US002Z 2025-11-02T14:34:18.558Z 2025-11-08T15:17:40.584Z
8339539 8339539 20251031103533_rX32s US002Z 2025-11-02T14:34:18.510Z 2025-11-08T15:17:40.520Z
8339404 8339404 20251031102247_G1D2h US002Z 2025-11-02T14:34:13.984Z 2025-11-08T15:17:37.339Z
8339364 8339364 20251031102050_0CPXg US002Z 2025-11-02T14:34:12.006Z 2025-11-08T15:17:35.050Z
8339089 8339089 20251031095701_W8xd6 US002Z 2025-11-02T14:33:27.582Z 2025-11-08T15:17:27.705Z
8339037 8339037 20251031095029_wMr3K US002Z 2025-11-02T14:33:25.711Z 2025-11-08T15:17:25.527Z
8338958 8338958 20251031094316_zFTdZ US002Z 2025-11-02T14:33:22.382Z 2025-11-08T15:17:23.646Z
8338050 8338050 20251031080131_1ulGW US002Z 2025-11-02T14:31:42.937Z 2025-11-08T15:16:31.718Z
8337801 8337801 20251031073412_LOQvB US002Z 2025-11-02T14:31:31.899Z 2025-11-08T15:16:29.088Z
8337280 8337280 20251031062032_x3eif US002Z 2025-11-02T14:30:50.551Z 2025-11-08T15:16:21.061Z
8337265 8337265 20251031061848_OoiBD US002Z 2025-11-02T14:30:49.652Z 2025-11-08T15:16:20.917Z
8336868 8336868 20251031052547_atVEi US002Z 2025-11-02T14:30:16.318Z 2025-11-08T15:16:16.369Z
8336730 8336730 20251031051104_pL0fm US002Z 2025-11-02T14:29:55.866Z 2025-11-08T15:16:13.762Z
8334345 8334345 20251031014522_2voLU US002Z 2025-11-02T14:25:07.533Z 2025-11-08T15:13:24.274Z
8327196 8327196 20251030105040_WkbAs US002Z 2025-11-01T12:37:00.957Z 2025-11-07T15:18:49.603Z
8326266 8326266 20251030092433_RPiYH US002Z 2025-11-01T12:35:24.175Z 2025-11-07T15:17:48.364Z
8325650 8325650 20251030081130_VpjGQ US002Z 2025-11-01T12:34:19.890Z 2025-11-07T15:17:27.613Z
8325566 8325566 20251030080415_jtlnj US002Z 2025-11-01T12:34:15.268Z 2025-11-07T15:17:25.947Z
8323651 8323651 20251030050411_C5LKa US002Z 2025-11-01T12:31:21.744Z 2025-11-07T15:16:17.792Z
8322967 8322967 20251030043349_YP1V9 US002Z 2025-11-01T12:30:17.218Z 2025-11-07T15:15:51.273Z
8308420 8308420 20251029110214_f554S US002Z 2025-10-31T12:29:28.813Z 2025-11-06T15:16:04.130Z
8308241 8308241 20251029104327_h5ZUj US002Z 2025-10-31T12:29:15.860Z 2025-11-06T15:15:59.105Z
8307882 8307882 20251029101808_Va6ir US002Z 2025-10-31T12:28:33.797Z 2025-11-06T15:15:49.798Z
8306973 8306973 20251029085838_VCx43 US002Z 2025-10-31T12:26:31.932Z 2025-11-06T15:15:20.921Z
8306426 8306426 20251029080257_2TL95 US002Z 2025-10-31T12:25:06.232Z 2025-11-06T15:15:07.042Z
8306424 8306424 20251029080254_deuf8 US002Z 2025-10-31T12:25:06.123Z 2025-11-06T15:15:05.694Z
8306366 8306366 20251029075759_pdNDV US002Z 2025-10-31T12:25:02.180Z 2025-11-06T15:15:04.253Z
8306363 8306363 20251029075751_Jdvpu US002Z 2025-10-31T12:25:02.075Z 2025-11-06T15:15:04.238Z
8306334 8306334 20251029075403_LuJMf US002Z 2025-10-31T12:24:59.896Z 2025-11-06T15:15:03.551Z
8305925 8305925 20251029065817_JfrLB US002Z 2025-10-31T12:23:55.093Z 2025-11-06T15:14:53.848Z
8305865 8305865 20251029065014_G2JXx US002Z 2025-10-31T12:23:50.264Z 2025-11-06T15:14:52.559Z
8305833 8305833 20251029064404_pR33y US002Z 2025-10-31T12:23:46.563Z 2025-11-06T15:14:49.944Z
8305590 8305590 20251029055621_FPG7m US002Z 2025-10-31T12:22:56.143Z 2025-11-06T15:14:43.589Z
8294234 8294234 20251028102245_ii6pG US002Z 2025-10-30T12:40:55.066Z 2025-11-05T15:24:22.006Z
8293699 8293699 20251028095232_CFR72 US002Z 2025-10-30T12:39:46.298Z 2025-11-05T15:24:04.269Z
8282504 8282504 20251028022825_UfZez US002Z 2025-10-29T12:43:13.420Z 2025-11-05T15:21:43.919Z
8277226 8277226 20251027100747_BkNFo US002Z 2025-10-29T12:31:26.362Z 2025-11-04T15:47:38.628Z
8276702 8276702 20251027091424_nAYZ0 US002Z 2025-10-29T12:30:15.821Z 2025-11-04T15:47:03.907Z
8276328 8276328 20251027083440_BRokU US002Z 2025-10-29T12:29:50.430Z 2025-11-04T15:46:54.204Z
8276264 8276264 20251027082701_bExwa US002Z 2025-10-29T12:29:29.642Z 2025-11-04T15:46:52.599Z
8275665 8275665 20251027071810_Kzuzx US002Z 2025-10-29T12:28:16.945Z 2025-11-04T15:46:10.704Z
8274699 8274699 20251027052508_t7ckb US002Z 2025-10-29T12:26:11.290Z 2025-11-04T15:45:34.708Z
8203210 8203210 20251023083622_kSLxW US002Z 2025-10-25T12:23:53.132Z 2025-10-25T12:23:53.132Z
8202600 8202600 20251023070434_tW84M US002Z 2025-10-25T12:21:45.569Z 2025-10-31T13:08:55.895Z
8202444 8202444 20251023063753_au2tb US002Z 2025-10-25T12:21:17.351Z 2025-10-31T13:08:55.276Z
8200908 8200908 20251023020930_XKZy2 US002Z 2025-10-25T12:14:39.070Z 2025-10-31T13:08:37.783Z
8194711 8194711 20251022054401_C2HO6 US002Z 2025-10-24T12:30:14.202Z 2025-10-30T13:13:34.897Z
8193867 8193867 20251022043644_YOA3Z US002Z 2025-10-24T12:28:54.174Z 2025-10-30T13:13:31.050Z
8173272 8173272 20251020110034_NOF1l US002Z 2025-10-22T12:43:19.353Z 2025-10-28T13:09:32.975Z
8173257 8173257 20251020105959_85icS US002Z 2025-10-22T12:43:17.418Z 2025-10-28T13:09:32.942Z
8173131 8173131 20251020104915_VcNs5 US002Z 2025-10-22T12:43:12.071Z 2025-10-28T13:09:32.615Z
8173126 8173126 20251020104851_Elh28 US002Z 2025-10-22T12:43:11.627Z 2025-10-28T13:09:32.545Z
8172386 8172386 20251020100223_jbMe2 US002Z 2025-10-22T12:42:18.726Z 2025-10-28T13:09:25.586Z
8172117 8172117 20251020094846_T0Z6b US002Z 2025-10-22T12:42:10.963Z 2025-10-28T13:09:23.537Z
8172060 8172060 20251020094416_lbo1b US002Z 2025-10-22T12:42:09.251Z 2025-10-28T13:09:22.351Z
8171954 8171954 20251020093846_wGX3o US002Z 2025-10-22T12:41:59.566Z 2025-10-28T13:09:19.538Z
8171514 8171514 20251020091011_N5Vlj US002Z 2025-10-22T12:40:54.263Z 2025-10-28T13:09:16.538Z
8171372 8171372 20251020085757_x6Nzj US002Z 2025-10-22T12:40:47.751Z 2025-10-28T13:09:14.918Z
8169592 8169592 20251020063106_16wl6 US002Z 2025-10-22T12:38:27.380Z 2025-10-28T13:09:02.093Z
8150678 8150678 20251019111441_PwrHy US002Z 2025-10-20T12:30:59.069Z 2025-10-27T13:11:28.004Z

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