participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,841 rows where station_code = "NZ0009" 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 |
---|---|---|---|---|---|
5131097 | 5131097 | 20240915174132_N7PyZ | NZ0009 | 2024-09-19T12:14:21.363Z | 2024-09-19T12:14:21.363Z |
5130699 | 5130699 | 20240917144346_zeH5m | NZ0009 | 2024-09-19T12:13:45.637Z | 2024-09-19T12:13:45.637Z |
5130670 | 5130670 | 20240917142143_R0NZO | NZ0009 | 2024-09-19T12:13:43.579Z | 2024-09-19T12:13:43.579Z |
5130453 | 5130453 | 20240917120825_q50LS | NZ0009 | 2024-09-19T12:13:18.911Z | 2024-09-19T12:13:18.911Z |
5130168 | 5130168 | 20240917095647_HIUkJ | NZ0009 | 2024-09-19T12:12:42.750Z | 2024-09-19T12:12:42.750Z |
5123534 | 5123534 | 20240914102551_xcOsX | NZ0009 | 2024-09-18T12:11:51.116Z | 2024-09-19T12:20:12.480Z |
5110557 | 5110557 | 20240914170933_oFh8A | NZ0009 | 2024-09-18T12:00:26.362Z | 2024-09-19T12:18:21.315Z |
5071489 | 5071489 | 20240911170355_tYBK2 | NZ0009 | 2024-09-15T12:02:40.117Z | 2024-09-19T12:21:02.000Z |
5071414 | 5071414 | 20240911164817_ig2eU | NZ0009 | 2024-09-15T12:02:29.541Z | 2024-09-19T12:21:01.854Z |
5071178 | 5071178 | 20240911161239_P0l68 | NZ0009 | 2024-09-15T12:01:51.121Z | 2024-09-19T12:21:01.179Z |
5071033 | 5071033 | 20240911154618_EhpKt | NZ0009 | 2024-09-15T12:01:26.862Z | 2024-09-19T12:21:00.767Z |
5068939 | 5068939 | 20240910130748_3DbYt | NZ0009 | 2024-09-14T12:19:23.074Z | 2024-09-18T12:15:26.874Z |
5068878 | 5068878 | 20240910125515_63LZ7 | NZ0009 | 2024-09-14T12:19:22.593Z | 2024-09-18T12:15:26.784Z |
5068840 | 5068840 | 20240910124119_i9lL7 | NZ0009 | 2024-09-14T12:19:21.934Z | 2024-09-18T12:15:26.732Z |
5068786 | 5068786 | 20240910122422_2GfS2 | NZ0009 | 2024-09-14T12:19:21.454Z | 2024-09-18T12:15:26.672Z |
5068782 | 5068782 | 20240910122412_DRP6e | NZ0009 | 2024-09-14T12:19:21.420Z | 2024-09-18T12:15:26.668Z |
5068736 | 5068736 | 20240910121239_tgb1I | NZ0009 | 2024-09-14T12:19:20.921Z | 2024-09-18T12:15:26.573Z |
5068721 | 5068721 | 20240910121004_vFTOE | NZ0009 | 2024-09-14T12:19:20.702Z | 2024-09-18T12:15:26.548Z |
5068699 | 5068699 | 20240910120624_PFiJb | NZ0009 | 2024-09-14T12:19:20.461Z | 2024-09-18T12:15:26.502Z |
5068434 | 5068434 | 20240910113232_PumRD | NZ0009 | 2024-09-14T12:19:15.287Z | 2024-09-18T12:15:26.140Z |
5067988 | 5067988 | 20240910103933_nKi89 | NZ0009 | 2024-09-14T12:19:06.399Z | 2024-09-18T12:15:25.339Z |
5062416 | 5062416 | 20240909172239_132qM | NZ0009 | 2024-09-14T12:12:19.020Z | 2024-09-18T12:15:11.317Z |
5062407 | 5062407 | 20240909172157_Ajwp3 | NZ0009 | 2024-09-14T12:12:18.630Z | 2024-09-18T12:15:11.307Z |
5062344 | 5062344 | 20240909171237_Ln7gY | NZ0009 | 2024-09-14T12:12:11.917Z | 2024-09-18T12:15:10.950Z |
5062282 | 5062282 | 20240909170702_AQDTE | NZ0009 | 2024-09-14T12:12:05.469Z | 2024-09-18T12:15:10.832Z |
5062251 | 5062251 | 20240909170428_JRkH6 | NZ0009 | 2024-09-14T12:12:01.797Z | 2024-09-18T12:15:10.823Z |
5062211 | 5062211 | 20240909165808_Nnoib | NZ0009 | 2024-09-14T12:11:55.828Z | 2024-09-18T12:15:10.646Z |
5062056 | 5062056 | 20240909164040_zW54B | NZ0009 | 2024-09-14T12:11:47.056Z | 2024-09-18T12:15:10.355Z |
5061961 | 5061961 | 20240909162952_kvKW6 | NZ0009 | 2024-09-14T12:11:41.951Z | 2024-09-18T12:15:10.255Z |
5061958 | 5061958 | 20240909162925_HvxP3 | NZ0009 | 2024-09-14T12:11:41.757Z | 2024-09-18T12:15:10.252Z |
5061947 | 5061947 | 20240909162634_Tm26v | NZ0009 | 2024-09-14T12:11:41.209Z | 2024-09-18T12:15:10.209Z |
5061791 | 5061791 | 20240909160026_4Zrnx | NZ0009 | 2024-09-14T12:11:25.054Z | 2024-09-18T12:15:09.983Z |
5061783 | 5061783 | 20240909155941_2uzhv | NZ0009 | 2024-09-14T12:11:24.469Z | 2024-09-18T12:15:09.981Z |
5061774 | 5061774 | 20240909155916_SMvn2 | NZ0009 | 2024-09-14T12:11:24.058Z | 2024-09-18T12:15:09.978Z |
5061588 | 5061588 | 20240909152647_1QYES | NZ0009 | 2024-09-14T12:10:59.303Z | 2024-09-18T12:15:09.699Z |
5061548 | 5061548 | 20240909152231_jzabH | NZ0009 | 2024-09-14T12:10:57.287Z | 2024-09-18T12:15:09.608Z |
5061527 | 5061527 | 20240909152053_xO0se | NZ0009 | 2024-09-14T12:10:55.957Z | 2024-09-18T12:15:09.497Z |
5061277 | 5061277 | 20240909143954_X6FIj | NZ0009 | 2024-09-14T12:10:39.815Z | 2024-09-18T12:15:08.826Z |
5061187 | 5061187 | 20240909142750_RpUb9 | NZ0009 | 2024-09-14T12:10:30.377Z | 2024-09-18T12:15:08.576Z |
5061085 | 5061085 | 20240909141355_BAcFO | NZ0009 | 2024-09-14T12:10:14.911Z | 2024-09-18T12:15:08.100Z |
5061082 | 5061082 | 20240909141230_9d02L | NZ0009 | 2024-09-14T12:10:14.681Z | 2024-09-18T12:15:08.066Z |
5060918 | 5060918 | 20240909132311_2OTgK | NZ0009 | 2024-09-14T12:09:55.508Z | 2024-09-18T12:15:07.290Z |
5060907 | 5060907 | 20240909131941_MW03w | NZ0009 | 2024-09-14T12:09:55.089Z | 2024-09-18T12:15:07.276Z |
5059481 | 5059481 | 20240910174832_EhdnD | NZ0009 | 2024-09-14T12:06:12.337Z | 2024-09-19T12:21:30.821Z |
5059468 | 5059468 | 20240910174750_zOlX4 | NZ0009 | 2024-09-14T12:06:10.968Z | 2024-09-19T12:21:30.812Z |
5059370 | 5059370 | 20240910173517_92TFQ | NZ0009 | 2024-09-14T12:05:49.383Z | 2024-09-19T12:21:30.705Z |
5059333 | 5059333 | 20240910173245_2vcbr | NZ0009 | 2024-09-14T12:05:46.653Z | 2024-09-19T12:21:30.643Z |
5059284 | 5059284 | 20240910172808_sYr2k | NZ0009 | 2024-09-14T12:05:36.010Z | 2024-09-19T12:21:30.485Z |
5059189 | 5059189 | 20240910172158_Kuytc | NZ0009 | 2024-09-14T12:05:25.458Z | 2024-09-19T12:21:30.420Z |
5059073 | 5059073 | 20240910171050_pnu0T | NZ0009 | 2024-09-14T12:05:12.192Z | 2024-09-19T12:21:30.344Z |
5058967 | 5058967 | 20240910170532_1LBmk | NZ0009 | 2024-09-14T12:05:02.916Z | 2024-09-19T12:21:30.283Z |
5058819 | 5058819 | 20240910165001_JALdO | NZ0009 | 2024-09-14T12:04:36.517Z | 2024-09-19T12:21:30.156Z |
5058631 | 5058631 | 20240910163225_U92vP | NZ0009 | 2024-09-14T12:04:13.149Z | 2024-09-19T12:21:29.797Z |
5058194 | 5058194 | 20240910155144_IhNT5 | NZ0009 | 2024-09-14T12:03:07.823Z | 2024-09-19T12:21:29.331Z |
5058155 | 5058155 | 20240910154900_Zxd4l | NZ0009 | 2024-09-14T12:03:03.922Z | 2024-09-19T12:21:29.245Z |
5058052 | 5058052 | 20240910154011_2SsOi | NZ0009 | 2024-09-14T12:02:44.337Z | 2024-09-19T12:21:29.059Z |
5058045 | 5058045 | 20240910153957_y6urX | NZ0009 | 2024-09-14T12:02:43.454Z | 2024-09-19T12:21:29.042Z |
5057574 | 5057574 | 20240910145050_dIJlf | NZ0009 | 2024-09-14T12:01:27.617Z | 2024-09-19T12:21:28.402Z |
5057532 | 5057532 | 20240910144217_YQ4KO | NZ0009 | 2024-09-14T12:01:20.451Z | 2024-09-19T12:21:28.253Z |
5057368 | 5057368 | 20240910141709_T9DnU | NZ0009 | 2024-09-14T12:00:56.062Z | 2024-09-19T12:21:27.640Z |
5057254 | 5057254 | 20240910140606_Cr8vw | NZ0009 | 2024-09-14T12:00:42.239Z | 2024-09-19T12:21:27.467Z |
5057235 | 5057235 | 20240910140244_Z562r | NZ0009 | 2024-09-14T12:00:36.751Z | 2024-09-19T12:21:27.388Z |
5057156 | 5057156 | 20240910135107_LJAdA | NZ0009 | 2024-09-14T12:00:21.431Z | 2024-09-19T12:21:27.150Z |
5057134 | 5057134 | 20240910134753_EAVDS | NZ0009 | 2024-09-14T12:00:19.346Z | 2024-09-19T12:21:27.114Z |
5057129 | 5057129 | 20240910134743_mdNeQ | NZ0009 | 2024-09-14T12:00:18.931Z | 2024-09-19T12:21:27.082Z |
5057114 | 5057114 | 20240910134349_YbG7M | NZ0009 | 2024-09-14T12:00:17.485Z | 2024-09-19T12:21:27.043Z |
5055982 | 5055982 | 20240908092905_5mmnu | NZ0009 | 2024-09-13T12:17:26.330Z | 2024-09-16T12:21:22.919Z |
5051480 | 5051480 | 20240907173338_S6w4b | NZ0009 | 2024-09-13T12:14:18.581Z | 2024-09-16T12:21:00.569Z |
5051305 | 5051305 | 20240907171310_QPqKi | NZ0009 | 2024-09-13T12:14:09.439Z | 2024-09-16T12:21:00.053Z |
5051155 | 5051155 | 20240907165638_Vp227 | NZ0009 | 2024-09-13T12:14:04.745Z | 2024-09-16T12:20:59.746Z |
5051145 | 5051145 | 20240907165404_22k92 | NZ0009 | 2024-09-13T12:14:04.021Z | 2024-09-16T12:20:59.652Z |
5051112 | 5051112 | 20240907164959_KPydt | NZ0009 | 2024-09-13T12:14:02.672Z | 2024-09-16T12:20:59.610Z |
5050993 | 5050993 | 20240907163229_YZdpC | NZ0009 | 2024-09-13T12:13:55.745Z | 2024-09-16T12:20:59.431Z |
5050961 | 5050961 | 20240907162954_nvVaD | NZ0009 | 2024-09-13T12:13:54.999Z | 2024-09-16T12:20:59.404Z |
5050882 | 5050882 | 20240907162036_WMTlu | NZ0009 | 2024-09-13T12:13:51.452Z | 2024-09-16T12:20:59.097Z |
5050829 | 5050829 | 20240907161343_5FsbX | NZ0009 | 2024-09-13T12:13:48.199Z | 2024-09-16T12:20:58.739Z |
5050694 | 5050694 | 20240907160035_4jAkR | NZ0009 | 2024-09-13T12:13:44.099Z | 2024-09-16T12:20:58.359Z |
5050662 | 5050662 | 20240907155535_qKw2I | NZ0009 | 2024-09-13T12:13:42.764Z | 2024-09-16T12:20:58.210Z |
5050477 | 5050477 | 20240907152440_OHZlX | NZ0009 | 2024-09-13T12:13:33.174Z | 2024-09-16T12:20:57.811Z |
5050419 | 5050419 | 20240907152018_OdhXP | NZ0009 | 2024-09-13T12:13:31.046Z | 2024-09-16T12:20:57.669Z |
5050253 | 5050253 | 20240907145904_dlNjQ | NZ0009 | 2024-09-13T12:13:20.724Z | 2024-09-16T12:20:56.811Z |
5050158 | 5050158 | 20240907144214_flwJv | NZ0009 | 2024-09-13T12:13:13.454Z | 2024-09-16T12:20:56.563Z |
5049872 | 5049872 | 20240909115157_oyw9f | NZ0009 | 2024-09-13T12:12:29.526Z | 2024-09-17T12:19:11.703Z |
5049703 | 5049703 | 20240909113025_qFxNt | NZ0009 | 2024-09-13T12:12:23.428Z | 2024-09-17T12:19:11.265Z |
5049520 | 5049520 | 20240909110832_ZQbQV | NZ0009 | 2024-09-13T12:12:16.963Z | 2024-09-17T12:19:10.789Z |
5049482 | 5049482 | 20240909110233_rO9N0 | NZ0009 | 2024-09-13T12:12:15.022Z | 2024-09-17T12:19:10.657Z |
5049429 | 5049429 | 20240909105557_1UqRX | NZ0009 | 2024-09-13T12:12:11.173Z | 2024-09-17T12:19:10.382Z |
5049364 | 5049364 | 20240909104539_HiIQu | NZ0009 | 2024-09-13T12:12:04.316Z | 2024-09-17T12:19:10.252Z |
5048835 | 5048835 | 20240909092001_lm0zv | NZ0009 | 2024-09-13T12:11:18.428Z | 2024-09-17T12:19:08.473Z |
5048817 | 5048817 | 20240909091656_sPtYN | NZ0009 | 2024-09-13T12:11:17.323Z | 2024-09-17T12:19:08.412Z |
5048803 | 5048803 | 20240909091343_g393E | NZ0009 | 2024-09-13T12:11:16.523Z | 2024-09-17T12:19:08.397Z |
5048598 | 5048598 | 20240909083536_7kso6 | NZ0009 | 2024-09-13T12:10:57.612Z | 2024-09-17T12:19:07.648Z |
5048497 | 5048497 | 20240909081854_CuAK2 | NZ0009 | 2024-09-13T12:10:42.148Z | 2024-09-17T12:19:07.241Z |
5045170 | 5045170 | 20240908162850_QFj5J | NZ0009 | 2024-09-13T12:03:37.735Z | 2024-09-17T12:18:56.018Z |
5044992 | 5044992 | 20240908160203_IEtN3 | NZ0009 | 2024-09-13T12:03:22.647Z | 2024-09-17T12:18:55.590Z |
5044835 | 5044835 | 20240908154914_m3OYk | NZ0009 | 2024-09-13T12:03:01.682Z | 2024-09-17T12:18:55.264Z |
5044788 | 5044788 | 20240908154408_HxNOn | NZ0009 | 2024-09-13T12:02:57.106Z | 2024-09-17T12:18:55.192Z |
5044740 | 5044740 | 20240908153910_18q03 | NZ0009 | 2024-09-13T12:02:52.747Z | 2024-09-17T12:18:54.919Z |
5044701 | 5044701 | 20240908153117_O35hS | NZ0009 | 2024-09-13T12:02:49.427Z | 2024-09-17T12:18:54.879Z |
5044678 | 5044678 | 20240908152809_pCCFg | NZ0009 | 2024-09-13T12:02:46.306Z | 2024-09-17T12:18:54.821Z |
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);