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

4,726 rows where station_code = "NZ003B" 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
8684773 8684773 20251204141209_oqt7L NZ003B 2025-12-05T14:04:33.686Z 2025-12-06T14:18:00.596Z
8684729 8684729 20251204140025_nvTVi NZ003B 2025-12-05T14:04:28.344Z 2025-12-06T14:18:00.587Z
8684615 8684615 20251204132614_mpy5e NZ003B 2025-12-05T14:04:03.759Z 2025-12-06T14:18:00.559Z
8684587 8684587 20251204131953_IF3kC NZ003B 2025-12-05T14:03:58.809Z 2025-12-06T14:18:00.551Z
8684479 8684479 20251204125151_wH9uj NZ003B 2025-12-05T14:03:29.583Z 2025-12-06T14:18:00.523Z
8671743 8671743 20251201125452_CP1yf NZ003B 2025-12-03T14:13:36.104Z 2025-12-06T14:31:18.245Z
8660161 8660161 20251130120123_fH8RZ NZ003B 2025-12-02T14:06:46.485Z 2025-12-06T14:36:54.095Z
8660153 8660153 20251130115938_1jNZj NZ003B 2025-12-02T14:06:44.453Z 2025-12-06T14:36:53.865Z
8660138 8660138 20251130115929_kowlE NZ003B 2025-12-02T14:06:38.222Z 2025-12-06T14:36:53.665Z
8660003 8660003 20251130114018_K0Upy NZ003B 2025-12-02T14:06:11.264Z 2025-12-06T14:36:49.734Z
8659779 8659779 20251130111455_HZs0i NZ003B 2025-12-02T14:05:17.184Z 2025-12-06T14:36:41.878Z
8642041 8642041 20251128152726_61s6H NZ003B 2025-11-30T14:17:16.804Z 2025-12-06T14:53:14.427Z
8641852 8641852 20251128151652_NPk2C NZ003B 2025-11-30T14:17:04.967Z 2025-12-06T14:52:58.707Z
8641610 8641610 20251128150112_xNz4G NZ003B 2025-11-30T14:16:34.912Z 2025-12-06T14:52:40.977Z
8641582 8641582 20251128145935_OPl7b NZ003B 2025-11-30T14:16:33.415Z 2025-12-06T14:52:39.208Z
8629972 8629972 20251128145115_wxX4M NZ003B 2025-11-29T14:09:23.655Z 2025-12-06T14:52:36.370Z
8629868 8629868 20251128144212_IbPI9 NZ003B 2025-11-29T14:09:15.069Z 2025-12-06T14:52:34.968Z
8629547 8629547 20251128141805_u25Sd NZ003B 2025-11-29T14:08:36.706Z 2025-12-06T14:52:29.374Z
8629078 8629078 20251128134234_MhhCl NZ003B 2025-11-29T14:07:49.923Z 2025-12-06T14:52:21.970Z
8628951 8628951 20251128132908_NymWW NZ003B 2025-11-29T14:07:35.874Z 2025-12-06T14:52:20.780Z
8627970 8627970 20251128115759_LxDxd NZ003B 2025-11-29T14:05:01.482Z 2025-12-06T14:51:28.966Z
8595222 8595222 20251124143550_cappz NZ003B 2025-11-26T14:10:20.425Z 2025-12-02T15:05:45.357Z
8595212 8595212 20251124143330_0ARjC NZ003B 2025-11-26T14:10:19.366Z 2025-12-02T15:05:45.027Z
8595131 8595131 20251124141209_ASd3R NZ003B 2025-11-26T14:10:08.269Z 2025-12-02T15:05:41.133Z
8594972 8594972 20251124133239_3b3ck NZ003B 2025-11-26T14:09:34.372Z 2025-12-02T15:05:39.833Z
8594937 8594937 20251124132602_zmTQc NZ003B 2025-11-26T14:09:30.039Z 2025-12-02T15:05:39.625Z
8594933 8594933 20251124132226_OXRqN NZ003B 2025-11-26T14:09:28.755Z 2025-12-02T15:05:39.558Z
8593964 8593964 20251125143759_j5aiL NZ003B 2025-11-26T14:03:57.115Z 2025-12-04T15:05:29.875Z
8584808 8584808 20251123133153_Hgnz3 NZ003B 2025-11-25T14:07:43.208Z 2025-12-02T15:09:51.971Z
8584795 8584795 20251123132954_dp2F0 NZ003B 2025-11-25T14:07:35.297Z 2025-12-02T15:09:51.912Z
8584692 8584692 20251123130654_DjfVS NZ003B 2025-11-25T14:07:16.271Z 2025-12-02T15:09:51.247Z
8584649 8584649 20251123125715_Kh2Ou NZ003B 2025-11-25T14:07:10.741Z 2025-12-02T15:09:50.995Z
8584611 8584611 20251123124854_aNY8W NZ003B 2025-11-25T14:06:59.529Z 2025-12-02T15:09:50.774Z
8584543 8584543 20251123123847_Tcmkr NZ003B 2025-11-25T14:06:45.276Z 2025-12-02T15:09:50.292Z
8584393 8584393 20251123120318_3Li6J NZ003B 2025-11-25T14:06:13.845Z 2025-12-02T15:09:48.386Z
8584232 8584232 20251123112114_LM7X4 NZ003B 2025-11-25T14:05:43.290Z 2025-12-02T15:09:47.170Z
8584106 8584106 20251123105928_ZXmn1 NZ003B 2025-11-25T14:05:21.967Z 2025-12-02T15:09:46.170Z
8584029 8584029 20251123103719_yhAbA NZ003B 2025-11-25T14:05:05.710Z 2025-12-02T15:09:45.391Z
8561185 8561185 20251121114633_cZghj NZ003B 2025-11-23T14:02:00.558Z 2025-11-30T15:02:51.526Z
8561155 8561155 20251121114514_Yl3NT NZ003B 2025-11-23T14:01:57.865Z 2025-11-30T15:02:49.074Z
8543590 8543590 20251120140603_OEvoW NZ003B 2025-11-22T14:05:37.948Z 2025-11-29T14:53:26.944Z
8542787 8542787 20251120125139_rz7x0 NZ003B 2025-11-22T14:03:11.145Z 2025-11-29T14:53:14.963Z
8542539 8542539 20251120122443_sQjp7 NZ003B 2025-11-22T14:02:28.450Z 2025-11-29T14:53:12.768Z
8542419 8542419 20251120121305_1kDtR NZ003B 2025-11-22T14:02:07.690Z 2025-11-29T14:53:11.687Z
8542409 8542409 20251120121150_zb7Rl NZ003B 2025-11-22T14:02:05.663Z 2025-11-29T14:53:11.673Z
8542337 8542337 20251120115934_diK2K NZ003B 2025-11-22T14:01:49.755Z 2025-11-29T14:53:09.637Z
8542308 8542308 20251120115527_IQd0Q NZ003B 2025-11-22T14:01:46.975Z 2025-11-29T14:53:09.574Z
8542250 8542250 20251120114956_zGCly NZ003B 2025-11-22T14:01:40.033Z 2025-11-29T14:53:08.747Z
8542234 8542234 20251120114751_awN2K NZ003B 2025-11-22T14:01:36.300Z 2025-11-29T14:53:08.701Z
8542224 8542224 20251120114719_WODOn NZ003B 2025-11-22T14:01:35.331Z 2025-11-29T14:53:08.550Z
8542092 8542092 20251120112850_iRI4B NZ003B 2025-11-22T14:01:12.776Z 2025-11-29T14:53:05.400Z
8541945 8541945 20251120110134_6eQuM NZ003B 2025-11-22T14:00:45.704Z 2025-11-29T14:52:58.402Z
8541907 8541907 20251120105757_1V7Ci NZ003B 2025-11-22T14:00:41.856Z 2025-11-29T14:52:58.226Z
8541877 8541877 20251120105328_315hJ NZ003B 2025-11-22T14:00:35.877Z 2025-11-29T14:52:57.806Z
8541809 8541809 20251120104917_DLOCQ NZ003B 2025-11-22T14:00:26.806Z 2025-11-29T14:52:56.617Z
8541767 8541767 20251120104528_02uEH NZ003B 2025-11-22T14:00:21.661Z 2025-11-29T14:52:52.942Z
8502679 8502679 20251117152719_vXtFR NZ003B 2025-11-19T14:03:18.887Z 2025-11-26T15:06:13.298Z
8501591 8501591 20251116112435_9Ogfm NZ003B 2025-11-18T14:47:30.797Z 2025-11-24T15:06:43.724Z
8501427 8501427 20251116105903_UG4N7 NZ003B 2025-11-18T14:47:24.403Z 2025-11-24T15:06:32.408Z
8488842 8488842 20251116150434_LU9Va NZ003B 2025-11-18T14:07:48.406Z 2025-11-25T15:06:57.904Z
8488822 8488822 20251116150202_3zpqF NZ003B 2025-11-18T14:07:39.490Z 2025-11-25T15:06:57.786Z
8488769 8488769 20251116145956_8u3Z5 NZ003B 2025-11-18T14:07:28.247Z 2025-11-25T15:06:53.448Z
8488707 8488707 20251116145252_Q1WP8 NZ003B 2025-11-18T14:07:19.973Z 2025-11-25T15:06:52.824Z
8488678 8488678 20251116145125_IxnQ3 NZ003B 2025-11-18T14:07:16.625Z 2025-11-25T15:06:52.702Z
8488622 8488622 20251116144432_m8Ig1 NZ003B 2025-11-18T14:07:10.380Z 2025-11-25T15:06:51.821Z
8488446 8488446 20251116142614_8iI3s NZ003B 2025-11-18T14:06:32.362Z 2025-11-25T15:06:47.821Z
8488337 8488337 20251116141757_19G9k NZ003B 2025-11-18T14:06:10.201Z 2025-11-25T15:06:46.432Z
8488241 8488241 20251116140856_k9ZwL NZ003B 2025-11-18T14:05:55.802Z 2025-11-25T15:06:42.936Z
8488207 8488207 20251116140601_jSpod NZ003B 2025-11-18T14:05:43.183Z 2025-11-25T15:06:42.373Z
8488043 8488043 20251116135402_g2igG NZ003B 2025-11-18T14:05:19.120Z 2025-11-25T15:06:36.095Z
8487977 8487977 20251116134902_QcKYt NZ003B 2025-11-18T14:05:03.897Z 2025-11-25T15:06:33.091Z
8487918 8487918 20251116134308_42WWJ NZ003B 2025-11-18T14:04:50.315Z 2025-11-25T15:06:32.085Z
8487822 8487822 20251116133211_e9Prl NZ003B 2025-11-18T14:04:37.808Z 2025-11-25T15:06:29.394Z
8487755 8487755 20251116132714_K0rNE NZ003B 2025-11-18T14:04:15.844Z 2025-11-25T15:06:25.703Z
8487617 8487617 20251116131012_t73WX NZ003B 2025-11-18T14:03:52.626Z 2025-11-25T15:06:18.157Z
8487582 8487582 20251116130724_on0Q8 NZ003B 2025-11-18T14:03:43.676Z 2025-11-25T15:06:17.612Z
8487461 8487461 20251116125302_S2AMi NZ003B 2025-11-18T14:03:24.354Z 2025-11-25T15:06:14.158Z
8486957 8486957 20251116115622_moeNE NZ003B 2025-11-18T14:01:27.306Z 2025-11-25T15:06:01.675Z
8486895 8486895 20251116115007_2jbVC NZ003B 2025-11-18T14:01:09.890Z 2025-11-25T15:06:01.238Z
8486864 8486864 20251116114502_RzMEu NZ003B 2025-11-18T14:00:59.639Z 2025-11-25T15:06:00.988Z
8486439 8486439 20251115113257_KsuKA NZ003B 2025-11-17T14:34:24.046Z 2025-11-23T15:20:34.309Z
8485990 8485990 20251115111341_YgYUG NZ003B 2025-11-17T14:34:08.881Z 2025-11-23T15:20:18.243Z
8477608 8477608 20251115154328_gO6g3 NZ003B 2025-11-17T14:11:28.738Z 2025-11-24T15:03:45.070Z
8477168 8477168 20251115151905_koAPg NZ003B 2025-11-17T14:10:36.258Z 2025-11-24T15:03:27.470Z
8476479 8476479 20251115144735_HAGdA NZ003B 2025-11-17T14:08:53.488Z 2025-11-24T15:03:11.614Z
8476432 8476432 20251115144616_E2QSg NZ003B 2025-11-17T14:08:48.755Z 2025-11-24T15:03:11.239Z
8474966 8474966 20251115133237_UqscQ NZ003B 2025-11-17T14:05:47.699Z 2025-11-24T15:02:59.518Z
8474788 8474788 20251115132511_NBckt NZ003B 2025-11-17T14:05:22.176Z 2025-11-24T15:02:58.498Z
8474763 8474763 20251115132219_mM2sc NZ003B 2025-11-17T14:05:19.783Z 2025-11-24T15:02:58.115Z
8474667 8474667 20251115131755_MgpdV NZ003B 2025-11-17T14:05:12.085Z 2025-11-24T15:02:57.717Z
8473639 8473639 20251115122207_92QmI NZ003B 2025-11-17T14:02:41.889Z 2025-11-24T15:02:44.257Z
8472764 8472764 20251115114115_6oosI NZ003B 2025-11-17T14:00:22.321Z 2025-11-24T15:02:15.770Z
8443402 8443402 20251111120155_okKls NZ003B 2025-11-13T14:50:47.974Z 2025-11-19T15:19:17.950Z
8442992 8442992 20251111105233_iCmO0 NZ003B 2025-11-13T14:49:51.832Z 2025-11-19T15:18:53.724Z
8430709 8430709 20251111125804_WgEuY NZ003B 2025-11-13T14:02:09.838Z 2025-11-20T15:19:37.683Z
8430465 8430465 20251111123559_pgzQU NZ003B 2025-11-13T14:01:21.817Z 2025-11-20T15:19:32.156Z
8430438 8430438 20251111123223_JYSni NZ003B 2025-11-13T14:01:16.494Z 2025-11-20T15:19:31.295Z
8430422 8430422 20251111123002_eSUpt NZ003B 2025-11-13T14:01:11.332Z 2025-11-20T15:19:30.947Z
8430318 8430318 20251111121938_94Vdg NZ003B 2025-11-13T14:00:46.010Z 2025-11-20T15:19:25.653Z
8430265 8430265 20251111121504_61kxr NZ003B 2025-11-13T14:00:35.027Z 2025-11-20T15:19:22.973Z

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