participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,386 rows where station_code = "NZ001P" 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 |
---|---|---|---|---|---|
5135555 | 5135555 | 20240915155507_33Ds9 | NZ001P | 2024-09-19T12:19:33.143Z | 2024-09-19T12:19:33.143Z |
5110386 | 5110386 | 20240911160223_53VEH | NZ001P | 2024-09-17T12:15:52.762Z | 2024-09-19T12:21:01.056Z |
5095378 | 5095378 | 20240912072327_IHsPG | NZ001P | 2024-09-16T12:15:37.959Z | 2024-09-19T12:21:18.376Z |
5083639 | 5083639 | 20240911140255_lcEbS | NZ001P | 2024-09-15T12:18:44.975Z | 2024-09-19T12:21:49.744Z |
5083459 | 5083459 | 20240911132553_fsly3 | NZ001P | 2024-09-15T12:18:42.281Z | 2024-09-19T12:21:49.591Z |
5083382 | 5083382 | 20240911130718_QVgLe | NZ001P | 2024-09-15T12:18:40.622Z | 2024-09-19T12:21:49.536Z |
5083191 | 5083191 | 20240911122151_rjdEH | NZ001P | 2024-09-15T12:18:36.667Z | 2024-09-19T12:21:49.370Z |
5083160 | 5083160 | 20240911121545_dEeUt | NZ001P | 2024-09-15T12:18:36.418Z | 2024-09-19T12:21:49.362Z |
5083135 | 5083135 | 20240911121420_l1xvU | NZ001P | 2024-09-15T12:18:36.137Z | 2024-09-19T12:21:49.356Z |
5083024 | 5083024 | 20240911114850_z2HZH | NZ001P | 2024-09-15T12:18:33.791Z | 2024-09-19T12:21:49.142Z |
5082642 | 5082642 | 20240911103914_zoNsv | NZ001P | 2024-09-15T12:18:21.666Z | 2024-09-19T12:21:48.288Z |
5082392 | 5082392 | 20240911100219_iSyV2 | NZ001P | 2024-09-15T12:18:13.174Z | 2024-09-19T12:21:47.939Z |
5082231 | 5082231 | 20240911094154_4uK0C | NZ001P | 2024-09-15T12:18:08.792Z | 2024-09-19T12:21:47.541Z |
5071527 | 5071527 | 20240911171206_ZE9Tb | NZ001P | 2024-09-15T12:02:49.190Z | 2024-09-19T12:21:02.059Z |
5071470 | 5071470 | 20240911165952_im3ZG | NZ001P | 2024-09-15T12:02:38.754Z | 2024-09-19T12:21:01.980Z |
5071193 | 5071193 | 20240911161321_hBZOx | NZ001P | 2024-09-15T12:01:52.256Z | 2024-09-19T12:21:01.196Z |
5071138 | 5071138 | 20240911160332_HUlVE | NZ001P | 2024-09-15T12:01:45.953Z | 2024-09-19T12:21:01.079Z |
5071126 | 5071126 | 20240911160219_pZ5b4 | NZ001P | 2024-09-15T12:01:45.231Z | 2024-09-19T12:21:01.050Z |
5071009 | 5071009 | 20240911154135_1xyg1 | NZ001P | 2024-09-15T12:01:21.212Z | 2024-09-19T12:21:00.734Z |
5070802 | 5070802 | 20240911151123_FI0Ja | NZ001P | 2024-09-15T12:00:54.080Z | 2024-09-19T12:21:00.314Z |
5070624 | 5070624 | 20240911144234_m20Qk | NZ001P | 2024-09-15T12:00:25.660Z | 2024-09-19T12:20:59.454Z |
5059049 | 5059049 | 20240910170907_HfvqL | NZ001P | 2024-09-14T12:05:08.793Z | 2024-09-19T12:21:30.324Z |
5058910 | 5058910 | 20240910165838_RS3RO | NZ001P | 2024-09-14T12:04:49.735Z | 2024-09-19T12:21:30.227Z |
5058849 | 5058849 | 20240910165259_75Scn | NZ001P | 2024-09-14T12:04:39.285Z | 2024-09-19T12:21:30.173Z |
5058533 | 5058533 | 20240910162056_siDbn | NZ001P | 2024-09-14T12:03:52.753Z | 2024-09-19T12:21:29.678Z |
5058453 | 5058453 | 20240910161329_ANk2u | NZ001P | 2024-09-14T12:03:44.072Z | 2024-09-19T12:21:29.634Z |
5058254 | 5058254 | 20240910155927_Y0cjK | NZ001P | 2024-09-14T12:03:17.056Z | 2024-09-19T12:21:29.394Z |
5057901 | 5057901 | 20240910152407_lHGZY | NZ001P | 2024-09-14T12:02:22.126Z | 2024-09-19T12:21:28.917Z |
5057898 | 5057898 | 20240910152352_fNPZz | NZ001P | 2024-09-14T12:02:21.577Z | 2024-09-19T12:21:28.916Z |
5057586 | 5057586 | 20240910145256_phOTG | NZ001P | 2024-09-14T12:01:29.221Z | 2024-09-19T12:21:28.416Z |
5057085 | 5057085 | 20240908121028_2Xt9J | NZ001P | 2024-09-13T12:17:44.598Z | 2024-09-16T12:21:28.760Z |
5056591 | 5056591 | 20240908104844_0Ry3z | NZ001P | 2024-09-13T12:17:36.019Z | 2024-09-16T12:21:26.049Z |
5056323 | 5056323 | 20240908101215_DtW67 | NZ001P | 2024-09-13T12:17:30.329Z | 2024-09-16T12:21:24.432Z |
5056072 | 5056072 | 20240908093702_yeOE7 | NZ001P | 2024-09-13T12:17:27.330Z | 2024-09-16T12:21:23.136Z |
5055611 | 5055611 | 20240908082907_nhMR3 | NZ001P | 2024-09-13T12:17:18.773Z | 2024-09-16T12:21:21.177Z |
5055483 | 5055483 | 20240908081007_CBZVg | NZ001P | 2024-09-13T12:17:15.251Z | 2024-09-16T12:21:19.951Z |
5051185 | 5051185 | 20240907165750_OGFdd | NZ001P | 2024-09-13T12:14:05.231Z | 2024-09-16T12:20:59.785Z |
5051135 | 5051135 | 20240907165258_1M0fK | NZ001P | 2024-09-13T12:14:03.483Z | 2024-09-16T12:20:59.637Z |
5051099 | 5051099 | 20240907164745_y1R7l | NZ001P | 2024-09-13T12:14:01.751Z | 2024-09-16T12:20:59.583Z |
5050464 | 5050464 | 20240907152331_Ybno6 | NZ001P | 2024-09-13T12:13:32.720Z | 2024-09-16T12:20:57.730Z |
5050371 | 5050371 | 20240907151449_MD5yK | NZ001P | 2024-09-13T12:13:28.956Z | 2024-09-16T12:20:57.386Z |
5050293 | 5050293 | 20240907150453_dZbm8 | NZ001P | 2024-09-13T12:13:22.906Z | 2024-09-16T12:20:56.961Z |
5045552 | 5045552 | 20240908172038_2Wwht | NZ001P | 2024-09-13T12:04:19.311Z | 2024-09-17T12:18:56.767Z |
5045336 | 5045336 | 20240908165302_5C37m | NZ001P | 2024-09-13T12:04:00.473Z | 2024-09-17T12:18:56.379Z |
5045275 | 5045275 | 20240908164852_Za6bf | NZ001P | 2024-09-13T12:03:50.182Z | 2024-09-17T12:18:56.328Z |
5045216 | 5045216 | 20240908163543_Igvyg | NZ001P | 2024-09-13T12:03:43.059Z | 2024-09-17T12:18:56.060Z |
5044884 | 5044884 | 20240908155250_LUNbY | NZ001P | 2024-09-13T12:03:06.982Z | 2024-09-17T12:18:55.346Z |
5044119 | 5044119 | 20240908141545_wR0iB | NZ001P | 2024-09-13T12:01:30.673Z | 2024-09-17T12:18:53.565Z |
5043958 | 5043958 | 20240908134136_VVWTX | NZ001P | 2024-09-13T12:01:03.766Z | 2024-09-17T12:18:53.128Z |
5042253 | 5042253 | 20240906101538_2uazO | NZ001P | 2024-09-12T12:16:58.430Z | 2024-09-14T12:23:16.671Z |
5038048 | 5038048 | 20240905171743_1Zf2a | NZ001P | 2024-09-12T12:14:20.969Z | 2024-09-14T12:22:54.995Z |
5037658 | 5037658 | 20240905162914_WTJcS | NZ001P | 2024-09-12T12:14:13.475Z | 2024-09-14T12:22:54.487Z |
5037437 | 5037437 | 20240905155518_YRpIw | NZ001P | 2024-09-12T12:14:06.568Z | 2024-09-14T12:22:54.192Z |
5037402 | 5037402 | 20240905155140_rVsUG | NZ001P | 2024-09-12T12:14:06.289Z | 2024-09-14T12:22:54.182Z |
5037273 | 5037273 | 20240905153035_p4dQc | NZ001P | 2024-09-12T12:14:04.085Z | 2024-09-14T12:22:54.068Z |
5037249 | 5037249 | 20240905152829_kNAkh | NZ001P | 2024-09-12T12:14:03.854Z | 2024-09-14T12:22:54.021Z |
5037209 | 5037209 | 20240905152100_5HZqb | NZ001P | 2024-09-12T12:14:02.951Z | 2024-09-14T12:22:53.960Z |
5036951 | 5036951 | 20240905144802_5ojbl | NZ001P | 2024-09-12T12:13:57.966Z | 2024-09-14T12:22:53.580Z |
5036797 | 5036797 | 20240905142759_g3kTo | NZ001P | 2024-09-12T12:13:54.983Z | 2024-09-14T12:22:53.281Z |
5036714 | 5036714 | 20240905142000_xvkIA | NZ001P | 2024-09-12T12:13:52.901Z | 2024-09-14T12:22:53.118Z |
5036508 | 5036508 | 20240905134009_KlMUU | NZ001P | 2024-09-12T12:13:44.547Z | 2024-09-14T12:22:52.511Z |
5036460 | 5036460 | 20240905133728_i7th2 | NZ001P | 2024-09-12T12:13:43.095Z | 2024-09-14T12:22:52.480Z |
5036436 | 5036436 | 20240905133404_N3KYo | NZ001P | 2024-09-12T12:13:41.934Z | 2024-09-14T12:22:52.460Z |
5036093 | 5036093 | 20240905123917_OyZpG | NZ001P | 2024-09-12T12:13:23.393Z | 2024-09-14T12:22:51.852Z |
5035982 | 5035982 | 20240905122123_g4rl7 | NZ001P | 2024-09-12T12:13:15.774Z | 2024-09-14T12:22:51.696Z |
5030328 | 5030328 | 20240906145418_e1bka | NZ001P | 2024-09-12T12:01:43.060Z | 2024-09-15T12:21:18.432Z |
5030322 | 5030322 | 20240906145149_sbLim | NZ001P | 2024-09-12T12:01:42.759Z | 2024-09-15T12:21:18.431Z |
5030319 | 5030319 | 20240906144948_jxzcn | NZ001P | 2024-09-12T12:01:42.452Z | 2024-09-15T12:21:18.428Z |
5029886 | 5029886 | 20240906114335_C1KEi | NZ001P | 2024-09-12T12:00:45.767Z | 2024-09-15T12:21:17.451Z |
5029324 | 5029324 | 20240905115553_pdloj | NZ001P | 2024-09-11T12:16:26.496Z | 2024-09-14T12:22:51.384Z |
5029011 | 5029011 | 20240905111915_aB2yq | NZ001P | 2024-09-11T12:16:06.371Z | 2024-09-14T12:22:50.403Z |
5028922 | 5028922 | 20240905110805_nZoxv | NZ001P | 2024-09-11T12:16:01.668Z | 2024-09-14T12:22:50.041Z |
5028660 | 5028660 | 20240905103551_LPhmB | NZ001P | 2024-09-11T12:15:41.214Z | 2024-09-14T12:22:48.751Z |
5028041 | 5028041 | 20240905085603_2nGl0 | NZ001P | 2024-09-11T12:14:45.866Z | 2024-09-13T12:20:05.211Z |
5027600 | 5027600 | 20240905075904_sx1Da | NZ001P | 2024-09-11T12:14:19.534Z | 2024-09-13T12:20:03.968Z |
5023887 | 5023887 | 20240905171743_Awxpz | NZ001P | 2024-09-10T12:16:51.507Z | 2024-09-11T12:16:31.831Z |
5023633 | 5023633 | 20240905165112_GLgeh | NZ001P | 2024-09-10T12:16:48.543Z | 2024-09-11T12:16:31.729Z |
5023516 | 5023516 | 20240905162914_SUfbr | NZ001P | 2024-09-10T12:16:46.968Z | 2024-09-11T12:16:31.688Z |
5023311 | 5023311 | 20240905155518_2IYp0 | NZ001P | 2024-09-10T12:16:43.275Z | 2024-09-14T12:22:54.194Z |
5023283 | 5023283 | 20240905155140_zSP3X | NZ001P | 2024-09-10T12:16:42.730Z | 2024-09-11T12:16:31.613Z |
5023155 | 5023155 | 20240905153035_TZBHh | NZ001P | 2024-09-10T12:16:39.747Z | 2024-09-11T12:16:31.555Z |
5023133 | 5023133 | 20240905152829_EJJMn | NZ001P | 2024-09-10T12:16:39.598Z | 2024-09-14T12:22:54.020Z |
5023096 | 5023096 | 20240905152100_CQA2C | NZ001P | 2024-09-10T12:16:38.936Z | 2024-09-11T12:16:31.529Z |
5022481 | 5022481 | 20240905085602_n33Jy | NZ001P | 2024-09-10T12:16:20.174Z | 2024-09-13T12:20:05.189Z |
5022041 | 5022041 | 20240905075904_hpIl2 | NZ001P | 2024-09-10T12:16:02.605Z | 2024-09-13T12:20:03.975Z |
5018132 | 5018132 | 20240904171327_tSHMV | NZ001P | 2024-09-10T12:10:02.825Z | 2024-09-13T12:19:47.248Z |
5018055 | 5018055 | 20240904170814_d6CGg | NZ001P | 2024-09-10T12:09:56.780Z | 2024-09-13T12:19:47.178Z |
5018014 | 5018014 | 20240904170544_rVudu | NZ001P | 2024-09-10T12:09:53.475Z | 2024-09-13T12:19:47.161Z |
5017970 | 5017970 | 20240904170107_AE4Pg | NZ001P | 2024-09-10T12:09:48.929Z | 2024-09-13T12:19:47.148Z |
5017945 | 5017945 | 20240904165637_K6H4d | NZ001P | 2024-09-10T12:09:46.916Z | 2024-09-13T12:19:47.138Z |
5017687 | 5017687 | 20240904163259_VGFT9 | NZ001P | 2024-09-10T12:09:23.784Z | 2024-09-13T12:19:47.055Z |
5017536 | 5017536 | 20240904161710_Y3b68 | NZ001P | 2024-09-10T12:09:14.383Z | 2024-09-13T12:19:46.905Z |
5017396 | 5017396 | 20240904160452_v2q3L | NZ001P | 2024-09-10T12:09:08.015Z | 2024-09-13T12:19:46.844Z |
5017038 | 5017038 | 20240904152542_aYP08 | NZ001P | 2024-09-10T12:08:41.460Z | 2024-09-13T12:19:46.513Z |
5017026 | 5017026 | 20240904152342_ypniq | NZ001P | 2024-09-10T12:08:40.525Z | 2024-09-13T12:19:46.502Z |
5016934 | 5016934 | 20240904151238_A5GUW | NZ001P | 2024-09-10T12:08:33.473Z | 2024-09-13T12:19:46.455Z |
5016735 | 5016735 | 20240904144903_Y9vn7 | NZ001P | 2024-09-10T12:08:13.684Z | 2024-09-13T12:19:46.249Z |
5016514 | 5016514 | 20240904142217_G86GE | NZ001P | 2024-09-10T12:07:55.236Z | 2024-09-13T12:19:45.829Z |
5015243 | 5015243 | 20240905144802_Oyvib | NZ001P | 2024-09-10T12:04:46.766Z | 2024-09-14T12:22:53.581Z |
5015100 | 5015100 | 20240905142759_fqOYo | NZ001P | 2024-09-10T12:04:31.492Z | 2024-09-11T12:16:31.379Z |
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);