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 = "NZ003Z" 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
8678003 8678003 20251203135931_Yc9Z5 NZ003Z 2025-12-04T14:03:11.052Z 2025-12-06T14:20:23.369Z
8677926 8677926 20251203131640_8BHe4 NZ003Z 2025-12-04T14:02:59.983Z 2025-12-06T14:20:18.588Z
8677888 8677888 20251203125943_GKZkA NZ003Z 2025-12-04T14:02:53.185Z 2025-12-06T14:20:11.774Z
8677873 8677873 20251203124935_VQHYB NZ003Z 2025-12-04T14:02:50.615Z 2025-12-06T14:20:10.690Z
8677859 8677859 20251203124752_303rF NZ003Z 2025-12-04T14:02:48.692Z 2025-12-06T14:20:08.591Z
8677814 8677814 20251203123839_fJyk1 NZ003Z 2025-12-04T14:02:43.071Z 2025-12-06T14:20:07.072Z
8677747 8677747 20251203121547_M2OVy NZ003Z 2025-12-04T14:02:27.140Z 2025-12-06T14:20:01.337Z
8677733 8677733 20251203120255_EAkyM NZ003Z 2025-12-04T14:02:24.669Z 2025-12-06T14:20:00.095Z
8677728 8677728 20251203120254_2yKq7 NZ003Z 2025-12-04T14:02:24.306Z 2025-12-06T14:19:59.910Z
8677707 8677707 20251203115306_SLMLt NZ003Z 2025-12-04T14:02:20.550Z 2025-12-06T14:19:58.495Z
8677693 8677693 20251203115012_uTYXH NZ003Z 2025-12-04T14:02:18.430Z 2025-12-06T14:19:57.782Z
8677684 8677684 20251203114735_UhGnJ NZ003Z 2025-12-04T14:02:17.727Z 2025-12-06T14:19:57.319Z
8677679 8677679 20251203114311_Bp2A6 NZ003Z 2025-12-04T14:02:17.283Z 2025-12-06T14:19:56.907Z
8677665 8677665 20251203113557_8pRVp NZ003Z 2025-12-04T14:02:15.231Z 2025-12-06T14:19:55.478Z
8677650 8677650 20251203112932_uXusL NZ003Z 2025-12-04T14:02:09.639Z 2025-12-06T14:19:54.065Z
8672736 8672736 20251201151149_pEW0w NZ003Z 2025-12-03T14:16:20.973Z 2025-12-06T14:32:13.886Z
8672692 8672692 20251201150851_qhU0U NZ003Z 2025-12-03T14:16:10.478Z 2025-12-06T14:32:07.603Z
8668956 8668956 20251202094029_wVwKE NZ003Z 2025-12-03T14:01:44.051Z 2025-12-06T14:23:23.114Z
8642152 8642152 20251128153520_Gs4Lb NZ003Z 2025-11-30T14:17:37.312Z 2025-12-06T14:53:20.772Z
8642105 8642105 20251128153215_gJhuy NZ003Z 2025-11-30T14:17:24.040Z 2025-12-06T14:53:18.189Z
8642059 8642059 20251128152827_1O9zG NZ003Z 2025-11-30T14:17:18.060Z 2025-12-06T14:53:14.998Z
8641979 8641979 20251128152223_Tm6w0 NZ003Z 2025-11-30T14:17:12.423Z 2025-12-06T14:53:09.494Z
8641960 8641960 20251128152149_3Fvl3 NZ003Z 2025-11-30T14:17:11.520Z 2025-12-06T14:53:09.235Z
8641863 8641863 20251128151720_KQdxT NZ003Z 2025-11-30T14:17:05.384Z 2025-12-06T14:52:59.215Z
8641768 8641768 20251128151234_3GxTL NZ003Z 2025-11-30T14:16:58.850Z 2025-12-06T14:52:49.635Z
8629071 8629071 20251128134158_EzMYi NZ003Z 2025-11-29T14:07:46.774Z 2025-12-06T14:52:21.879Z
8628789 8628789 20251128131047_n2ieo NZ003Z 2025-11-29T14:07:07.855Z 2025-12-06T14:52:18.051Z
8628780 8628780 20251128131017_kndtR NZ003Z 2025-11-29T14:07:06.308Z 2025-12-06T14:52:17.937Z
8628669 8628669 20251128130311_j32b0 NZ003Z 2025-11-29T14:06:55.979Z 2025-12-06T14:52:10.227Z
8628657 8628657 20251128130252_v2zJ9 NZ003Z 2025-11-29T14:06:54.835Z 2025-12-06T14:52:09.689Z
8627706 8627706 20251128113146_lN7ya NZ003Z 2025-11-29T14:04:21.936Z 2025-12-06T14:51:24.159Z
8627677 8627677 20251128112747_yVKs5 NZ003Z 2025-11-29T14:04:13.191Z 2025-12-06T14:51:23.570Z
8627417 8627417 20251128105633_PX3AT NZ003Z 2025-11-29T14:03:29.958Z 2025-12-06T14:51:17.601Z
8627268 8627268 20251128104118_T2WVu NZ003Z 2025-11-29T14:03:09.416Z 2025-12-06T14:51:15.366Z
8626906 8626906 20251128095615_LAoTh NZ003Z 2025-11-29T14:01:53.482Z 2025-12-06T14:51:07.733Z
8626850 8626850 20251128094630_03cc4 NZ003Z 2025-11-29T14:01:39.323Z 2025-12-06T14:50:52.409Z
8626648 8626648 20251128091503_1Uc3X NZ003Z 2025-11-29T14:01:06.187Z 2025-12-06T14:50:39.678Z
8620014 8620014 20251126113325_j92TL NZ003Z 2025-11-28T14:11:24.372Z 2025-12-05T15:01:24.243Z
8619986 8619986 20251126112846_E6obI NZ003Z 2025-11-28T14:11:14.991Z 2025-12-05T15:01:19.225Z
8619971 8619971 20251126112628_oXbEp NZ003Z 2025-11-28T14:11:11.570Z 2025-12-05T15:01:16.367Z
8619811 8619811 20251126110142_3KGtt NZ003Z 2025-11-28T14:10:28.971Z 2025-12-05T15:01:09.425Z
8619719 8619719 20251126105100_5ekfi NZ003Z 2025-11-28T14:10:04.185Z 2025-12-05T15:01:05.580Z
8619528 8619528 20251126102410_VPY4j NZ003Z 2025-11-28T14:09:18.869Z 2025-12-05T15:01:01.006Z
8619085 8619085 20251126090304_Y84dC NZ003Z 2025-11-28T14:07:13.707Z 2025-12-05T15:00:48.122Z
8617811 8617811 20251127103656_wtiaK NZ003Z 2025-11-28T14:02:29.516Z 2025-12-06T14:58:24.647Z
8617776 8617776 20251127103144_naz46 NZ003Z 2025-11-28T14:02:22.170Z 2025-12-06T14:58:23.177Z
8617650 8617650 20251127100844_zI3NH NZ003Z 2025-11-28T14:01:49.111Z 2025-12-06T14:58:16.235Z
8617631 8617631 20251127100445_jFM0U NZ003Z 2025-11-28T14:01:38.291Z 2025-12-06T14:58:14.636Z
8617543 8617543 20251127095016_2exze NZ003Z 2025-11-28T14:01:14.148Z 2025-12-06T14:58:10.813Z
8617534 8617534 20251127094921_RN0ua NZ003Z 2025-11-28T14:01:08.918Z 2025-12-06T14:58:09.244Z
8617463 8617463 20251127093903_1ZNXi NZ003Z 2025-11-28T14:00:55.430Z 2025-12-06T14:58:07.141Z
8604658 8604658 20251120143950_C3PbW NZ003Z 2025-11-26T14:52:42.716Z 2025-11-29T14:53:35.973Z
8604645 8604645 20251120123744_r3qjh NZ003Z 2025-11-26T14:51:49.534Z 2025-11-29T14:53:14.264Z
8561623 8561623 20251121123550_m8U2x NZ003Z 2025-11-23T14:03:11.897Z 2025-11-30T15:03:04.308Z
8561400 8561400 20251121121217_fGOpB NZ003Z 2025-11-23T14:02:38.563Z 2025-11-30T15:02:56.878Z
8560972 8560972 20251121112753_7NlXC NZ003Z 2025-11-23T14:01:28.407Z 2025-11-30T15:02:41.975Z
8560945 8560945 20251121112132_U2L0e NZ003Z 2025-11-23T14:01:21.421Z 2025-11-30T15:02:41.479Z
8554630 8554630 20251120102603_3mEIg NZ003Z 2025-11-22T14:35:38.911Z 2025-11-28T14:58:55.036Z
8554619 8554619 20251120102421_ay5Fm NZ003Z 2025-11-22T14:35:38.085Z 2025-11-28T14:58:54.725Z
8554428 8554428 20251120094348_eFGES NZ003Z 2025-11-22T14:35:26.825Z 2025-11-28T14:58:51.074Z
8554396 8554396 20251120093933_43ZiC NZ003Z 2025-11-22T14:35:22.345Z 2025-11-28T14:58:50.061Z
8554173 8554173 20251120085459_wAOgK NZ003Z 2025-11-22T14:34:50.199Z 2025-11-28T14:58:47.565Z
8554166 8554166 20251120085350_3RXx3 NZ003Z 2025-11-22T14:34:49.867Z 2025-11-28T14:58:47.493Z
8544828 8544828 20251120153718_8RKs5 NZ003Z 2025-11-22T14:08:57.688Z 2025-11-29T14:53:55.168Z
8544790 8544790 20251120153322_SCzih NZ003Z 2025-11-22T14:08:53.140Z 2025-11-29T14:53:53.364Z
8544775 8544775 20251120153141_UMwfg NZ003Z 2025-11-22T14:08:50.484Z 2025-11-25T14:45:55.515Z
8544712 8544712 20251120152744_aBZDW NZ003Z 2025-11-22T14:08:43.886Z 2025-11-29T14:53:50.168Z
8544552 8544552 20251120151952_UtzTi NZ003Z 2025-11-22T14:08:20.064Z 2025-11-29T14:53:47.600Z
8544483 8544483 20251120151453_XchXd NZ003Z 2025-11-22T14:08:02.947Z 2025-11-29T14:53:46.748Z
8544444 8544444 20251120151328_2jyei NZ003Z 2025-11-22T14:07:58.809Z 2025-11-29T14:53:46.469Z
8544379 8544379 20251120151008_T1hKW NZ003Z 2025-11-22T14:07:50.698Z 2025-11-29T14:53:43.764Z
8544087 8544087 20251120144716_J2zMG NZ003Z 2025-11-22T14:06:54.922Z 2025-11-29T14:53:40.022Z
8544028 8544028 20251120144314_3RPah NZ003Z 2025-11-22T14:06:48.877Z 2025-11-29T14:53:36.589Z
8543746 8543746 20251120142042_T41Au NZ003Z 2025-11-22T14:05:57.686Z 2025-11-29T14:53:29.132Z
8543564 8543564 20251120140446_4IDFp NZ003Z 2025-11-22T14:05:31.050Z 2025-11-29T14:53:26.907Z
8543509 8543509 20251120140115_8gGkN NZ003Z 2025-11-22T14:05:25.008Z 2025-11-29T14:53:26.430Z
8543492 8543492 20251120135906_SDyxg NZ003Z 2025-11-22T14:05:21.458Z 2025-11-29T14:53:26.192Z
8543409 8543409 20251120135216_tifDc NZ003Z 2025-11-22T14:05:05.565Z 2025-11-29T14:53:25.383Z
8543381 8543381 20251120135125_Q7ZpD NZ003Z 2025-11-22T14:05:01.263Z 2025-11-29T14:53:25.227Z
8543336 8543336 20251120134749_N2j6s NZ003Z 2025-11-22T14:04:49.548Z 2025-11-29T14:53:24.811Z
8543315 8543315 20251120134356_xVYEb NZ003Z 2025-11-22T14:04:41.190Z 2025-11-29T14:53:24.725Z
8543310 8543310 20251120134334_c34J2 NZ003Z 2025-11-22T14:04:40.103Z 2025-11-29T14:53:24.641Z
8543296 8543296 20251120134241_ZtggM NZ003Z 2025-11-22T14:04:38.565Z 2025-11-29T14:53:24.604Z
8543148 8543148 20251120133035_nSWeM NZ003Z 2025-11-22T14:04:08.458Z 2025-11-29T14:53:18.084Z
8543126 8543126 20251120132844_mkjV2 NZ003Z 2025-11-22T14:04:05.628Z 2025-11-29T14:53:18.070Z
8543101 8543101 20251120132559_3ChGs NZ003Z 2025-11-22T14:04:01.587Z 2025-11-29T14:53:17.990Z
8543060 8543060 20251120132313_ej89F NZ003Z 2025-11-22T14:03:57.633Z 2025-11-29T14:53:17.748Z
8543006 8543006 20251120131951_v0aoG NZ003Z 2025-11-22T14:03:51.721Z 2025-11-29T14:53:17.546Z
8542857 8542857 20251120130144_qtUVl NZ003Z 2025-11-22T14:03:20.861Z 2025-11-29T14:53:16.168Z
8542778 8542778 20251120125029_qNTkZ NZ003Z 2025-11-22T14:03:10.772Z 2025-11-29T14:53:14.961Z
8542653 8542653 20251120123711_yxBtd NZ003Z 2025-11-22T14:02:46.265Z 2025-11-29T14:53:14.077Z
8542615 8542615 20251120123319_Ceze2 NZ003Z 2025-11-22T14:02:40.207Z 2025-11-29T14:53:13.473Z
8542577 8542577 20251120122738_5YfXL NZ003Z 2025-11-22T14:02:32.442Z 2025-11-29T14:53:12.917Z
8542563 8542563 20251120122624_UxhX8 NZ003Z 2025-11-22T14:02:30.883Z 2025-11-29T14:53:12.842Z
8542488 8542488 20251120122012_1AcH5 NZ003Z 2025-11-22T14:02:18.628Z 2025-11-29T14:53:12.443Z
8542481 8542481 20251120121958_lpDx6 NZ003Z 2025-11-22T14:02:18.163Z 2025-11-29T14:53:12.438Z
8542448 8542448 20251120121523_ZpJOE NZ003Z 2025-11-22T14:02:13.366Z 2025-11-29T14:53:12.078Z
8542437 8542437 20251120121506_MBOl7 NZ003Z 2025-11-22T14:02:12.310Z 2025-11-29T14:53:12.030Z
8542298 8542298 20251120115226_tplDA NZ003Z 2025-11-22T14:01:45.368Z 2025-11-29T14:53:09.513Z
8542217 8542217 20251120114621_RnNUQ NZ003Z 2025-11-22T14:01:34.279Z 2025-11-29T14:53:07.263Z

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