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 = "NZ0009" 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
9627288 9627288 20260408170058_2Dqbz NZ0009 2026-04-09T12:10:33.641Z 2026-04-10T12:14:22.516Z
9627261 9627261 20260408165527_8dPXj NZ0009 2026-04-09T12:10:29.778Z 2026-04-10T12:14:22.511Z
9627251 9627251 20260408165236_h25tO NZ0009 2026-04-09T12:10:28.725Z 2026-04-10T12:14:22.510Z
9626798 9626798 20260408150752_Ic6oq NZ0009 2026-04-09T12:09:13.562Z 2026-04-10T12:14:22.417Z
9626670 9626670 20260408144522_4ICB3 NZ0009 2026-04-09T12:08:55.010Z 2026-04-10T12:14:22.397Z
9626660 9626660 20260408143736_3of7c NZ0009 2026-04-09T12:08:53.280Z 2026-04-10T12:14:22.394Z
9626591 9626591 20260408142333_OvmFx NZ0009 2026-04-09T12:08:45.422Z 2026-04-10T12:14:22.381Z
9626495 9626495 20260408140637_HKvFL NZ0009 2026-04-09T12:08:28.079Z 2026-04-10T12:14:22.362Z
9625696 9625696 20260408113624_VH2pZ NZ0009 2026-04-09T12:06:20.140Z 2026-04-10T12:14:22.224Z
9625573 9625573 20260408112045_lVy7y NZ0009 2026-04-09T12:06:00.902Z 2026-04-10T12:14:22.206Z
9604369 9604369 20260402173146_7AGjl NZ0009 2026-04-03T12:07:05.994Z 2026-04-10T12:34:49.225Z
9604333 9604333 20260402171650_urqNA NZ0009 2026-04-03T12:06:55.919Z 2026-04-10T12:34:48.307Z
9604269 9604269 20260402164904_xItvC NZ0009 2026-04-03T12:06:35.670Z 2026-04-10T12:34:46.594Z
9604019 9604019 20260402150115_WT6u2 NZ0009 2026-04-03T12:05:34.873Z 2026-04-10T12:34:17.723Z
9603973 9603973 20260402143023_WBCF4 NZ0009 2026-04-03T12:05:23.656Z 2026-04-10T12:34:16.808Z
9603899 9603899 20260402133052_R4h8P NZ0009 2026-04-03T12:04:59.403Z 2026-04-10T12:34:15.141Z
9603796 9603796 20260402124030_M4q2m NZ0009 2026-04-03T12:04:36.479Z 2026-04-10T12:34:09.961Z
9603750 9603750 20260402120640_ykkq2 NZ0009 2026-04-03T12:04:25.086Z 2026-04-10T12:34:08.744Z
9603730 9603730 20260402115851_qTIRZ NZ0009 2026-04-03T12:04:19.724Z 2026-04-10T12:34:08.185Z
9603639 9603639 20260402113038_g836e NZ0009 2026-04-03T12:03:53.748Z 2026-04-10T12:34:06.003Z
9603622 9603622 20260402112525_YzZoK NZ0009 2026-04-03T12:03:50.950Z 2026-04-10T12:34:05.671Z
9603540 9603540 20260402105929_UGGoP NZ0009 2026-04-03T12:03:27.552Z 2026-04-10T12:34:03.881Z
9603386 9603386 20260402095324_ZRw5x NZ0009 2026-04-03T12:02:47.239Z 2026-04-10T12:34:01.032Z
9603277 9603277 20260402091308_7HBiU NZ0009 2026-04-03T12:02:29.261Z 2026-04-10T12:33:59.203Z
9603087 9603087 20260402074543_3kDyC NZ0009 2026-04-03T12:01:42.913Z 2026-04-10T12:33:55.424Z
9601997 9601997 20260401174711_awwiX NZ0009 2026-04-02T12:04:28.107Z 2026-04-10T12:35:51.017Z
9601862 9601862 20260401171629_g33pO NZ0009 2026-04-02T12:03:57.709Z 2026-04-10T12:35:48.609Z
9601411 9601411 20260401150709_kZt4B NZ0009 2026-04-02T12:02:43.296Z 2026-04-10T12:35:38.602Z
9601409 9601409 20260401150531_ATDVQ NZ0009 2026-04-02T12:02:41.958Z 2026-04-10T12:35:38.518Z
9601353 9601353 20260401144606_7GZy8 NZ0009 2026-04-02T12:02:31.154Z 2026-04-10T12:35:37.487Z
9601321 9601321 20260401141640_IGKy2 NZ0009 2026-04-02T12:02:24.956Z 2026-04-10T12:35:36.868Z
9601256 9601256 20260401133430_lYtZo NZ0009 2026-04-02T12:02:08.609Z 2026-04-10T12:35:35.626Z
9601234 9601234 20260401132621_ZQzVH NZ0009 2026-04-02T12:02:04.902Z 2026-04-10T12:35:35.319Z
9601156 9601156 20260401123546_gKU6A NZ0009 2026-04-02T12:01:48.336Z 2026-04-10T12:35:34.307Z
9601127 9601127 20260401122050_C2f1Y NZ0009 2026-04-02T12:01:41.237Z 2026-04-10T12:35:33.597Z
9601120 9601120 20260401120957_aAIK2 NZ0009 2026-04-02T12:01:40.472Z 2026-04-10T12:35:33.483Z
9601079 9601079 20260401113021_3aWSG NZ0009 2026-04-02T12:01:30.739Z 2026-04-10T12:35:32.867Z
9601055 9601055 20260401111106_BTlvN NZ0009 2026-04-02T12:01:26.384Z 2026-04-10T12:35:32.340Z
9601038 9601038 20260401104704_92pZi NZ0009 2026-04-02T12:01:22.177Z 2026-04-10T12:35:32.060Z
9600984 9600984 20260401101458_eJkgR NZ0009 2026-04-02T12:01:12.607Z 2026-04-10T12:35:31.142Z
9600881 9600881 20260401073621_2dxqu NZ0009 2026-04-02T12:00:48.181Z 2026-04-10T12:35:28.689Z
9599528 9599528 20260331153034_G2m1t NZ0009 2026-04-01T12:03:57.146Z 2026-04-09T12:46:55.070Z
9599479 9599479 20260331145639_Bq6fq NZ0009 2026-04-01T12:03:45.708Z 2026-04-09T12:46:48.324Z
9599477 9599477 20260331145609_fmea9 NZ0009 2026-04-01T12:03:44.986Z 2026-04-09T12:46:48.296Z
9599406 9599406 20260331142536_mFHgm NZ0009 2026-04-01T12:03:28.391Z 2026-04-09T12:46:47.096Z
9599347 9599347 20260331140520_SY2Dk NZ0009 2026-04-01T12:03:16.197Z 2026-04-09T12:46:46.349Z
9599295 9599295 20260331134414_k8SGX NZ0009 2026-04-01T12:03:05.238Z 2026-04-09T12:46:45.660Z
9599254 9599254 20260331131949_FdMa0 NZ0009 2026-04-01T12:02:55.272Z 2026-04-09T12:46:44.735Z
9594012 9594012 20260329174503_8aV6C NZ0009 2026-03-30T12:05:49.985Z 2026-04-07T12:27:42.773Z
9588013 9588013 20260327172739_2GCG9 NZ0009 2026-03-28T12:06:56.247Z 2026-04-05T12:35:04.123Z
9587781 9587781 20260327154939_cMxVt NZ0009 2026-03-28T12:06:20.065Z 2026-04-05T12:34:42.115Z
9587722 9587722 20260327152117_0Fl3s NZ0009 2026-03-28T12:06:12.553Z 2026-04-05T12:34:38.754Z
9587707 9587707 20260327151352_HlDXL NZ0009 2026-03-28T12:06:10.620Z 2026-04-05T12:34:38.045Z
9587648 9587648 20260327145258_AjUwz NZ0009 2026-03-28T12:06:00.508Z 2026-04-05T12:34:35.105Z
9587597 9587597 20260327142730_Ab22W NZ0009 2026-03-28T12:05:53.281Z 2026-04-05T12:34:33.022Z
9587578 9587578 20260327141914_zYjPt NZ0009 2026-03-28T12:05:51.324Z 2026-04-05T12:34:32.336Z
9587551 9587551 20260327140046_b1jmh NZ0009 2026-03-28T12:05:48.276Z 2026-04-05T12:34:31.162Z
9587506 9587506 20260327133454_iu2td NZ0009 2026-03-28T12:05:41.770Z 2026-04-05T12:34:29.217Z
9587487 9587487 20260327132127_Gl53D NZ0009 2026-03-28T12:05:39.409Z 2026-04-05T12:34:28.556Z
9587483 9587483 20260327131940_0HIFH NZ0009 2026-03-28T12:05:38.673Z 2026-04-05T12:34:28.340Z
9587378 9587378 20260327122146_58o4C NZ0009 2026-03-28T12:05:23.274Z 2026-04-05T12:34:24.334Z
9587350 9587350 20260327121500_FqNkb NZ0009 2026-03-28T12:05:20.448Z 2026-04-05T12:34:23.194Z
9574875 9574875 20260323173149_IrHgz NZ0009 2026-03-25T12:19:49.033Z 2026-03-31T12:28:43.724Z
9567810 9567810 20260323155136_nbHDo NZ0009 2026-03-24T12:14:10.997Z 2026-03-31T12:28:19.356Z
9566925 9566925 20260323142636_ct73g NZ0009 2026-03-24T12:12:43.590Z 2026-03-31T12:28:06.135Z
9566542 9566542 20260323135052_gLlJ8 NZ0009 2026-03-24T12:12:03.741Z 2026-03-31T12:27:53.560Z
9566203 9566203 20260323131347_GKOl3 NZ0009 2026-03-24T12:11:26.755Z 2026-03-31T12:27:47.048Z
9566140 9566140 20260323130935_kwiJZ NZ0009 2026-03-24T12:11:24.049Z 2026-03-31T12:27:46.661Z
9565949 9565949 20260323125452_3R3Fa NZ0009 2026-03-24T12:11:06.025Z 2026-03-31T12:27:43.991Z
9565658 9565658 20260323123250_OIivw NZ0009 2026-03-24T12:10:37.138Z 2026-03-31T12:27:39.471Z
9565513 9565513 20260323121457_H8YWB NZ0009 2026-03-24T12:10:20.078Z 2026-03-31T12:27:36.905Z
9565432 9565432 20260323120916_Dj8C8 NZ0009 2026-03-24T12:10:07.064Z 2026-03-31T12:27:35.177Z
9565026 9565026 20260323113834_pTFV3 NZ0009 2026-03-24T12:09:16.713Z 2026-03-31T12:27:21.401Z
9564970 9564970 20260323113317_tyAF5 NZ0009 2026-03-24T12:09:09.248Z 2026-03-31T12:27:20.158Z
9564637 9564637 20260323105826_8z9jQ NZ0009 2026-03-24T12:08:30.400Z 2026-03-31T12:27:12.960Z
9564613 9564613 20260323105549_REbZs NZ0009 2026-03-24T12:08:27.701Z 2026-03-31T12:27:12.487Z
9564576 9564576 20260323105113_yiqsl NZ0009 2026-03-24T12:08:24.327Z 2026-03-31T12:27:11.858Z
9564444 9564444 20260323103520_EWmdP NZ0009 2026-03-24T12:08:05.233Z 2026-03-31T12:27:09.131Z
9564338 9564338 20260323102400_0DvUD NZ0009 2026-03-24T12:07:52.807Z 2026-03-31T12:27:07.352Z
9564318 9564318 20260323102352_0DScG NZ0009 2026-03-24T12:07:51.799Z 2026-03-31T12:27:07.173Z
9563958 9563958 20260323094035_grdH2 NZ0009 2026-03-24T12:07:04.478Z 2026-03-31T12:26:59.830Z
9563911 9563911 20260323093356_zSsJZ NZ0009 2026-03-24T12:06:59.659Z 2026-03-31T12:26:59.048Z
9563709 9563709 20260323090311_your1 NZ0009 2026-03-24T12:06:35.932Z 2026-03-31T12:26:49.664Z
9563597 9563597 20260323084942_RUoqQ NZ0009 2026-03-24T12:06:22.827Z 2026-03-31T12:26:47.853Z
9563547 9563547 20260323083456_GbjXX NZ0009 2026-03-24T12:06:12.533Z 2026-03-31T12:26:46.509Z
9563541 9563541 20260323083156_T1icx NZ0009 2026-03-24T12:06:12.085Z 2026-03-31T12:26:46.365Z
9563265 9563265 20260323075109_yPr0o NZ0009 2026-03-24T12:05:38.537Z 2026-03-31T12:26:39.626Z
9559497 9559497 20260321173156_vuF9O NZ0009 2026-03-23T12:11:08.019Z 2026-03-29T12:20:40.034Z
9559377 9559377 20260321170716_1Yzrl NZ0009 2026-03-23T12:11:03.652Z 2026-03-29T12:20:38.316Z
9559350 9559350 20260321170134_BDPKA NZ0009 2026-03-23T12:11:02.779Z 2026-03-29T12:20:38.103Z
9559101 9559101 20260321163203_jmHLT NZ0009 2026-03-23T12:10:54.011Z 2026-03-29T12:20:33.988Z
9558934 9558934 20260321160551_crr7m NZ0009 2026-03-23T12:10:40.213Z 2026-03-29T12:20:31.878Z
9550929 9550929 20260320172521_gFean NZ0009 2026-03-22T12:25:59.243Z 2026-03-28T12:36:37.801Z
9550634 9550634 20260320165631_1AMaz NZ0009 2026-03-22T12:25:33.535Z 2026-03-28T12:36:33.560Z
9550625 9550625 20260320165631_YadUj NZ0009 2026-03-22T12:25:33.419Z 2026-03-28T12:36:33.463Z
9550577 9550577 20260320165221_jFjQM NZ0009 2026-03-22T12:25:31.022Z 2026-03-28T12:36:32.829Z
9550431 9550431 20260320163853_VR9Lk NZ0009 2026-03-22T12:25:15.416Z 2026-03-28T12:36:30.884Z
9550342 9550342 20260320163041_Aoo3R NZ0009 2026-03-22T12:25:09.046Z 2026-03-28T12:36:29.724Z
9550120 9550120 20260320161006_1L1sV NZ0009 2026-03-22T12:24:56.086Z 2026-03-28T12:36:27.178Z
9549903 9549903 20260320155233_bOp04 NZ0009 2026-03-22T12:24:35.439Z 2026-03-28T12:36:23.478Z

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