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

6,761 rows where station_code = "NZ004E" 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
8677947 8677947 20251203133339_WU4tC NZ004E 2025-12-04T14:03:04.617Z 2025-12-05T14:14:35.019Z
8677906 8677906 20251203130935_LiUwT NZ004E 2025-12-04T14:02:58.416Z 2025-12-05T14:14:35.003Z
8677820 8677820 20251203124112_ZPzPh NZ004E 2025-12-04T14:02:43.547Z 2025-12-05T14:14:34.980Z
8677767 8677767 20251203122553_olTVt NZ004E 2025-12-04T14:02:29.994Z 2025-12-05T14:14:34.957Z
8677759 8677759 20251203122241_zhs11 NZ004E 2025-12-04T14:02:28.830Z 2025-12-05T14:14:34.952Z
8628165 8628165 20251128122443_V7Acx NZ004E 2025-11-29T14:05:38.122Z 2025-11-29T14:05:38.122Z
8627443 8627443 20251128105929_E7rh4 NZ004E 2025-11-29T14:03:33.104Z 2025-12-05T14:46:59.470Z
8627263 8627263 20251128104056_zYSa2 NZ004E 2025-11-29T14:03:08.839Z 2025-12-05T14:46:56.424Z
8627223 8627223 20251128103942_9xmCU NZ004E 2025-11-29T14:03:06.273Z 2025-12-05T14:46:56.047Z
8627068 8627068 20251128101645_VSP6e NZ004E 2025-11-29T14:02:30.249Z 2025-12-05T14:46:44.702Z
8627032 8627032 20251128101425_y0rLk NZ004E 2025-11-29T14:02:21.468Z 2025-12-05T14:46:34.878Z
8621454 8621454 20251126151352_ikSLS NZ004E 2025-11-28T14:15:44.452Z 2025-12-05T15:02:44.416Z
8621355 8621355 20251126150007_OcNKu NZ004E 2025-11-28T14:15:32.639Z 2025-12-05T15:02:43.479Z
8620118 8620118 20251126114913_79H3o NZ004E 2025-11-28T14:11:40.871Z 2025-12-05T15:01:28.922Z
8619996 8619996 20251126113136_Q8CFC NZ004E 2025-11-28T14:11:22.097Z 2025-12-05T15:01:23.800Z
8619607 8619607 20251126103424_RxKtR NZ004E 2025-11-28T14:09:43.357Z 2025-12-05T15:01:02.900Z
8619524 8619524 20251126102353_PFnr2 NZ004E 2025-11-28T14:09:18.247Z 2025-12-05T15:01:00.937Z
8619319 8619319 20251126094851_fmC33 NZ004E 2025-11-28T14:08:20.800Z 2025-12-05T15:00:56.082Z
8617888 8617888 20251127104544_1ZlLz NZ004E 2025-11-28T14:02:43.545Z 2025-12-05T14:54:06.052Z
8617681 8617681 20251127101457_bd3Tf NZ004E 2025-11-28T14:01:56.443Z 2025-12-05T14:54:02.909Z
8561815 8561815 20251121130525_PRzg3 NZ004E 2025-11-23T14:03:48.415Z 2025-11-30T15:03:12.852Z
8561645 8561645 20251121123900_aF1fA NZ004E 2025-11-23T14:03:15.524Z 2025-11-30T15:03:04.418Z
8561265 8561265 20251121115630_sBxpP NZ004E 2025-11-23T14:02:13.973Z 2025-11-30T15:02:52.609Z
8560890 8560890 20251121111524_lmiR2 NZ004E 2025-11-23T14:01:14.880Z 2025-11-30T15:02:40.796Z
8560730 8560730 20251121105016_m6N79 NZ004E 2025-11-23T14:00:46.585Z 2025-11-30T15:02:37.144Z
8554656 8554656 20251120102848_AjeJB NZ004E 2025-11-22T14:35:39.755Z 2025-11-28T14:58:55.190Z
8554417 8554417 20251120094208_V6Ihl NZ004E 2025-11-22T14:35:26.342Z 2025-11-28T14:58:50.731Z
8554413 8554413 20251120094207_F5vlM NZ004E 2025-11-22T14:35:26.123Z 2025-11-28T14:58:50.727Z
8554400 8554400 20251120093935_fjcdl NZ004E 2025-11-22T14:35:23.151Z 2025-11-28T14:58:50.469Z
8544633 8544633 20251120152513_3XsTa NZ004E 2025-11-22T14:08:31.612Z 2025-11-29T14:53:49.176Z
8543982 8543982 20251120143902_cdq2F NZ004E 2025-11-22T14:06:42.536Z 2025-11-29T14:53:35.788Z
8543783 8543783 20251120142555_WSiW6 NZ004E 2025-11-22T14:06:09.396Z 2025-11-29T14:53:29.479Z
8543780 8543780 20251120142336_y8GXB NZ004E 2025-11-22T14:06:08.982Z 2025-11-29T14:53:29.461Z
8543657 8543657 20251120141118_1m3NW NZ004E 2025-11-22T14:05:46.902Z 2025-11-29T14:53:27.953Z
8543561 8543561 20251120140315_MmQxK NZ004E 2025-11-22T14:05:30.491Z 2025-11-29T14:53:26.900Z
8542709 8542709 20251120124252_Ukq4i NZ004E 2025-11-22T14:02:56.192Z 2025-11-29T14:53:14.594Z
8542503 8542503 20251120122130_02QyC NZ004E 2025-11-22T14:02:21.195Z 2025-11-29T14:53:12.561Z
8542455 8542455 20251120121612_Z0yQy NZ004E 2025-11-22T14:02:14.849Z 2025-11-29T14:53:12.132Z
8541783 8541783 20251120104826_Lg2Xi NZ004E 2025-11-22T14:00:23.500Z 2025-11-29T14:52:53.474Z
8501380 8501380 20251116105220_RDqJM NZ004E 2025-11-18T14:47:22.000Z 2025-11-24T15:06:30.179Z
8500959 8500959 20251116100758_ThGM0 NZ004E 2025-11-18T14:46:44.899Z 2025-11-24T15:06:05.271Z
8500687 8500687 20251116093335_7goni NZ004E 2025-11-18T14:46:28.644Z 2025-11-24T15:05:55.287Z
8500559 8500559 20251116091300_7DPir NZ004E 2025-11-18T14:46:23.531Z 2025-11-24T15:05:49.062Z
8489067 8489067 20251116152739_AZPwx NZ004E 2025-11-18T14:08:37.196Z 2025-11-25T15:07:06.476Z
8489053 8489053 20251116152631_7Jts3 NZ004E 2025-11-18T14:08:34.324Z 2025-11-25T15:07:05.132Z
8489047 8489047 20251116152548_jFM2a NZ004E 2025-11-18T14:08:32.927Z 2025-11-25T15:07:05.020Z
8489034 8489034 20251116152440_TC5rz NZ004E 2025-11-18T14:08:30.166Z 2025-11-25T15:07:04.774Z
8488988 8488988 20251116151826_pGTmV NZ004E 2025-11-18T14:08:15.628Z 2025-11-25T15:07:02.558Z
8488909 8488909 20251116150904_cQlDg NZ004E 2025-11-18T14:07:59.226Z 2025-11-25T15:06:59.441Z
8488813 8488813 20251116150157_vZgvT NZ004E 2025-11-18T14:07:38.458Z 2025-11-25T15:06:57.290Z
8488387 8488387 20251116142053_alA3X NZ004E 2025-11-18T14:06:17.158Z 2025-11-25T15:06:47.229Z
8488362 8488362 20251116141905_c1Y31 NZ004E 2025-11-18T14:06:12.924Z 2025-11-25T15:06:46.926Z
8488317 8488317 20251116141559_USGjJ NZ004E 2025-11-18T14:06:07.119Z 2025-11-25T15:06:45.978Z
8488271 8488271 20251116141101_AkRIB NZ004E 2025-11-18T14:06:00.304Z 2025-11-25T15:06:43.068Z
8488004 8488004 20251116135140_jafR5 NZ004E 2025-11-18T14:05:13.033Z 2025-11-25T15:06:34.792Z
8487897 8487897 20251116134030_FNL3k NZ004E 2025-11-18T14:04:47.341Z 2025-11-25T15:06:31.916Z
8487884 8487884 20251116133914_IT473 NZ004E 2025-11-18T14:04:45.203Z 2025-11-25T15:06:31.283Z
8487760 8487760 20251116132721_2mIYW NZ004E 2025-11-18T14:04:16.457Z 2025-11-25T15:06:25.707Z
8487742 8487742 20251116132654_Ow2nU NZ004E 2025-11-18T14:04:14.099Z 2025-11-25T15:06:25.578Z
8487668 8487668 20251116131657_LEkZ5 NZ004E 2025-11-18T14:04:04.903Z 2025-11-25T15:06:24.489Z
8487493 8487493 20251116125634_2isBZ NZ004E 2025-11-18T14:03:29.975Z 2025-11-25T15:06:15.288Z
8487456 8487456 20251116125053_aF3zr NZ004E 2025-11-18T14:03:23.633Z 2025-11-25T15:06:13.842Z
8487338 8487338 20251116124249_vbrj2 NZ004E 2025-11-18T14:02:58.204Z 2025-11-25T15:06:12.401Z
8487182 8487182 20251116122844_01mUA NZ004E 2025-11-18T14:02:23.217Z 2025-11-25T15:06:08.092Z
8487168 8487168 20251116122657_pqnfm NZ004E 2025-11-18T14:02:17.736Z 2025-11-25T15:06:07.558Z
8487136 8487136 20251116122220_sa3Vm NZ004E 2025-11-18T14:02:09.199Z 2025-11-25T15:06:06.191Z
8486470 8486470 20251115113532_hsx3M NZ004E 2025-11-17T14:34:26.863Z 2025-11-23T15:20:35.723Z
8486313 8486313 20251115112614_Shz5f NZ004E 2025-11-17T14:34:16.476Z 2025-11-23T15:20:29.264Z
8486254 8486254 20251115112336_3PjrR NZ004E 2025-11-17T14:34:15.536Z 2025-11-23T15:20:27.835Z
8485168 8485168 20251115102834_QJoGF NZ004E 2025-11-17T14:33:32.648Z 2025-11-23T15:19:56.784Z
8485003 8485003 20251115102011_SBQM7 NZ004E 2025-11-17T14:33:05.087Z 2025-11-23T15:19:53.131Z
8484551 8484551 20251115095033_gUr5Y NZ004E 2025-11-17T14:32:51.039Z 2025-11-23T15:19:39.645Z
8484456 8484456 20251115094410_untDq NZ004E 2025-11-17T14:32:47.463Z 2025-11-23T15:19:37.087Z
8484039 8484039 20251115091728_u4Alf NZ004E 2025-11-17T14:32:09.799Z 2025-11-23T15:19:24.073Z
8477261 8477261 20251115152312_aSX23 NZ004E 2025-11-17T14:10:44.298Z 2025-11-24T15:03:31.956Z
8476937 8476937 20251115150822_i5h9k NZ004E 2025-11-17T14:10:04.045Z 2025-11-24T15:03:19.553Z
8476752 8476752 20251115145856_Y360b NZ004E 2025-11-17T14:09:35.900Z 2025-11-24T15:03:13.443Z
8476605 8476605 20251115145357_QNfVa NZ004E 2025-11-17T14:09:22.192Z 2025-11-24T15:03:12.696Z
8476573 8476573 20251115145306_QTxJZ NZ004E 2025-11-17T14:09:19.661Z 2025-11-24T15:03:12.546Z
8476467 8476467 20251115144644_QN8be NZ004E 2025-11-17T14:08:50.589Z 2025-11-24T15:03:11.469Z
8476408 8476408 20251115144549_R0tfF NZ004E 2025-11-17T14:08:47.615Z 2025-11-24T15:03:11.047Z
8475829 8475829 20251115141553_9wLRC NZ004E 2025-11-17T14:07:28.825Z 2025-11-24T15:03:05.145Z
8475673 8475673 20251115140740_daGzm NZ004E 2025-11-17T14:07:11.768Z 2025-11-24T15:03:04.014Z
8475284 8475284 20251115134710_nZTzY NZ004E 2025-11-17T14:06:24.947Z 2025-11-24T15:03:01.409Z
8473794 8473794 20251115123038_l0R98 NZ004E 2025-11-17T14:02:57.405Z 2025-11-24T15:02:50.821Z
8473774 8473774 20251115122856_nhANT NZ004E 2025-11-17T14:02:54.827Z 2025-11-24T15:02:48.391Z
8473451 8473451 20251115121447_pEpl0 NZ004E 2025-11-17T14:02:09.082Z 2025-11-24T15:02:38.055Z
8473376 8473376 20251115121008_b5ehz NZ004E 2025-11-17T14:01:51.481Z 2025-11-24T15:02:36.064Z
8473164 8473164 20251115115946_y72Vx NZ004E 2025-11-17T14:01:19.206Z 2025-11-24T15:02:31.268Z
8473021 8473021 20251115115335_6Fj1R NZ004E 2025-11-17T14:00:54.554Z 2025-11-24T15:02:27.385Z
8472980 8472980 20251115115151_7x9xf NZ004E 2025-11-17T14:00:47.979Z 2025-11-24T15:02:26.208Z
8444144 8444144 20251113150024_iT99A NZ004E 2025-11-14T14:02:33.788Z 2025-11-22T15:19:12.366Z
8443996 8443996 20251113142653_4a3CU NZ004E 2025-11-14T14:01:59.059Z 2025-11-14T14:01:59.059Z
8443329 8443329 20251111114957_260qh NZ004E 2025-11-13T14:50:44.702Z 2025-11-19T15:19:12.902Z
8443157 8443157 20251111112745_sso8L NZ004E 2025-11-13T14:50:37.916Z 2025-11-19T15:19:05.093Z
8443154 8443154 20251111112735_ftZGa NZ004E 2025-11-13T14:50:37.492Z 2025-11-19T15:19:05.018Z
8430563 8430563 20251111124341_8k29A NZ004E 2025-11-13T14:01:43.576Z 2025-11-20T15:19:34.933Z
8430477 8430477 20251111123652_cRTSb NZ004E 2025-11-13T14:01:24.984Z 2025-11-20T15:19:32.359Z
8430384 8430384 20251111122732_gMn9c NZ004E 2025-11-13T14:01:00.709Z 2025-11-20T15:19:30.136Z
8400804 8400804 20251107092449_XeBhW NZ004E 2025-11-09T14:28:59.514Z 2025-11-15T15:00:54.047Z

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