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

5,335 rows where station_code = "NZ001Y" 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
9627116 9627116 20260408162122_0PAmK NZ001Y 2026-04-09T12:10:05.973Z 2026-04-10T12:14:22.484Z
9626979 9626979 20260408154350_LnIPr NZ001Y 2026-04-09T12:09:40.902Z 2026-04-10T12:14:22.451Z
9626941 9626941 20260408152754_SvRtR NZ001Y 2026-04-09T12:09:35.329Z 2026-04-10T12:14:22.439Z
9626757 9626757 20260408150100_LANIy NZ001Y 2026-04-09T12:09:08.606Z 2026-04-10T12:14:22.409Z
9626212 9626212 20260408132547_tdg5L NZ001Y 2026-04-09T12:07:46.849Z 2026-04-10T12:14:22.318Z
9626050 9626050 20260408130202_ziiaQ NZ001Y 2026-04-09T12:07:24.709Z 2026-04-10T12:14:22.288Z
9626037 9626037 20260408125655_MCjdI NZ001Y 2026-04-09T12:07:22.846Z 2026-04-10T12:14:22.285Z
9625895 9625895 20260408122303_BTFwd NZ001Y 2026-04-09T12:07:04.723Z 2026-04-10T12:14:22.261Z
9625869 9625869 20260408121946_hJNuM NZ001Y 2026-04-09T12:07:01.869Z 2026-04-10T12:14:22.257Z
9625537 9625537 20260408111159_H8K5R NZ001Y 2026-04-09T12:05:48.191Z 2026-04-10T12:14:22.198Z
9624967 9624967 20260408090456_2nllY NZ001Y 2026-04-09T12:03:36.449Z 2026-04-10T12:14:21.823Z
9624741 9624741 20260408081954_4D28d NZ001Y 2026-04-09T12:02:46.081Z 2026-04-10T12:14:21.450Z
9624644 9624644 20260408080244_ktgd6 NZ001Y 2026-04-09T12:02:23.346Z 2026-04-10T12:14:21.427Z
9624464 9624464 20260408070244_d2Ssc NZ001Y 2026-04-09T12:01:34.061Z 2026-04-10T12:14:21.381Z
9605491 9605491 20260403101916_YmE03 NZ001Y 2026-04-04T12:02:33.855Z 2026-04-10T12:31:37.044Z
9604232 9604232 20260402164317_WrG33 NZ001Y 2026-04-03T12:06:27.862Z 2026-04-10T12:34:45.706Z
9603529 9603529 20260402105248_y8nNV NZ001Y 2026-04-03T12:03:25.887Z 2026-04-10T12:34:03.671Z
9603338 9603338 20260402093656_fSMby NZ001Y 2026-04-03T12:02:39.490Z 2026-04-10T12:34:00.264Z
9603041 9603041 20260402071210_BaPS1 NZ001Y 2026-04-03T12:01:33.208Z 2026-04-10T12:33:40.009Z
9601873 9601873 20260401171832_8o8Ke NZ001Y 2026-04-02T12:04:00.412Z 2026-04-10T12:35:48.805Z
9600896 9600896 20260401075856_be5N0 NZ001Y 2026-04-02T12:00:53.331Z 2026-04-10T12:35:29.127Z
9595817 9595817 20260330085704_HOsBr NZ001Y 2026-03-31T12:02:35.945Z 2026-04-08T12:42:33.394Z
9595684 9595684 20260330080038_5ri5W NZ001Y 2026-03-31T12:02:12.126Z 2026-04-08T12:42:29.430Z
9587983 9587983 20260327171125_xcXit NZ001Y 2026-03-28T12:06:51.699Z 2026-04-05T12:35:02.667Z
9587779 9587779 20260327154825_4jtas NZ001Y 2026-03-28T12:06:19.784Z 2026-04-05T12:34:41.970Z
9587029 9587029 20260327105359_3azvb NZ001Y 2026-03-28T12:04:36.855Z 2026-04-05T12:33:59.132Z
9574922 9574922 20260323173837_F04B2 NZ001Y 2026-03-25T12:19:52.641Z 2026-03-31T12:28:44.329Z
9574783 9574783 20260323172107_uf330 NZ001Y 2026-03-25T12:19:40.342Z 2026-03-31T12:28:41.913Z
9574317 9574317 20260324162608_Yyx4M NZ001Y 2026-03-25T12:10:17.827Z 2026-04-02T12:36:47.646Z
9574221 9574221 20260324155706_zh4Oi NZ001Y 2026-03-25T12:10:01.741Z 2026-04-02T12:36:42.849Z
9574132 9574132 20260324152342_ngbWN NZ001Y 2026-03-25T12:09:44.319Z 2026-04-02T12:36:39.555Z
9569000 9569000 20260322121528_JHJ1C NZ001Y 2026-03-24T12:19:20.925Z 2026-03-30T12:29:15.716Z
9568529 9568529 20260323165244_XvFVf NZ001Y 2026-03-24T12:15:14.995Z 2026-03-31T12:28:30.363Z
9568512 9568512 20260323165114_xyMeB NZ001Y 2026-03-24T12:15:13.164Z 2026-03-31T12:28:30.161Z
9568509 9568509 20260323165113_LF3b2 NZ001Y 2026-03-24T12:15:12.862Z 2026-03-31T12:28:30.121Z
9568381 9568381 20260323163841_LINDi NZ001Y 2026-03-24T12:14:59.771Z 2026-03-31T12:28:28.588Z
9568243 9568243 20260323162249_3VAAg NZ001Y 2026-03-24T12:14:46.475Z 2026-03-31T12:28:26.292Z
9567577 9567577 20260323153205_BCbvd NZ001Y 2026-03-24T12:13:48.463Z 2026-03-31T12:28:16.001Z
9567549 9567549 20260323152823_g2LeK NZ001Y 2026-03-24T12:13:45.953Z 2026-03-31T12:28:15.523Z
9567475 9567475 20260323152117_huxbz NZ001Y 2026-03-24T12:13:40.101Z 2026-03-31T12:28:14.474Z
9567426 9567426 20260323151441_WGvNF NZ001Y 2026-03-24T12:13:36.046Z 2026-03-31T12:28:14.003Z
9567361 9567361 20260323150957_UCGd2 NZ001Y 2026-03-24T12:13:27.705Z 2026-03-24T12:24:25.266Z
9566804 9566804 20260323141523_81uFw NZ001Y 2026-03-24T12:12:27.917Z 2026-03-31T12:28:04.474Z
9566712 9566712 20260323140705_QUAh8 NZ001Y 2026-03-24T12:12:21.295Z 2026-03-31T12:27:56.050Z
9566693 9566693 20260323140621_O2F11 NZ001Y 2026-03-24T12:12:20.033Z 2026-03-31T12:27:55.754Z
9566660 9566660 20260323140123_R3Lio NZ001Y 2026-03-24T12:12:16.503Z 2026-03-31T12:27:55.166Z
9566642 9566642 20260323135840_dIruW NZ001Y 2026-03-24T12:12:14.449Z 2026-03-31T12:27:54.910Z
9566299 9566299 20260323132346_eQfmM NZ001Y 2026-03-24T12:11:36.638Z 2026-03-31T12:27:48.469Z
9566155 9566155 20260323131018_Urw62 NZ001Y 2026-03-24T12:11:24.479Z 2026-03-31T12:27:46.769Z
9565440 9565440 20260323120941_6Q7uK NZ001Y 2026-03-24T12:10:07.487Z 2026-03-31T12:27:35.275Z
9565240 9565240 20260323115258_uB2AR NZ001Y 2026-03-24T12:09:42.643Z 2026-03-31T12:27:31.701Z
9564989 9564989 20260323113420_bWPXm NZ001Y 2026-03-24T12:09:12.266Z 2026-03-31T12:27:20.469Z
9564168 9564168 20260323100710_m2iHe NZ001Y 2026-03-24T12:07:33.130Z 2026-03-31T12:27:04.172Z
9563917 9563917 20260323093404_tc7ir NZ001Y 2026-03-24T12:07:00.250Z 2026-03-31T12:26:59.128Z
9563563 9563563 20260323084250_dtfBD NZ001Y 2026-03-24T12:06:15.758Z 2026-03-31T12:26:46.924Z
9563507 9563507 20260323082622_Ejytb NZ001Y 2026-03-24T12:06:08.313Z 2026-03-31T12:26:45.872Z
9563374 9563374 20260323080641_aNw9f NZ001Y 2026-03-24T12:05:53.034Z 2026-03-31T12:26:41.982Z
9559486 9559486 20260321172816_WCNB9 NZ001Y 2026-03-23T12:11:07.619Z 2026-03-29T12:20:39.907Z
9559474 9559474 20260321172518_ZFDkq NZ001Y 2026-03-23T12:11:07.210Z 2026-03-29T12:20:39.684Z
9559413 9559413 20260321171406_Lq4Cm NZ001Y 2026-03-23T12:11:05.123Z 2026-03-29T12:20:38.891Z
9559394 9559394 20260321170925_b8pna NZ001Y 2026-03-23T12:11:04.147Z 2026-03-29T12:20:38.498Z
9559306 9559306 20260321165611_AeSyg NZ001Y 2026-03-23T12:11:01.391Z 2026-03-29T12:20:36.426Z
9559215 9559215 20260321164745_82eY5 NZ001Y 2026-03-23T12:10:58.072Z 2026-03-29T12:20:35.362Z
9559162 9559162 20260321164144_2Jb53 NZ001Y 2026-03-23T12:10:56.224Z 2026-03-29T12:20:34.794Z
9558893 9558893 20260321160308_8Ue6s NZ001Y 2026-03-23T12:10:38.957Z 2026-03-29T12:20:31.490Z
9558407 9558407 20260322163325_Ylhth NZ001Y 2026-03-23T12:06:42.205Z 2026-03-30T12:30:12.681Z
9557744 9557744 20260322145039_I32GB NZ001Y 2026-03-23T12:06:08.342Z 2026-03-30T12:29:46.606Z
9557688 9557688 20260322144228_IbV7N NZ001Y 2026-03-23T12:06:05.444Z 2026-03-30T12:29:44.964Z
9557452 9557452 20260322140216_K8Ju1 NZ001Y 2026-03-23T12:05:50.751Z 2026-03-30T12:29:38.078Z
9557051 9557051 20260322123951_VY5wH NZ001Y 2026-03-23T12:05:30.255Z 2026-03-30T12:29:19.929Z
9556792 9556792 20260322114206_aEM3e NZ001Y 2026-03-23T12:05:13.295Z 2026-03-30T12:29:11.200Z
9556559 9556559 20260322110653_6TkM3 NZ001Y 2026-03-23T12:04:56.697Z 2026-03-30T12:29:04.676Z
9556186 9556186 20260322093227_PPho0 NZ001Y 2026-03-23T12:04:27.642Z 2026-03-30T12:28:46.988Z
9556088 9556088 20260322091551_j5rGx NZ001Y 2026-03-23T12:04:20.554Z 2026-03-30T12:28:44.506Z
9548639 9548639 20260321152223_XVgMG NZ001Y 2026-03-22T12:15:44.884Z 2026-03-29T12:20:27.673Z
9548463 9548463 20260321150630_3Ixih NZ001Y 2026-03-22T12:15:27.211Z 2026-03-29T12:20:26.606Z
9548343 9548343 20260321145426_ab2nv NZ001Y 2026-03-22T12:15:16.537Z 2026-03-29T12:20:25.450Z
9548266 9548266 20260321144927_aMac6 NZ001Y 2026-03-22T12:15:08.665Z 2026-03-29T12:20:25.033Z
9548134 9548134 20260321143708_TZeF9 NZ001Y 2026-03-22T12:14:56.132Z 2026-03-29T12:20:24.192Z
9547891 9547891 20260321140642_hL412 NZ001Y 2026-03-22T12:14:27.748Z 2026-03-29T12:20:22.187Z
9547849 9547849 20260321140353_h2JHq NZ001Y 2026-03-22T12:14:24.249Z 2026-03-29T12:20:21.921Z
9546253 9546253 20260321114800_yk6NG NZ001Y 2026-03-22T12:11:24.156Z 2026-03-29T12:19:48.955Z
9546213 9546213 20260321114457_RW4q4 NZ001Y 2026-03-22T12:11:16.818Z 2026-03-29T12:19:48.442Z
9546014 9546014 20260321113101_5kWlG NZ001Y 2026-03-22T12:10:49.467Z 2026-03-29T12:19:46.719Z
9529229 9529229 20260318172917_6w2W5 NZ001Y 2026-03-20T12:22:58.764Z 2026-03-26T12:38:51.419Z
9528832 9528832 20260318164752_IbOax NZ001Y 2026-03-20T12:22:33.052Z 2026-03-26T12:38:38.362Z
9528478 9528478 20260318161856_90UrQ NZ001Y 2026-03-20T12:22:18.812Z 2026-03-26T12:38:36.436Z
9528384 9528384 20260318161005_wNyhS NZ001Y 2026-03-20T12:22:14.897Z 2026-03-26T12:38:35.810Z
9527386 9527386 20260318143540_eQLQZ NZ001Y 2026-03-20T12:21:14.793Z 2026-03-26T12:38:28.033Z
9526364 9526364 20260319163232_dB7z2 NZ001Y 2026-03-20T12:15:09.495Z 2026-03-27T12:42:25.538Z
9526230 9526230 20260319161322_QcMLE NZ001Y 2026-03-20T12:14:57.357Z 2026-03-27T12:42:24.128Z
9525927 9525927 20260319153340_mlwUb NZ001Y 2026-03-20T12:14:41.392Z 2026-03-27T12:42:21.216Z
9525720 9525720 20260319151001_XKvW3 NZ001Y 2026-03-20T12:14:27.563Z 2026-03-27T12:42:19.276Z
9525455 9525455 20260319143351_oKOZh NZ001Y 2026-03-20T12:14:14.163Z 2026-03-27T12:42:03.830Z
9525377 9525377 20260319142019_58KhA NZ001Y 2026-03-20T12:14:10.849Z 2026-03-27T12:42:03.184Z
9525234 9525234 20260319135743_hNrX9 NZ001Y 2026-03-20T12:14:03.150Z 2026-03-27T12:42:02.016Z
9525215 9525215 20260319135018_oYnxX NZ001Y 2026-03-20T12:13:58.350Z 2026-03-27T12:42:01.853Z
9524995 9524995 20260319130604_EV0GP NZ001Y 2026-03-20T12:13:44.416Z 2026-03-27T12:41:58.900Z
9524920 9524920 20260319125911_1kW7M NZ001Y 2026-03-20T12:13:40.496Z 2026-03-27T12:41:58.306Z
9524916 9524916 20260319125445_CZrJH NZ001Y 2026-03-20T12:13:39.943Z 2026-03-27T12:41:58.218Z

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