participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,248 rows where station_code = "NZ0020" 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 |
---|---|---|---|---|---|
5123539 | 5123539 | 20240914102551_xcOsX | NZ0020 | 2024-09-18T12:11:51.121Z | 2024-09-18T12:12:28.811Z |
5083694 | 5083694 | 20240911141235_SrTHt | NZ0020 | 2024-09-15T12:18:45.592Z | 2024-09-18T12:15:04.550Z |
5083661 | 5083661 | 20240911140652_e76eO | NZ0020 | 2024-09-15T12:18:45.170Z | 2024-09-18T12:15:04.485Z |
5083404 | 5083404 | 20240911130940_3AZ5J | NZ0020 | 2024-09-15T12:18:40.765Z | 2024-09-18T12:15:03.702Z |
5083292 | 5083292 | 20240911124854_bEO5H | NZ0020 | 2024-09-15T12:18:38.516Z | 2024-09-18T12:15:03.277Z |
5071666 | 5071666 | 20240911174142_oxqk0 | NZ0020 | 2024-09-15T12:03:12.414Z | 2024-09-18T12:13:39.721Z |
5071577 | 5071577 | 20240911171853_c5uB0 | NZ0020 | 2024-09-15T12:03:00.232Z | 2024-09-18T12:13:39.207Z |
5071564 | 5071564 | 20240911171658_8JeCJ | NZ0020 | 2024-09-15T12:02:58.815Z | 2024-09-18T12:13:39.192Z |
5071443 | 5071443 | 20240911165627_D08VX | NZ0020 | 2024-09-15T12:02:33.502Z | 2024-09-18T12:13:38.772Z |
5071419 | 5071419 | 20240911164817_ig2eU | NZ0020 | 2024-09-15T12:02:29.541Z | 2024-09-18T12:13:38.755Z |
5071400 | 5071400 | 20240911164604_Ld6k7 | NZ0020 | 2024-09-15T12:02:27.719Z | 2024-09-18T12:13:38.700Z |
5071052 | 5071052 | 20240911155204_mHIL6 | NZ0020 | 2024-09-15T12:01:31.177Z | 2024-09-18T12:13:37.451Z |
5070854 | 5070854 | 20240911151816_Ppycn | NZ0020 | 2024-09-15T12:01:00.817Z | 2024-09-18T12:13:36.446Z |
5070820 | 5070820 | 20240911151323_2rTVS | NZ0020 | 2024-09-15T12:00:56.958Z | 2024-09-18T12:13:36.265Z |
5070668 | 5070668 | 20240911145029_k3Z0r | NZ0020 | 2024-09-15T12:00:29.631Z | 2024-09-18T12:13:35.845Z |
5070506 | 5070506 | 20240911142354_AYILy | NZ0020 | 2024-09-15T12:00:10.447Z | 2024-09-18T12:13:35.398Z |
5068935 | 5068935 | 20240910130705_2382d | NZ0020 | 2024-09-14T12:19:23.047Z | 2024-09-18T12:15:26.866Z |
5068886 | 5068886 | 20240910125515_63LZ7 | NZ0020 | 2024-09-14T12:19:22.593Z | 2024-09-18T12:15:26.784Z |
5068874 | 5068874 | 20240910125449_hFprc | NZ0020 | 2024-09-14T12:19:22.473Z | 2024-09-18T12:15:26.779Z |
5068737 | 5068737 | 20240910121239_tgb1I | NZ0020 | 2024-09-14T12:19:20.922Z | 2024-09-18T12:15:26.573Z |
5068711 | 5068711 | 20240910120810_qbbOr | NZ0020 | 2024-09-14T12:19:20.583Z | 2024-09-18T12:15:26.522Z |
5068704 | 5068704 | 20240910120624_PFiJb | NZ0020 | 2024-09-14T12:19:20.461Z | 2024-09-18T12:15:26.502Z |
5068615 | 5068615 | 20240910115521_L124d | NZ0020 | 2024-09-14T12:19:19.512Z | 2024-09-18T12:15:26.404Z |
5067921 | 5067921 | 20240910103128_X2c1F | NZ0020 | 2024-09-14T12:19:04.684Z | 2024-09-18T12:15:25.093Z |
5067705 | 5067705 | 20240910100246_AmcXG | NZ0020 | 2024-09-14T12:18:54.468Z | 2024-09-18T12:15:24.740Z |
5066681 | 5066681 | 20240910080326_h1nnp | NZ0020 | 2024-09-14T12:18:07.338Z | 2024-09-18T12:15:22.433Z |
5062420 | 5062420 | 20240909172239_132qM | NZ0020 | 2024-09-14T12:12:19.020Z | 2024-09-18T12:15:11.317Z |
5062414 | 5062414 | 20240909172211_JUe3W | NZ0020 | 2024-09-14T12:12:18.806Z | 2024-09-18T12:15:11.314Z |
5062409 | 5062409 | 20240909172157_Ajwp3 | NZ0020 | 2024-09-14T12:12:18.630Z | 2024-09-18T12:15:11.307Z |
5062401 | 5062401 | 20240909172136_fB3Wj | NZ0020 | 2024-09-14T12:12:18.185Z | 2024-09-18T12:15:11.305Z |
5062257 | 5062257 | 20240909170428_JRkH6 | NZ0020 | 2024-09-14T12:12:01.797Z | 2024-09-18T12:15:10.823Z |
5062230 | 5062230 | 20240909170103_vzGfK | NZ0020 | 2024-09-14T12:11:57.346Z | 2024-09-18T12:15:10.770Z |
5062110 | 5062110 | 20240909164442_Q7y1b | NZ0020 | 2024-09-14T12:11:49.551Z | 2024-09-18T12:15:10.389Z |
5062027 | 5062027 | 20240909163424_DFaTZ | NZ0020 | 2024-09-14T12:11:45.487Z | 2024-09-18T12:15:10.327Z |
5061950 | 5061950 | 20240909162634_Tm26v | NZ0020 | 2024-09-14T12:11:41.209Z | 2024-09-18T12:15:10.209Z |
5061779 | 5061779 | 20240909155916_SMvn2 | NZ0020 | 2024-09-14T12:11:24.058Z | 2024-09-18T12:15:09.978Z |
5061419 | 5061419 | 20240909150454_2TDy8 | NZ0020 | 2024-09-14T12:10:49.011Z | 2024-09-18T12:15:09.180Z |
5061094 | 5061094 | 20240909141521_2ABcx | NZ0020 | 2024-09-14T12:10:15.386Z | 2024-09-18T12:15:08.169Z |
5060909 | 5060909 | 20240909131941_MW03w | NZ0020 | 2024-09-14T12:09:55.089Z | 2024-09-18T12:15:07.276Z |
5059375 | 5059375 | 20240910173517_92TFQ | NZ0020 | 2024-09-14T12:05:49.383Z | 2024-09-18T12:14:31.727Z |
5059337 | 5059337 | 20240910173245_2vcbr | NZ0020 | 2024-09-14T12:05:46.653Z | 2024-09-18T12:14:31.670Z |
5059194 | 5059194 | 20240910172158_Kuytc | NZ0020 | 2024-09-14T12:05:25.458Z | 2024-09-18T12:14:31.376Z |
5059077 | 5059077 | 20240910171050_pnu0T | NZ0020 | 2024-09-14T12:05:12.192Z | 2024-09-18T12:14:31.187Z |
5058696 | 5058696 | 20240910163806_bPqDZ | NZ0020 | 2024-09-14T12:04:20.570Z | 2024-09-18T12:14:30.014Z |
5058635 | 5058635 | 20240910163225_U92vP | NZ0020 | 2024-09-14T12:04:13.173Z | 2024-09-18T12:14:29.846Z |
5058490 | 5058490 | 20240910161626_r3lEs | NZ0020 | 2024-09-14T12:03:46.949Z | 2024-09-18T12:14:29.434Z |
5058407 | 5058407 | 20240910161029_uG0dK | NZ0020 | 2024-09-14T12:03:39.501Z | 2024-09-18T12:14:29.185Z |
5058374 | 5058374 | 20240910160826_83lT5 | NZ0020 | 2024-09-14T12:03:37.124Z | 2024-09-18T12:14:29.023Z |
5050698 | 5050698 | 20240907160035_4jAkR | NZ0020 | 2024-09-13T12:13:44.099Z | 2024-09-16T12:20:58.360Z |
5049995 | 5049995 | 20240909121501_XWOJu | NZ0020 | 2024-09-13T12:12:35.314Z | 2024-09-17T12:19:12.079Z |
5049913 | 5049913 | 20240909115737_xxiMh | NZ0020 | 2024-09-13T12:12:31.304Z | 2024-09-17T12:19:11.811Z |
5049847 | 5049847 | 20240909115057_EdGrG | NZ0020 | 2024-09-13T12:12:28.915Z | 2024-09-17T12:19:11.647Z |
5049844 | 5049844 | 20240909115050_G8ppR | NZ0020 | 2024-09-13T12:12:28.803Z | 2024-09-17T12:19:11.639Z |
5049487 | 5049487 | 20240909110233_rO9N0 | NZ0020 | 2024-09-13T12:12:15.022Z | 2024-09-17T12:19:10.658Z |
5049102 | 5049102 | 20240909100746_lIx4U | NZ0020 | 2024-09-13T12:11:34.206Z | 2024-09-17T12:19:09.161Z |
5048836 | 5048836 | 20240909092001_lm0zv | NZ0020 | 2024-09-13T12:11:18.428Z | 2024-09-17T12:19:08.473Z |
5048619 | 5048619 | 20240909083815_YuZyN | NZ0020 | 2024-09-13T12:11:00.401Z | 2024-09-17T12:19:07.734Z |
5048498 | 5048498 | 20240909081854_CuAK2 | NZ0020 | 2024-09-13T12:10:42.148Z | 2024-09-17T12:19:07.241Z |
5045542 | 5045542 | 20240908171838_trgon | NZ0020 | 2024-09-13T12:04:18.136Z | 2024-09-17T12:18:56.751Z |
5045518 | 5045518 | 20240908171659_pNHzd | NZ0020 | 2024-09-13T12:04:15.996Z | 2024-09-17T12:18:56.682Z |
5045398 | 5045398 | 20240908170016_6u3Uv | NZ0020 | 2024-09-13T12:04:05.454Z | 2024-09-17T12:18:56.456Z |
5045374 | 5045374 | 20240908165840_hmsTp | NZ0020 | 2024-09-13T12:04:04.096Z | 2024-09-17T12:18:56.447Z |
5045307 | 5045307 | 20240908165132_aSkrX | NZ0020 | 2024-09-13T12:03:55.986Z | 2024-09-17T12:18:56.369Z |
5045296 | 5045296 | 20240908164923_nTldm | NZ0020 | 2024-09-13T12:03:53.437Z | 2024-09-17T12:18:56.337Z |
5045185 | 5045185 | 20240908162919_o0BNN | NZ0020 | 2024-09-13T12:03:38.463Z | 2024-09-17T12:18:56.022Z |
5045016 | 5045016 | 20240908160730_mvQ7y | NZ0020 | 2024-09-13T12:03:24.201Z | 2024-09-17T12:18:55.618Z |
5044967 | 5044967 | 20240908160002_c0xGj | NZ0020 | 2024-09-13T12:03:19.037Z | 2024-09-17T12:18:55.566Z |
5044840 | 5044840 | 20240908154914_m3OYk | NZ0020 | 2024-09-13T12:03:01.683Z | 2024-09-17T12:18:55.265Z |
5044791 | 5044791 | 20240908154408_HxNOn | NZ0020 | 2024-09-13T12:02:57.106Z | 2024-09-17T12:18:55.192Z |
5044759 | 5044759 | 20240908153944_0po9i | NZ0020 | 2024-09-13T12:02:53.821Z | 2024-09-17T12:18:54.956Z |
5044712 | 5044712 | 20240908153125_XXuH0 | NZ0020 | 2024-09-13T12:02:49.813Z | 2024-09-17T12:18:54.883Z |
5044692 | 5044692 | 20240908152909_Yr56h | NZ0020 | 2024-09-13T12:02:47.926Z | 2024-09-17T12:18:54.855Z |
5044647 | 5044647 | 20240908152611_J1iLB | NZ0020 | 2024-09-13T12:02:39.418Z | 2024-09-17T12:18:54.777Z |
5044625 | 5044625 | 20240908152508_197Ig | NZ0020 | 2024-09-13T12:02:35.882Z | 2024-09-17T12:18:54.763Z |
5044604 | 5044604 | 20240908152056_STX3U | NZ0020 | 2024-09-13T12:02:28.131Z | 2024-09-17T12:18:54.745Z |
5044570 | 5044570 | 20240908151739_K3RWp | NZ0020 | 2024-09-13T12:02:25.413Z | 2024-09-17T12:18:54.704Z |
5044548 | 5044548 | 20240908151320_dRDq3 | NZ0020 | 2024-09-13T12:02:22.460Z | 2024-09-17T12:18:54.669Z |
5044470 | 5044470 | 20240908150436_B5OhB | NZ0020 | 2024-09-13T12:02:14.450Z | 2024-09-17T12:18:54.452Z |
5044141 | 5044141 | 20240908141746_R5Mnd | NZ0020 | 2024-09-13T12:01:32.674Z | 2024-09-17T12:18:53.586Z |
5044053 | 5044053 | 20240908140438_fzCCk | NZ0020 | 2024-09-13T12:01:21.959Z | 2024-09-17T12:18:53.386Z |
5043944 | 5043944 | 20240908133951_hfWQj | NZ0020 | 2024-09-13T12:01:01.497Z | 2024-09-17T12:18:53.089Z |
5043376 | 5043376 | 20240907105324_FY8Yt | NZ0020 | 2024-09-12T12:17:32.255Z | 2024-09-15T12:21:41.541Z |
5043357 | 5043357 | 20240907105017_e3n76 | NZ0020 | 2024-09-12T12:17:32.067Z | 2024-09-15T12:21:41.517Z |
5043123 | 5043123 | 20240907135522_qD2Y4 | NZ0020 | 2024-09-12T12:17:23.685Z | 2024-09-16T12:20:55.553Z |
5042987 | 5042987 | 20240907132622_41OGE | NZ0020 | 2024-09-12T12:17:21.398Z | 2024-09-16T12:20:55.073Z |
5042958 | 5042958 | 20240907132035_4TgT3 | NZ0020 | 2024-09-12T12:17:21.147Z | 2024-09-16T12:20:54.953Z |
5042939 | 5042939 | 20240907131633_EXfmO | NZ0020 | 2024-09-12T12:17:20.914Z | 2024-09-16T12:20:54.940Z |
5042892 | 5042892 | 20240907130607_2dmRm | NZ0020 | 2024-09-12T12:17:20.500Z | 2024-09-16T12:20:54.829Z |
5042783 | 5042783 | 20240907124552_kV6aj | NZ0020 | 2024-09-12T12:17:18.267Z | 2024-09-16T12:20:54.228Z |
5042537 | 5042537 | 20240907115736_mx4CJ | NZ0020 | 2024-09-12T12:17:14.860Z | 2024-09-16T12:20:53.555Z |
5041618 | 5041618 | 20240906084036_SRbfs | NZ0020 | 2024-09-12T12:16:45.463Z | 2024-09-14T12:23:14.193Z |
5037690 | 5037690 | 20240905163719_ZocGp | NZ0020 | 2024-09-12T12:14:14.111Z | 2024-09-14T12:22:54.508Z |
5037557 | 5037557 | 20240905160757_ZvEWK | NZ0020 | 2024-09-12T12:14:08.712Z | 2024-09-14T12:22:54.303Z |
5037499 | 5037499 | 20240905160125_uhbbm | NZ0020 | 2024-09-12T12:14:07.559Z | 2024-09-14T12:22:54.232Z |
5036329 | 5036329 | 20240905131431_Dzgiz | NZ0020 | 2024-09-12T12:13:35.059Z | 2024-09-14T12:22:52.303Z |
5035729 | 5035729 | 20240907101238_gBA9Q | NZ0020 | 2024-09-12T12:12:24.345Z | 2024-09-15T12:21:41.012Z |
5035251 | 5035251 | 20240907090811_KUo0U | NZ0020 | 2024-09-12T12:11:58.281Z | 2024-09-15T12:21:39.014Z |
5029279 | 5029279 | 20240905115150_2WD3b | NZ0020 | 2024-09-11T12:16:24.701Z | 2024-09-14T12:22:51.352Z |
5028785 | 5028785 | 20240905105026_9vsg1 | NZ0020 | 2024-09-11T12:15:52.555Z | 2024-09-14T12:22:49.406Z |
5028323 | 5028323 | 20240905092709_QhAMS | NZ0020 | 2024-09-11T12:15:09.596Z | 2024-09-13T12:20:05.969Z |
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);