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 = "NZ0034" 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
9626921 9626921 20260408152241_BA5kc NZ0034 2026-04-09T12:09:32.189Z 2026-04-09T12:09:32.189Z
9626845 9626845 20260408151337_kDiiu NZ0034 2026-04-09T12:09:19.291Z 2026-04-09T12:09:19.291Z
9626665 9626665 20260408144237_zjV9x NZ0034 2026-04-09T12:08:54.083Z 2026-04-09T12:08:54.083Z
9626172 9626172 20260408132204_GRcum NZ0034 2026-04-09T12:07:43.980Z 2026-04-09T12:07:43.980Z
9626045 9626045 20260408130002_LBWdW NZ0034 2026-04-09T12:07:23.745Z 2026-04-09T12:07:23.745Z
9625047 9625047 20260408092333_p6qZG NZ0034 2026-04-09T12:04:00.678Z 2026-04-09T12:04:00.678Z
9624946 9624946 20260408090019_2RRiu NZ0034 2026-04-09T12:03:31.525Z 2026-04-09T12:03:31.525Z
9610374 9610374 20260405173141_m5XWm NZ0034 2026-04-06T12:07:25.493Z 2026-04-09T12:36:46.460Z
9610314 9610314 20260405160521_2TUsT NZ0034 2026-04-06T12:06:58.612Z 2026-04-09T12:36:43.668Z
9610068 9610068 20260405122642_YGHV3 NZ0034 2026-04-06T12:05:29.959Z 2026-04-09T12:36:20.091Z
9610041 9610041 20260405120601_9BMQB NZ0034 2026-04-06T12:05:23.366Z 2026-04-09T12:36:19.242Z
9610039 9610039 20260405120528_m62fs NZ0034 2026-04-06T12:05:22.578Z 2026-04-09T12:36:19.041Z
9610000 9610000 20260405114848_zG3Ze NZ0034 2026-04-06T12:05:13.234Z 2026-04-09T12:36:17.469Z
9609660 9609660 20260405090011_WfpiM NZ0034 2026-04-06T12:03:09.042Z 2026-04-09T12:36:03.960Z
9609603 9609603 20260405083502_sJyDU NZ0034 2026-04-06T12:02:52.468Z 2026-04-09T12:36:02.248Z
9609600 9609600 20260405083501_FghC2 NZ0034 2026-04-06T12:02:51.877Z 2026-04-09T12:36:02.166Z
9609577 9609577 20260405082540_zzZeD NZ0034 2026-04-06T12:02:41.284Z 2026-04-09T12:36:01.483Z
9609542 9609542 20260405080105_FclrY NZ0034 2026-04-06T12:02:27.424Z 2026-04-09T12:35:58.397Z
9609044 9609044 20260402104509_TV43a NZ0034 2026-04-05T12:14:12.469Z 2026-04-09T12:43:56.333Z
9607459 9607459 20260404093509_7bUds NZ0034 2026-04-05T12:02:23.256Z 2026-04-09T12:39:22.936Z
9606034 9606034 20260403143136_O389c NZ0034 2026-04-04T12:05:02.499Z 2026-04-09T12:42:06.551Z
9605911 9605911 20260403125219_qFssu NZ0034 2026-04-04T12:04:25.808Z 2026-04-09T12:42:03.636Z
9605888 9605888 20260403123542_ZKzK7 NZ0034 2026-04-04T12:04:20.918Z 2026-04-09T12:42:03.130Z
9605814 9605814 20260403120945_s3ASu NZ0034 2026-04-04T12:04:01.416Z 2026-04-09T12:41:54.094Z
9605777 9605777 20260403120133_6q2uo NZ0034 2026-04-04T12:03:53.442Z 2026-04-09T12:41:31.375Z
9605735 9605735 20260403114521_xS0XQ NZ0034 2026-04-04T12:03:38.885Z 2026-04-09T12:41:30.252Z
9605582 9605582 20260403105318_TNIdg NZ0034 2026-04-04T12:02:57.547Z 2026-04-09T12:41:25.817Z
9605406 9605406 20260403094935_FO1SW NZ0034 2026-04-04T12:02:08.934Z 2026-04-09T12:41:21.744Z
9605192 9605192 20260403073646_hBoro NZ0034 2026-04-04T12:01:03.953Z 2026-04-09T12:41:16.432Z
9605183 9605183 20260403073139_1332G NZ0034 2026-04-04T12:01:01.449Z 2026-04-09T12:41:16.282Z
9605135 9605135 20260403070409_U4jDI NZ0034 2026-04-04T12:00:52.531Z 2026-04-09T12:41:15.172Z
9604267 9604267 20260402164835_Zh8vX NZ0034 2026-04-03T12:06:35.181Z 2026-04-09T12:44:19.121Z
9603871 9603871 20260402131826_K0ay4 NZ0034 2026-04-03T12:04:55.594Z 2026-04-09T12:44:10.691Z
9603847 9603847 20260402131059_62RDW NZ0034 2026-04-03T12:04:52.563Z 2026-04-09T12:44:10.325Z
9603605 9603605 20260402111824_zuJhb NZ0034 2026-04-03T12:03:47.185Z 2026-04-09T12:44:04.906Z
9603534 9603534 20260402105352_EUMkL NZ0034 2026-04-03T12:03:26.410Z 2026-04-09T12:44:01.266Z
9603509 9603509 20260402104540_I6Qi2 NZ0034 2026-04-03T12:03:18.378Z 2026-04-09T12:43:57.826Z
9601758 9601758 20260401165230_ScKq6 NZ0034 2026-04-02T12:03:37.821Z 2026-04-09T12:45:35.722Z
9601613 9601613 20260401160914_8s6Lz NZ0034 2026-04-02T12:03:16.523Z 2026-04-09T12:45:32.200Z
9601285 9601285 20260401134803_gQjtz NZ0034 2026-04-02T12:02:16.631Z 2026-04-09T12:45:26.151Z
9601273 9601273 20260401134242_13cZa NZ0034 2026-04-02T12:02:12.649Z 2026-04-09T12:45:25.940Z
9601254 9601254 20260401133230_TmqwC NZ0034 2026-04-02T12:02:08.124Z 2026-04-09T12:45:25.556Z
9600997 9600997 20260401101908_UQ1lB NZ0034 2026-04-02T12:01:14.754Z 2026-04-09T12:45:21.681Z
9599884 9599884 20260331171820_Rx0iW NZ0034 2026-04-01T12:05:10.385Z 2026-04-09T12:47:59.169Z
9599215 9599215 20260331125334_3O16C NZ0034 2026-04-01T12:02:46.251Z 2026-04-09T12:46:44.163Z
9599177 9599177 20260331122826_etXpx NZ0034 2026-04-01T12:02:38.165Z 2026-04-09T12:46:43.395Z
9599060 9599060 20260331112056_JYIyp NZ0034 2026-04-01T12:02:13.890Z 2026-04-09T12:46:40.726Z
9598881 9598881 20260331082307_r7Gcq NZ0034 2026-04-01T12:01:24.728Z 2026-04-09T12:46:37.351Z
9598828 9598828 20260331074144_cXo3j NZ0034 2026-04-01T12:01:13.873Z 2026-04-09T12:46:36.530Z
9598795 9598795 20260331072053_tNtrd NZ0034 2026-04-01T12:01:07.047Z 2026-04-09T12:46:35.860Z
9598790 9598790 20260331071608_HREQu NZ0034 2026-04-01T12:01:05.735Z 2026-04-09T12:46:35.716Z
9597211 9597211 20260330153458_qSkTd NZ0034 2026-03-31T12:05:55.299Z 2026-04-08T12:43:35.741Z
9597181 9597181 20260330153309_1N73M NZ0034 2026-03-31T12:05:51.773Z 2026-04-08T12:43:35.045Z
9596908 9596908 20260330143034_gxXSr NZ0034 2026-03-31T12:05:14.248Z 2026-04-08T12:43:27.649Z
9596288 9596288 20260330120631_5p2IA NZ0034 2026-03-31T12:03:56.516Z 2026-04-08T12:42:48.545Z
9595975 9595975 20260330102227_TqAfI NZ0034 2026-03-31T12:03:02.452Z 2026-04-08T12:42:37.728Z
9591573 9591573 20260328171359_LPGCo NZ0034 2026-03-29T12:04:38.195Z 2026-04-06T12:39:23.737Z
9591530 9591530 20260328170302_3qffQ NZ0034 2026-03-29T12:04:32.943Z 2026-04-06T12:39:21.680Z
9591469 9591469 20260328164803_Na8PA NZ0034 2026-03-29T12:04:28.587Z 2026-04-06T12:39:17.234Z
9591463 9591463 20260328164426_yCDhS NZ0034 2026-03-29T12:04:27.924Z 2026-04-06T12:39:16.911Z
9591455 9591455 20260328164340_gYS8D NZ0034 2026-03-29T12:04:27.134Z 2026-04-06T12:39:16.489Z
9591387 9591387 20260328161342_wzJGv NZ0034 2026-03-29T12:04:20.397Z 2026-04-06T12:39:13.511Z
9591346 9591346 20260328154724_nvdca NZ0034 2026-03-29T12:04:17.327Z 2026-04-06T12:39:11.914Z
9591341 9591341 20260328154551_tDPGV NZ0034 2026-03-29T12:04:16.835Z 2026-04-06T12:39:11.593Z
9591310 9591310 20260328153213_RkCLB NZ0034 2026-03-29T12:04:13.780Z 2026-04-06T12:39:10.549Z
9591182 9591182 20260328140024_DaKee NZ0034 2026-03-29T12:03:58.502Z 2026-04-06T12:39:04.363Z
9591060 9591060 20260328125316_5Xh5d NZ0034 2026-03-29T12:03:46.635Z 2026-04-06T12:38:49.119Z
9590936 9590936 20260328120136_yWRzF NZ0034 2026-03-29T12:03:31.050Z 2026-04-06T12:38:41.260Z
9590831 9590831 20260328112759_6eHhu NZ0034 2026-03-29T12:03:21.204Z 2026-04-06T12:38:36.263Z
9590538 9590538 20260328095226_2eZLj NZ0034 2026-03-29T12:02:52.349Z 2026-04-06T12:38:22.926Z
9590513 9590513 20260328094823_klN1Q NZ0034 2026-03-29T12:02:50.227Z 2026-04-06T12:38:13.778Z
9587681 9587681 20260327150437_I9lPj NZ0034 2026-03-28T12:06:07.326Z 2026-04-05T12:34:36.943Z
9587632 9587632 20260327144448_fLlw7 NZ0034 2026-03-28T12:05:57.024Z 2026-04-05T12:34:34.376Z
9587583 9587583 20260327142030_RDcTJ NZ0034 2026-03-28T12:05:51.572Z 2026-04-05T12:34:32.430Z
9587455 9587455 20260327125332_XXjqE NZ0034 2026-03-28T12:05:33.341Z 2026-04-05T12:34:27.110Z
9587400 9587400 20260327122732_bSPPi NZ0034 2026-03-28T12:05:25.873Z 2026-04-05T12:34:25.085Z
9587366 9587366 20260327121923_hBK6e NZ0034 2026-03-28T12:05:22.074Z 2026-04-05T12:34:23.755Z
9587283 9587283 20260327115901_hJSBx NZ0034 2026-03-28T12:05:11.336Z 2026-04-05T12:34:11.282Z
9587250 9587250 20260327115358_qJMMj NZ0034 2026-03-28T12:05:08.200Z 2026-04-05T12:34:10.094Z
9587016 9587016 20260327104803_lbqip NZ0034 2026-03-28T12:04:34.092Z 2026-04-05T12:33:58.384Z
9587002 9587002 20260327104331_MwoLo NZ0034 2026-03-28T12:04:32.397Z 2026-04-05T12:33:57.996Z
9586999 9586999 20260327104043_mFw06 NZ0034 2026-03-28T12:04:31.118Z 2026-04-05T12:33:57.869Z
9586749 9586749 20260327092355_CUYwb NZ0034 2026-03-28T12:03:55.508Z 2026-04-05T12:33:46.643Z
9583694 9583694 20260326171545_GfSaK NZ0034 2026-03-27T12:09:31.882Z 2026-04-04T12:41:31.700Z
9583569 9583569 20260326161803_Rhtm1 NZ0034 2026-03-27T12:09:09.633Z 2026-04-04T12:41:25.370Z
9568155 9568155 20260323161630_ZXUyI NZ0034 2026-03-24T12:14:38.270Z 2026-03-31T12:28:23.777Z
9566799 9566799 20260323141513_g6NjD NZ0034 2026-03-24T12:12:27.591Z 2026-03-31T12:28:04.381Z
9566750 9566750 20260323140956_EfrCn NZ0034 2026-03-24T12:12:23.566Z 2026-03-31T12:27:56.422Z
9566705 9566705 20260323140640_oqjqe NZ0034 2026-03-24T12:12:20.876Z 2026-03-31T12:27:55.947Z
9566498 9566498 20260323134643_vxthx NZ0034 2026-03-24T12:11:58.556Z 2026-03-31T12:27:52.907Z
9566304 9566304 20260323132416_jxM9h NZ0034 2026-03-24T12:11:39.111Z 2026-03-31T12:27:48.588Z
9566164 9566164 20260323131019_8DGoe NZ0034 2026-03-24T12:11:24.894Z 2026-03-31T12:27:46.814Z
9566070 9566070 20260323130326_MpaaY NZ0034 2026-03-24T12:11:18.435Z 2026-03-31T12:27:45.732Z
9565966 9565966 20260323125518_Vcut4 NZ0034 2026-03-24T12:11:06.916Z 2026-03-31T12:27:44.106Z
9565231 9565231 20260323115214_beeN1 NZ0034 2026-03-24T12:09:41.321Z 2026-03-31T12:27:31.379Z
9565215 9565215 20260323115039_f9CyS NZ0034 2026-03-24T12:09:39.811Z 2026-03-31T12:27:31.133Z
9565118 9565118 20260323114522_FYf4Z NZ0034 2026-03-24T12:09:26.807Z 2026-03-31T12:27:23.177Z
9564609 9564609 20260323105539_hHw4P NZ0034 2026-03-24T12:08:27.332Z 2026-03-31T12:27:12.409Z
9564377 9564377 20260323102847_3H2xq NZ0034 2026-03-24T12:07:58.515Z 2026-03-31T12:27:08.219Z
9559333 9559333 20260321165728_WYby3 NZ0034 2026-03-23T12:11:01.944Z 2026-03-29T12:20:37.618Z

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