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 = "NZ004J" 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
9610291 9610291 20260405155437_OLEea NZ004J 2026-04-06T12:06:53.545Z 2026-04-08T12:26:36.709Z
9610245 9610245 20260405151744_MJLfx NZ004J 2026-04-06T12:06:35.694Z 2026-04-08T12:26:34.024Z
9610163 9610163 20260405140355_tA1gt NZ004J 2026-04-06T12:06:07.330Z 2026-04-08T12:26:28.717Z
9610133 9610133 20260405133232_SUgY5 NZ004J 2026-04-06T12:05:58.529Z 2026-04-08T12:26:27.010Z
9610097 9610097 20260405125802_bM1ME NZ004J 2026-04-06T12:05:47.765Z 2026-04-08T12:26:24.413Z
9606336 9606336 20260403171144_8oAJb NZ004J 2026-04-04T12:06:29.903Z 2026-04-08T12:34:13.918Z
9606319 9606319 20260403170354_ujVnU NZ004J 2026-04-04T12:06:22.637Z 2026-04-08T12:34:03.585Z
9606293 9606293 20260403165908_Tlm6P NZ004J 2026-04-04T12:06:16.938Z 2026-04-08T12:34:02.580Z
9606263 9606263 20260403164328_koVO0 NZ004J 2026-04-04T12:06:12.120Z 2026-04-08T12:34:01.609Z
9606250 9606250 20260403163724_K7NFV NZ004J 2026-04-04T12:06:09.597Z 2026-04-08T12:34:01.070Z
9606142 9606142 20260403153907_lmBuh NZ004J 2026-04-04T12:05:35.261Z 2026-04-08T12:33:53.769Z
9603499 9603499 20260402103724_7h04t NZ004J 2026-04-03T12:03:15.502Z 2026-04-08T12:36:11.139Z
9601464 9601464 20260401152406_d21ba NZ004J 2026-04-02T12:02:51.699Z 2026-04-08T12:38:28.093Z
9601343 9601343 20260401143442_HZ8NF NZ004J 2026-04-02T12:02:29.068Z 2026-04-08T12:38:10.185Z
9600190 9600190 20260330123448_lZkxF NZ004J 2026-04-01T12:08:08.473Z 2026-04-08T12:43:00.565Z
9599440 9599440 20260331143915_sKKDN NZ004J 2026-04-01T12:03:37.166Z 2026-04-08T12:40:39.233Z
9599431 9599431 20260331143700_62i42 NZ004J 2026-04-01T12:03:34.432Z 2026-04-08T12:40:38.411Z
9599266 9599266 20260331132957_Fr4Pi NZ004J 2026-04-01T12:02:57.568Z 2026-04-08T12:40:10.090Z
9599245 9599245 20260331131041_3mqBU NZ004J 2026-04-01T12:02:52.333Z 2026-04-08T12:40:09.207Z
9599072 9599072 20260331112938_kHzNC NZ004J 2026-04-01T12:02:15.297Z 2026-04-08T12:40:03.198Z
9598049 9598049 20260330173507_lWfdb NZ004J 2026-03-31T12:07:30.277Z 2026-04-08T12:44:24.254Z
9597922 9597922 20260330171512_kyPtt NZ004J 2026-03-31T12:07:17.125Z 2026-04-08T12:44:20.666Z
9597910 9597910 20260330171448_DzoWv NZ004J 2026-03-31T12:07:15.585Z 2026-04-08T12:44:20.385Z
9597905 9597905 20260330171413_TtYlm NZ004J 2026-03-31T12:07:14.737Z 2026-04-08T12:44:20.207Z
9597882 9597882 20260330171157_PqQfh NZ004J 2026-03-31T12:07:10.671Z 2026-04-08T12:44:19.759Z
9597763 9597763 20260330165658_XrCpV NZ004J 2026-03-31T12:06:58.458Z 2026-04-08T12:44:16.729Z
9597731 9597731 20260330165506_20gYf NZ004J 2026-03-31T12:06:56.329Z 2026-04-08T12:44:16.305Z
9597553 9597553 20260330163540_x0QME NZ004J 2026-03-31T12:06:37.825Z 2026-04-08T12:43:49.516Z
9596913 9596913 20260330143157_Erm16 NZ004J 2026-03-31T12:05:15.064Z 2026-04-08T12:43:27.766Z
9596797 9596797 20260330140409_Qf4fS NZ004J 2026-03-31T12:04:58.702Z 2026-04-08T12:43:24.782Z
9596578 9596578 20260330131622_0WSd0 NZ004J 2026-03-31T12:04:32.394Z 2026-04-08T12:43:19.861Z
9596343 9596343 20260330122042_Mmq3a NZ004J 2026-03-31T12:04:04.077Z 2026-04-08T12:42:50.069Z
9596217 9596217 20260330114820_3tQpJ NZ004J 2026-03-31T12:03:45.402Z 2026-04-08T12:42:44.347Z
9596181 9596181 20260330113913_ukE0Z NZ004J 2026-03-31T12:03:40.630Z 2026-04-08T12:42:43.447Z
9596145 9596145 20260330112448_WMeET NZ004J 2026-03-31T12:03:35.704Z 2026-04-08T12:42:42.459Z
9591596 9591596 20260328172436_z8QON NZ004J 2026-03-29T12:04:40.805Z 2026-04-06T12:39:24.866Z
9591554 9591554 20260328170802_7kxcb NZ004J 2026-03-29T12:04:36.091Z 2026-04-06T12:39:22.645Z
9591539 9591539 20260328170358_7DWjY NZ004J 2026-03-29T12:04:33.725Z 2026-04-06T12:39:22.009Z
9591422 9591422 20260328162649_SXgql NZ004J 2026-03-29T12:04:23.372Z 2026-04-06T12:39:14.866Z
9591385 9591385 20260328161259_8d3aE NZ004J 2026-03-29T12:04:20.189Z 2026-04-06T12:39:13.377Z
9591354 9591354 20260328155009_4uZcQ NZ004J 2026-03-29T12:04:17.736Z 2026-04-06T12:39:12.132Z
9591338 9591338 20260328154456_sgSge NZ004J 2026-03-29T12:04:16.539Z 2026-04-06T12:39:11.485Z
9591327 9591327 20260328153657_7YmzC NZ004J 2026-03-29T12:04:15.173Z 2026-04-06T12:39:10.946Z
9591287 9591287 20260328151449_2Z6tA NZ004J 2026-03-29T12:04:09.845Z 2026-04-06T12:39:09.135Z
9591285 9591285 20260328151140_ssomT NZ004J 2026-03-29T12:04:09.596Z 2026-04-06T12:39:09.019Z
9591280 9591280 20260328150952_puL3M NZ004J 2026-03-29T12:04:09.467Z 2026-04-06T12:39:08.862Z
9591232 9591232 20260328144700_2XV2k NZ004J 2026-03-29T12:04:03.495Z 2026-04-06T12:39:06.616Z
9591216 9591216 20260328143437_6hrFQ NZ004J 2026-03-29T12:04:01.785Z 2026-04-06T12:39:05.910Z
9590979 9590979 20260328121044_NuBhc NZ004J 2026-03-29T12:03:34.794Z 2026-04-06T12:38:44.954Z
9590877 9590877 20260328113706_UNrV1 NZ004J 2026-03-29T12:03:25.753Z 2026-04-06T12:38:38.466Z
9590803 9590803 20260328112113_p4CBZ NZ004J 2026-03-29T12:03:18.520Z 2026-04-06T12:38:35.045Z
9590770 9590770 20260328111259_gDIr3 NZ004J 2026-03-29T12:03:16.590Z 2026-04-06T12:38:34.072Z
9590587 9590587 20260328101358_f9Qfq NZ004J 2026-03-29T12:02:57.771Z 2026-04-06T12:38:25.800Z
9590242 9590242 20260328074503_HWcyN NZ004J 2026-03-29T12:02:18.754Z 2026-04-06T12:37:58.010Z
9588006 9588006 20260327171737_kIs5j NZ004J 2026-03-28T12:06:54.178Z 2026-04-05T12:35:03.606Z
9587963 9587963 20260327170223_CVk4A NZ004J 2026-03-28T12:06:48.242Z 2026-04-05T12:35:01.524Z
9587855 9587855 20260327162826_AwNyn NZ004J 2026-03-28T12:06:35.193Z 2026-04-05T12:34:46.908Z
9587756 9587756 20260327153504_C7wUr NZ004J 2026-03-28T12:06:16.174Z 2026-04-05T12:34:40.434Z
9587752 9587752 20260327153451_GBAR7 NZ004J 2026-03-28T12:06:15.544Z 2026-04-05T12:34:39.866Z
9587710 9587710 20260327151457_rcYNz NZ004J 2026-03-28T12:06:10.911Z 2026-04-05T12:34:38.126Z
9587702 9587702 20260327151012_PKv2j NZ004J 2026-03-28T12:06:09.896Z 2026-04-05T12:34:37.802Z
9587675 9587675 20260327150156_e6BqO NZ004J 2026-03-28T12:06:06.453Z 2026-04-05T12:34:36.454Z
9587617 9587617 20260327143436_EQeK3 NZ004J 2026-03-28T12:05:55.659Z 2026-04-05T12:34:33.845Z
9587568 9587568 20260327141214_aoUsY NZ004J 2026-03-28T12:05:50.101Z 2026-04-05T12:34:31.874Z
9587532 9587532 20260327134527_iNUf8 NZ004J 2026-03-28T12:05:45.261Z 2026-04-05T12:34:30.226Z
9587486 9587486 20260327131959_s8DkV NZ004J 2026-03-28T12:05:39.009Z 2026-04-05T12:34:28.471Z
9587482 9587482 20260327131640_em6sC NZ004J 2026-03-28T12:05:38.325Z 2026-04-05T12:34:28.231Z
9587468 9587468 20260327130322_wsKF7 NZ004J 2026-03-28T12:05:34.293Z 2026-04-05T12:34:27.512Z
9587459 9587459 20260327130003_s7hHN NZ004J 2026-03-28T12:05:33.636Z 2026-04-05T12:34:27.282Z
9587442 9587442 20260327124902_FFYC1 NZ004J 2026-03-28T12:05:31.672Z 2026-04-05T12:34:26.586Z
9587434 9587434 20260327124614_MR9U7 NZ004J 2026-03-28T12:05:30.606Z 2026-04-05T12:34:26.331Z
9587420 9587420 20260327123815_kpt6z NZ004J 2026-03-28T12:05:28.458Z 2026-04-05T12:34:25.853Z
9587295 9587295 20260327120024_smkw3 NZ004J 2026-03-28T12:05:12.781Z 2026-04-05T12:34:11.819Z
9587259 9587259 20260327115628_zBLFu NZ004J 2026-03-28T12:05:09.226Z 2026-04-05T12:34:10.521Z
9586901 9586901 20260327101020_KLv2d NZ004J 2026-03-28T12:04:19.178Z 2026-04-05T12:33:53.507Z
9586866 9586866 20260327100156_8z4oz NZ004J 2026-03-28T12:04:15.249Z 2026-04-05T12:33:52.378Z
9583672 9583672 20260326170632_878rI NZ004J 2026-03-27T12:09:28.172Z 2026-04-04T12:41:30.593Z
9567016 9567016 20260323143207_wDMok NZ004J 2026-03-24T12:12:51.386Z 2026-03-31T12:28:07.192Z
9566993 9566993 20260323143142_cRYy8 NZ004J 2026-03-24T12:12:49.742Z 2026-03-31T12:28:06.968Z
9566952 9566952 20260323142955_1M6Vn NZ004J 2026-03-24T12:12:45.944Z 2026-03-24T12:24:25.186Z
9566911 9566911 20260323142424_Nfp9q NZ004J 2026-03-24T12:12:41.323Z 2026-03-31T12:28:05.941Z
9566608 9566608 20260323135654_jZLhc NZ004J 2026-03-24T12:12:11.944Z 2026-03-31T12:27:54.533Z
9566317 9566317 20260323132433_UI88L NZ004J 2026-03-24T12:11:40.039Z 2026-03-31T12:27:48.707Z
9566173 9566173 20260323131116_3aUV0 NZ004J 2026-03-24T12:11:25.292Z 2026-03-31T12:27:46.845Z
9566025 9566025 20260323125927_rm6WT NZ004J 2026-03-24T12:11:13.715Z 2026-03-31T12:27:44.953Z
9566020 9566020 20260323125845_rHEoK NZ004J 2026-03-24T12:11:13.109Z 2026-03-31T12:27:44.907Z
9565979 9565979 20260323125545_DsIcZ NZ004J 2026-03-24T12:11:07.582Z 2026-03-31T12:27:44.292Z
9565922 9565922 20260323125136_Ya1hC NZ004J 2026-03-24T12:11:01.660Z 2026-03-31T12:27:43.494Z
9565628 9565628 20260323122710_MQ4F9 NZ004J 2026-03-24T12:10:32.475Z 2026-03-31T12:27:38.701Z
9565228 9565228 20260323115211_lKlWk NZ004J 2026-03-24T12:09:40.914Z 2026-03-31T12:27:31.272Z
9565109 9565109 20260323114518_Mor4O NZ004J 2026-03-24T12:09:25.865Z 2026-03-31T12:27:23.049Z
9564307 9564307 20260323102300_8MCDr NZ004J 2026-03-24T12:07:50.694Z 2026-03-31T12:27:06.977Z
9559183 9559183 20260321164434_2uUDI NZ004J 2026-03-23T12:10:56.852Z 2026-03-29T12:20:34.988Z
9558907 9558907 20260321160332_F9r9K NZ004J 2026-03-23T12:10:39.361Z 2026-03-29T12:20:31.600Z
9558829 9558829 20260321155018_MFq0M NZ004J 2026-03-23T12:10:35.842Z 2026-03-29T12:20:30.564Z
9558819 9558819 20260321154935_zfleO NZ004J 2026-03-23T12:10:34.628Z 2026-03-29T12:20:30.415Z
9558692 9558692 20260322172835_RqpX2 NZ004J 2026-03-23T12:06:54.721Z 2026-03-30T12:30:20.448Z
9558195 9558195 20260322160644_O4qw2 NZ004J 2026-03-23T12:06:29.106Z 2026-03-30T12:30:07.566Z
9558191 9558191 20260322160330_h63Cj NZ004J 2026-03-23T12:06:28.882Z 2026-03-30T12:30:07.288Z
9557734 9557734 20260322144846_FiiIH NZ004J 2026-03-23T12:06:07.649Z 2026-03-30T12:29:46.391Z

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