participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,375 rows where station_code = "NZ002Y" sorted by created_at descending
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 |
---|---|---|---|---|---|
5569077 | 5569077 | 20241121142724_sgQH2 | NZ002Y | 2024-11-22T14:10:17.306Z | 2024-11-22T14:10:17.306Z |
5569001 | 5569001 | 20241121141444_eYt2v | NZ002Y | 2024-11-22T14:10:10.028Z | 2024-11-22T14:10:10.028Z |
5568850 | 5568850 | 20241121135107_sgiSt | NZ002Y | 2024-11-22T14:09:59.620Z | 2024-11-22T14:09:59.620Z |
5560948 | 5560948 | 20241120152640_co8cH | NZ002Y | 2024-11-21T14:10:02.408Z | 2024-11-22T14:19:21.767Z |
5560856 | 5560856 | 20241120145357_kk5lE | NZ002Y | 2024-11-21T14:09:52.780Z | 2024-11-22T14:19:21.747Z |
5560687 | 5560687 | 20241120135605_EmGor | NZ002Y | 2024-11-21T14:09:26.643Z | 2024-11-22T14:19:21.713Z |
5551812 | 5551812 | 20241118151946_cEkK6 | NZ002Y | 2024-11-19T14:05:36.215Z | 2024-11-22T14:22:12.600Z |
5551773 | 5551773 | 20241118150832_4Vf3D | NZ002Y | 2024-11-19T14:05:28.892Z | 2024-11-22T14:22:12.460Z |
5551707 | 5551707 | 20241118145211_V9u91 | NZ002Y | 2024-11-19T14:05:16.514Z | 2024-11-22T14:22:12.210Z |
5551557 | 5551557 | 20241118141300_szHDa | NZ002Y | 2024-11-19T14:04:59.514Z | 2024-11-22T14:22:11.424Z |
5551503 | 5551503 | 20241118140043_rYtXK | NZ002Y | 2024-11-19T14:04:54.643Z | 2024-11-22T14:22:11.122Z |
5551493 | 5551493 | 20241118135748_qfztP | NZ002Y | 2024-11-19T14:04:53.439Z | 2024-11-22T14:22:11.036Z |
5551474 | 5551474 | 20241118135042_jz1ae | NZ002Y | 2024-11-19T14:04:51.247Z | 2024-11-22T14:22:10.917Z |
5551399 | 5551399 | 20241118132642_HfD83 | NZ002Y | 2024-11-19T14:04:44.249Z | 2024-11-22T14:22:10.518Z |
5550717 | 5550717 | 20241118111437_xi2Ef | NZ002Y | 2024-11-19T14:02:58.158Z | 2024-11-22T14:22:05.055Z |
5550523 | 5550523 | 20241118103835_93L7x | NZ002Y | 2024-11-19T14:02:30.244Z | 2024-11-22T14:22:03.745Z |
5550153 | 5550153 | 20241118094012_h5T7l | NZ002Y | 2024-11-19T14:01:39.583Z | 2024-11-22T14:21:59.005Z |
5547089 | 5547089 | 20241117144019_JdCFT | NZ002Y | 2024-11-18T14:04:56.908Z | 2024-11-22T14:22:36.811Z |
5546789 | 5546789 | 20241117124327_Of13k | NZ002Y | 2024-11-18T14:04:14.271Z | 2024-11-22T14:22:34.635Z |
5546498 | 5546498 | 20241117111701_zQgOL | NZ002Y | 2024-11-18T14:03:13.910Z | 2024-11-22T14:22:32.295Z |
5546427 | 5546427 | 20241117105532_34pqK | NZ002Y | 2024-11-18T14:03:05.836Z | 2024-11-22T14:22:31.959Z |
5546020 | 5546020 | 20241117085134_goiY0 | NZ002Y | 2024-11-18T14:01:44.362Z | 2024-11-22T14:22:28.147Z |
5544658 | 5544658 | 20241116135032_ya9f5 | NZ002Y | 2024-11-17T14:01:47.060Z | 2024-11-22T14:23:05.276Z |
5544655 | 5544655 | 20241116134948_EvYxx | NZ002Y | 2024-11-17T14:01:46.773Z | 2024-11-22T14:23:05.262Z |
5544615 | 5544615 | 20241116130931_yywO7 | NZ002Y | 2024-11-17T14:01:41.383Z | 2024-11-22T14:23:04.863Z |
5544597 | 5544597 | 20241116125248_HS38y | NZ002Y | 2024-11-17T14:01:38.546Z | 2024-11-22T14:23:04.771Z |
5544502 | 5544502 | 20241116115511_TTwiF | NZ002Y | 2024-11-17T14:01:19.013Z | 2024-11-22T14:23:03.526Z |
5544459 | 5544459 | 20241116112651_k3jiD | NZ002Y | 2024-11-17T14:01:13.664Z | 2024-11-22T14:23:03.002Z |
5544288 | 5544288 | 20241116093559_307MA | NZ002Y | 2024-11-17T14:00:46.117Z | 2024-11-22T14:23:01.349Z |
5536047 | 5536047 | 20241112152927_I8YI9 | NZ002Y | 2024-11-14T14:09:08.645Z | 2024-11-21T14:25:56.389Z |
5536035 | 5536035 | 20241112152806_iWmv0 | NZ002Y | 2024-11-14T14:09:07.922Z | 2024-11-21T14:25:56.219Z |
5536018 | 5536018 | 20241112152028_PBTiK | NZ002Y | 2024-11-14T14:09:06.651Z | 2024-11-21T14:25:56.138Z |
5535938 | 5535938 | 20241112145700_T2WAr | NZ002Y | 2024-11-14T14:09:00.520Z | 2024-11-21T14:25:54.934Z |
5535466 | 5535466 | 20241112123401_g5Rtl | NZ002Y | 2024-11-14T14:07:58.589Z | 2024-11-21T14:25:48.547Z |
5535092 | 5535092 | 20241112113606_RYipF | NZ002Y | 2024-11-14T14:07:13.330Z | 2024-11-21T14:25:43.848Z |
5535070 | 5535070 | 20241112113151_47dNb | NZ002Y | 2024-11-14T14:07:09.996Z | 2024-11-21T14:25:43.486Z |
5526697 | 5526697 | 20241112100324_2Ncsa | NZ002Y | 2024-11-13T14:03:57.247Z | 2024-11-21T14:25:37.292Z |
5514385 | 5514385 | 20241110154107_Bo1xd | NZ002Y | 2024-11-11T14:06:34.160Z | 2024-11-19T14:21:46.994Z |
5514270 | 5514270 | 20241110152057_eh1yj | NZ002Y | 2024-11-11T14:06:24.710Z | 2024-11-19T14:21:45.580Z |
5514257 | 5514257 | 20241110151851_wGZYe | NZ002Y | 2024-11-11T14:06:24.072Z | 2024-11-19T14:21:45.498Z |
5500030 | 5500030 | 20241108142906_DTiHO | NZ002Y | 2024-11-09T14:05:32.527Z | 2024-11-17T14:23:18.118Z |
5499951 | 5499951 | 20241108141235_MNT03 | NZ002Y | 2024-11-09T14:05:23.468Z | 2024-11-17T14:23:17.535Z |
5499462 | 5499462 | 20241108122240_Y3Mhs | NZ002Y | 2024-11-09T14:04:08.827Z | 2024-11-17T14:23:11.749Z |
5499218 | 5499218 | 20241108113637_GM2Qs | NZ002Y | 2024-11-09T14:03:33.687Z | 2024-11-17T14:23:07.838Z |
5499134 | 5499134 | 20241108111703_6Dq8T | NZ002Y | 2024-11-09T14:03:22.660Z | 2024-11-17T14:23:06.486Z |
5494020 | 5494020 | 20241107151306_36aIz | NZ002Y | 2024-11-08T14:05:16.026Z | 2024-11-16T14:27:45.291Z |
5493997 | 5493997 | 20241107150649_Zny1f | NZ002Y | 2024-11-08T14:05:13.817Z | 2024-11-16T14:27:44.543Z |
5493971 | 5493971 | 20241107145702_FT79b | NZ002Y | 2024-11-08T14:05:08.302Z | 2024-11-16T14:27:44.030Z |
5493957 | 5493957 | 20241107144830_sK29D | NZ002Y | 2024-11-08T14:05:04.045Z | 2024-11-16T14:27:43.635Z |
5493941 | 5493941 | 20241107144315_B1HCS | NZ002Y | 2024-11-08T14:05:01.050Z | 2024-11-16T14:27:43.528Z |
5493940 | 5493940 | 20241107144258_ojw2c | NZ002Y | 2024-11-08T14:05:00.600Z | 2024-11-16T14:27:43.508Z |
5493896 | 5493896 | 20241107142834_8BlMV | NZ002Y | 2024-11-08T14:04:50.090Z | 2024-11-16T14:27:42.871Z |
5493895 | 5493895 | 20241107142817_eZtma | NZ002Y | 2024-11-08T14:04:49.787Z | 2024-11-16T14:27:42.869Z |
5493853 | 5493853 | 20241107141514_lDTgt | NZ002Y | 2024-11-08T14:04:46.036Z | 2024-11-16T14:27:42.565Z |
5493846 | 5493846 | 20241107141126_r4hYU | NZ002Y | 2024-11-08T14:04:44.187Z | 2024-11-16T14:27:42.232Z |
5493818 | 5493818 | 20241107135652_L9IAT | NZ002Y | 2024-11-08T14:04:41.724Z | 2024-11-16T14:27:41.720Z |
5493802 | 5493802 | 20241107135243_DDGYb | NZ002Y | 2024-11-08T14:04:40.453Z | 2024-11-16T14:27:41.588Z |
5493794 | 5493794 | 20241107134936_7cAen | NZ002Y | 2024-11-08T14:04:39.833Z | 2024-11-16T14:27:41.547Z |
5493773 | 5493773 | 20241107133515_8sKVz | NZ002Y | 2024-11-08T14:04:37.702Z | 2024-11-16T14:27:40.924Z |
5493745 | 5493745 | 20241107131639_OTlai | NZ002Y | 2024-11-08T14:04:34.081Z | 2024-11-16T14:27:40.027Z |
5493740 | 5493740 | 20241107131353_yQlru | NZ002Y | 2024-11-08T14:04:33.523Z | 2024-11-16T14:27:39.730Z |
5493734 | 5493734 | 20241107131308_oAVCZ | NZ002Y | 2024-11-08T14:04:33.062Z | 2024-11-16T14:27:39.684Z |
5493618 | 5493618 | 20241107124519_TCYj7 | NZ002Y | 2024-11-08T14:04:19.040Z | 2024-11-16T14:27:37.453Z |
5493570 | 5493570 | 20241107123745_eNoaF | NZ002Y | 2024-11-08T14:04:06.994Z | 2024-11-16T14:27:36.291Z |
5493550 | 5493550 | 20241107123239_3ZvT2 | NZ002Y | 2024-11-08T14:04:02.840Z | 2024-11-16T14:27:35.767Z |
5493469 | 5493469 | 20241107121850_vd9uu | NZ002Y | 2024-11-08T14:03:50.820Z | 2024-11-16T14:27:34.629Z |
5493379 | 5493379 | 20241107120048_XXpGm | NZ002Y | 2024-11-08T14:03:39.375Z | 2024-11-16T14:27:33.881Z |
5493332 | 5493332 | 20241107115014_2xItF | NZ002Y | 2024-11-08T14:03:34.340Z | 2024-11-16T14:27:33.593Z |
5493262 | 5493262 | 20241107112923_m931v | NZ002Y | 2024-11-08T14:03:22.770Z | 2024-11-16T14:27:33.210Z |
5492807 | 5492807 | 20241107095810_HEbUJ | NZ002Y | 2024-11-08T14:02:08.054Z | 2024-11-16T14:27:29.193Z |
5492753 | 5492753 | 20241107095053_YkFRX | NZ002Y | 2024-11-08T14:02:02.065Z | 2024-11-16T14:27:28.621Z |
5492725 | 5492725 | 20241107094247_nA9PE | NZ002Y | 2024-11-08T14:01:58.530Z | 2024-11-16T14:27:27.822Z |
5492385 | 5492385 | 20241107082055_w3vdI | NZ002Y | 2024-11-08T14:00:58.165Z | 2024-11-16T14:27:24.598Z |
5492347 | 5492347 | 20241107081214_N7JPE | NZ002Y | 2024-11-08T14:00:50.514Z | 2024-11-16T14:27:24.352Z |
5474059 | 5474059 | 20241103154447_lh3Xl | NZ002Y | 2024-11-05T14:10:03.765Z | 2024-11-12T14:27:50.493Z |
5474025 | 5474025 | 20241103154102_H2YUe | NZ002Y | 2024-11-05T14:10:01.168Z | 2024-11-12T14:27:50.453Z |
5473791 | 5473791 | 20241103150352_LJnHS | NZ002Y | 2024-11-05T14:09:44.409Z | 2024-11-12T14:27:50.020Z |
5473683 | 5473683 | 20241103144855_ldAYp | NZ002Y | 2024-11-05T14:09:24.079Z | 2024-11-12T14:27:49.910Z |
5473493 | 5473493 | 20241103142408_Zo2g2 | NZ002Y | 2024-11-05T14:09:00.205Z | 2024-11-12T14:27:49.656Z |
5473310 | 5473310 | 20241103135938_RL2zv | NZ002Y | 2024-11-05T14:08:46.927Z | 2024-11-12T14:27:48.447Z |
5473304 | 5473304 | 20241103135534_evrmL | NZ002Y | 2024-11-05T14:08:46.264Z | 2024-11-12T14:27:48.433Z |
5473261 | 5473261 | 20241103135102_JnXKE | NZ002Y | 2024-11-05T14:08:43.048Z | 2024-11-12T14:27:48.312Z |
5473085 | 5473085 | 20241103132645_INYB4 | NZ002Y | 2024-11-05T14:08:13.344Z | 2024-11-12T14:27:47.843Z |
5472924 | 5472924 | 20241103130009_hweqZ | NZ002Y | 2024-11-05T14:07:52.423Z | 2024-11-12T14:27:46.997Z |
5472776 | 5472776 | 20241103123600_OpG4t | NZ002Y | 2024-11-05T14:07:41.404Z | 2024-11-12T14:27:46.595Z |
5472725 | 5472725 | 20241103123038_9zUok | NZ002Y | 2024-11-05T14:07:37.476Z | 2024-11-12T14:27:46.459Z |
5472537 | 5472537 | 20241104153607_rDE0E | NZ002Y | 2024-11-05T14:06:07.270Z | 2024-11-13T14:27:26.432Z |
5472521 | 5472521 | 20241104153320_PRWl1 | NZ002Y | 2024-11-05T14:06:03.602Z | 2024-11-13T14:27:26.404Z |
5472479 | 5472479 | 20241104151501_jf1sU | NZ002Y | 2024-11-05T14:05:54.259Z | 2024-11-13T14:27:26.338Z |
5472432 | 5472432 | 20241104150324_xu35Z | NZ002Y | 2024-11-05T14:05:49.362Z | 2024-11-13T14:27:26.268Z |
5472429 | 5472429 | 20241104150240_JciRs | NZ002Y | 2024-11-05T14:05:48.985Z | 2024-11-13T14:27:26.264Z |
5472384 | 5472384 | 20241104145410_5uNaJ | NZ002Y | 2024-11-05T14:05:44.036Z | 2024-11-13T14:27:26.234Z |
5472361 | 5472361 | 20241104144828_nWD8Y | NZ002Y | 2024-11-05T14:05:41.628Z | 2024-11-13T14:27:26.193Z |
5472326 | 5472326 | 20241104143920_WDB50 | NZ002Y | 2024-11-05T14:05:38.401Z | 2024-11-13T14:27:26.146Z |
5472318 | 5472318 | 20241104143811_wROl1 | NZ002Y | 2024-11-05T14:05:37.806Z | 2024-11-13T14:27:26.130Z |
5472310 | 5472310 | 20241104143642_t8i2l | NZ002Y | 2024-11-05T14:05:37.248Z | 2024-11-13T14:27:26.128Z |
5472270 | 5472270 | 20241104142146_ZtmHK | NZ002Y | 2024-11-05T14:05:33.344Z | 2024-11-13T14:27:26.044Z |
5472261 | 5472261 | 20241104141851_2Tk8U | NZ002Y | 2024-11-05T14:05:32.377Z | 2024-11-13T14:27:26.022Z |
5472256 | 5472256 | 20241104141526_U8ttA | NZ002Y | 2024-11-05T14:05:31.719Z | 2024-11-13T14:27:25.989Z |
5472171 | 5472171 | 20241104135857_j9BtL | NZ002Y | 2024-11-05T14:05:22.724Z | 2024-11-13T14:27:25.825Z |
Advanced export
JSON shape: default, array, newline-delimited
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);