participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,542 rows where station_code = "NZ0036" 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 |
---|---|---|---|---|---|
5095915 | 5095915 | 20240912092523_ft63w | NZ0036 | 2024-09-16T12:16:01.949Z | 2024-09-16T12:17:31.647Z |
5095549 | 5095549 | 20240912080200_rJn2s | NZ0036 | 2024-09-16T12:15:48.106Z | 2024-09-16T12:17:31.562Z |
5083582 | 5083582 | 20240911135339_Vcuut | NZ0036 | 2024-09-15T12:18:44.242Z | 2024-09-16T12:19:19.677Z |
5083562 | 5083562 | 20240911134958_S2ZQ2 | NZ0036 | 2024-09-15T12:18:43.989Z | 2024-09-16T12:19:19.491Z |
5083483 | 5083483 | 20240911132906_xjoFJ | NZ0036 | 2024-09-15T12:18:42.466Z | 2024-09-16T12:19:18.701Z |
5083475 | 5083475 | 20240911132834_MzsC2 | NZ0036 | 2024-09-15T12:18:42.462Z | 2024-09-16T12:19:18.686Z |
5083319 | 5083319 | 20240911125427_d33Iy | NZ0036 | 2024-09-15T12:18:38.829Z | 2024-09-16T12:19:17.958Z |
5083211 | 5083211 | 20240911122909_KZgZn | NZ0036 | 2024-09-15T12:18:37.018Z | 2024-09-16T12:19:17.265Z |
5083169 | 5083169 | 20240911121552_82g3C | NZ0036 | 2024-09-15T12:18:36.419Z | 2024-09-16T12:19:17.082Z |
5083162 | 5083162 | 20240911121545_dEeUt | NZ0036 | 2024-09-15T12:18:36.418Z | 2024-09-16T12:19:16.961Z |
5082854 | 5082854 | 20240911111353_3x4qu | NZ0036 | 2024-09-15T12:18:27.327Z | 2024-09-16T12:19:15.247Z |
5082731 | 5082731 | 20240911105021_7W9IK | NZ0036 | 2024-09-15T12:18:24.016Z | 2024-09-16T12:19:14.267Z |
5082573 | 5082573 | 20240911102824_eOVIu | NZ0036 | 2024-09-15T12:18:20.317Z | 2024-09-16T12:19:13.405Z |
5082394 | 5082394 | 20240911100219_iSyV2 | NZ0036 | 2024-09-15T12:18:13.174Z | 2024-09-16T12:19:11.631Z |
5081860 | 5081860 | 20240911085509_3hvtj | NZ0036 | 2024-09-15T12:17:52.341Z | 2024-09-16T12:19:06.571Z |
5081575 | 5081575 | 20240911080540_Ymyhg | NZ0036 | 2024-09-15T12:17:38.205Z | 2024-09-16T12:19:02.744Z |
5071604 | 5071604 | 20240911172516_m5Eii | NZ0036 | 2024-09-15T12:03:03.298Z | 2024-09-16T12:17:28.873Z |
5071519 | 5071519 | 20240911171040_foMps | NZ0036 | 2024-09-15T12:02:46.646Z | 2024-09-16T12:17:28.852Z |
5071404 | 5071404 | 20240911164607_7UQ5K | NZ0036 | 2024-09-15T12:02:28.239Z | 2024-09-16T12:17:28.802Z |
5071277 | 5071277 | 20240911162831_lJuLK | NZ0036 | 2024-09-15T12:02:09.264Z | 2024-09-16T12:17:28.775Z |
5071249 | 5071249 | 20240911162156_DYgfl | NZ0036 | 2024-09-15T12:02:00.888Z | 2024-09-16T12:17:28.768Z |
5071217 | 5071217 | 20240911161631_IHqUS | NZ0036 | 2024-09-15T12:01:56.001Z | 2024-09-16T12:17:28.760Z |
5071194 | 5071194 | 20240911161321_hBZOx | NZ0036 | 2024-09-15T12:01:52.256Z | 2024-09-16T12:17:28.755Z |
5071132 | 5071132 | 20240911160219_pZ5b4 | NZ0036 | 2024-09-15T12:01:45.231Z | 2024-09-16T12:17:28.742Z |
5071028 | 5071028 | 20240911154501_KjXGk | NZ0036 | 2024-09-15T12:01:26.378Z | 2024-09-16T12:17:28.715Z |
5070999 | 5070999 | 20240911154039_rRDJD | NZ0036 | 2024-09-15T12:01:20.000Z | 2024-09-16T12:17:28.710Z |
5070942 | 5070942 | 20240911153154_zgD2R | NZ0036 | 2024-09-15T12:01:12.031Z | 2024-09-16T12:17:28.696Z |
5070913 | 5070913 | 20240911152822_Vo3lE | NZ0036 | 2024-09-15T12:01:08.465Z | 2024-09-16T12:17:28.688Z |
5070872 | 5070872 | 20240911152132_3SP2E | NZ0036 | 2024-09-15T12:01:01.982Z | 2024-09-16T12:17:28.679Z |
5070769 | 5070769 | 20240911150901_LCQib | NZ0036 | 2024-09-15T12:00:47.234Z | 2024-09-16T12:17:28.662Z |
5070682 | 5070682 | 20240911145349_ZyWAv | NZ0036 | 2024-09-15T12:00:34.109Z | 2024-09-16T12:17:28.643Z |
5070650 | 5070650 | 20240911144601_7ro5l | NZ0036 | 2024-09-15T12:00:27.955Z | 2024-09-16T12:17:28.636Z |
5070555 | 5070555 | 20240911143102_c3Yn2 | NZ0036 | 2024-09-15T12:00:17.834Z | 2024-09-16T12:17:28.616Z |
5070547 | 5070547 | 20240911143057_Rnhrh | NZ0036 | 2024-09-15T12:00:17.129Z | 2024-09-16T12:17:28.615Z |
5070493 | 5070493 | 20240908110048_FQwpC | NZ0036 | 2024-09-14T12:22:00.458Z | 2024-09-16T12:21:26.477Z |
5070486 | 5070486 | 20240908074842_Z4SRc | NZ0036 | 2024-09-14T12:21:54.816Z | 2024-09-16T12:21:18.795Z |
5069088 | 5069088 | 20240910134055_FF2gu | NZ0036 | 2024-09-14T12:19:25.469Z | 2024-09-16T12:20:16.413Z |
5068807 | 5068807 | 20240910122945_LLgWY | NZ0036 | 2024-09-14T12:19:21.674Z | 2024-09-16T12:20:15.361Z |
5059326 | 5059326 | 20240910173126_3s2L3 | NZ0036 | 2024-09-14T12:05:45.239Z | 2024-09-16T12:18:03.983Z |
5058571 | 5058571 | 20240910162818_rkD94 | NZ0036 | 2024-09-14T12:04:01.992Z | 2024-09-16T12:17:56.129Z |
5058454 | 5058454 | 20240910161329_ANk2u | NZ0036 | 2024-09-14T12:03:44.072Z | 2024-09-16T12:17:54.806Z |
5058009 | 5058009 | 20240910153511_WZXdx | NZ0036 | 2024-09-14T12:02:36.313Z | 2024-09-16T12:17:49.261Z |
5057946 | 5057946 | 20240910152853_lo4bu | NZ0036 | 2024-09-14T12:02:27.514Z | 2024-09-16T12:17:48.728Z |
5057805 | 5057805 | 20240910151537_7223P | NZ0036 | 2024-09-14T12:02:09.026Z | 2024-09-16T12:17:47.785Z |
5057801 | 5057801 | 20240910151523_YjHQH | NZ0036 | 2024-09-14T12:02:08.414Z | 2024-09-16T12:17:47.782Z |
5057675 | 5057675 | 20240910150318_yF2Fx | NZ0036 | 2024-09-14T12:01:42.855Z | 2024-09-16T12:17:46.257Z |
5057441 | 5057441 | 20240910142954_4t3xn | NZ0036 | 2024-09-14T12:01:04.139Z | 2024-09-16T12:17:43.986Z |
5057359 | 5057359 | 20240910141644_Cv5Ka | NZ0036 | 2024-09-14T12:00:54.845Z | 2024-09-16T12:17:42.885Z |
5057300 | 5057300 | 20240910141004_tSqgT | NZ0036 | 2024-09-14T12:00:47.316Z | 2024-09-16T12:17:42.219Z |
5057286 | 5057286 | 20240910140714_9Nl2m | NZ0036 | 2024-09-14T12:00:45.004Z | 2024-09-16T12:17:42.140Z |
5057063 | 5057063 | 20240908120637_4Bw5n | NZ0036 | 2024-09-13T12:17:44.387Z | 2024-09-16T12:21:28.727Z |
5056847 | 5056847 | 20240908113110_2YM0F | NZ0036 | 2024-09-13T12:17:39.929Z | 2024-09-16T12:21:27.549Z |
5056828 | 5056828 | 20240908112926_0m5Jw | NZ0036 | 2024-09-13T12:17:39.771Z | 2024-09-16T12:21:27.462Z |
5056660 | 5056660 | 20240908105933_4bjzU | NZ0036 | 2024-09-13T12:17:36.864Z | 2024-09-16T12:21:26.469Z |
5056593 | 5056593 | 20240908104844_0Ry3z | NZ0036 | 2024-09-13T12:17:36.019Z | 2024-09-16T12:21:26.049Z |
5056516 | 5056516 | 20240908103717_r3Jhh | NZ0036 | 2024-09-13T12:17:34.423Z | 2024-09-16T12:21:25.727Z |
5056434 | 5056434 | 20240908102911_MoAUC | NZ0036 | 2024-09-13T12:17:32.064Z | 2024-09-16T12:21:25.366Z |
5056287 | 5056287 | 20240908100701_jOhj2 | NZ0036 | 2024-09-13T12:17:29.574Z | 2024-09-16T12:21:24.182Z |
5056243 | 5056243 | 20240908100006_HgJ8e | NZ0036 | 2024-09-13T12:17:28.856Z | 2024-09-16T12:21:24.029Z |
5056210 | 5056210 | 20240908095542_rGEpG | NZ0036 | 2024-09-13T12:17:28.519Z | 2024-09-16T12:21:23.858Z |
5056040 | 5056040 | 20240908093308_t3tMF | NZ0036 | 2024-09-13T12:17:26.940Z | 2024-09-16T12:21:23.054Z |
5055748 | 5055748 | 20240908085303_toKsR | NZ0036 | 2024-09-13T12:17:21.318Z | 2024-09-16T12:21:21.842Z |
5055613 | 5055613 | 20240908082907_nhMR3 | NZ0036 | 2024-09-13T12:17:18.773Z | 2024-09-16T12:21:21.177Z |
5051409 | 5051409 | 20240907172506_1dOCJ | NZ0036 | 2024-09-13T12:14:13.492Z | 2024-09-16T12:21:00.352Z |
5051388 | 5051388 | 20240907172156_5I1CG | NZ0036 | 2024-09-13T12:14:12.877Z | 2024-09-16T12:21:00.299Z |
5051346 | 5051346 | 20240907171944_RnhQQ | NZ0036 | 2024-09-13T12:14:11.651Z | 2024-09-16T12:21:00.156Z |
5051127 | 5051127 | 20240907165136_cVEjK | NZ0036 | 2024-09-13T12:14:03.168Z | 2024-09-16T12:20:59.621Z |
5051037 | 5051037 | 20240907163847_zLyvo | NZ0036 | 2024-09-13T12:13:58.309Z | 2024-09-16T12:20:59.496Z |
5050922 | 5050922 | 20240907162445_RMdti | NZ0036 | 2024-09-13T12:13:53.721Z | 2024-09-16T12:20:59.290Z |
5050920 | 5050920 | 20240907162353_sHuKo | NZ0036 | 2024-09-13T12:13:53.672Z | 2024-09-16T12:20:59.284Z |
5050917 | 5050917 | 20240907162328_Aaq3T | NZ0036 | 2024-09-13T12:13:53.111Z | 2024-09-16T12:20:59.263Z |
5050606 | 5050606 | 20240907154705_0bZ3B | NZ0036 | 2024-09-13T12:13:38.679Z | 2024-09-16T12:20:58.084Z |
5050578 | 5050578 | 20240907154220_MhUnx | NZ0036 | 2024-09-13T12:13:37.529Z | 2024-09-16T12:20:58.044Z |
5050512 | 5050512 | 20240907153223_Da20K | NZ0036 | 2024-09-13T12:13:34.797Z | 2024-09-16T12:20:57.896Z |
5050389 | 5050389 | 20240907151603_z2ytR | NZ0036 | 2024-09-13T12:13:30.148Z | 2024-09-16T12:20:57.543Z |
5045614 | 5045614 | 20240908173202_owh42 | NZ0036 | 2024-09-13T12:04:27.193Z | 2024-09-16T12:20:26.305Z |
5045588 | 5045588 | 20240908172626_D6L1U | NZ0036 | 2024-09-13T12:04:24.331Z | 2024-09-16T12:20:26.179Z |
5045522 | 5045522 | 20240908171714_btH4V | NZ0036 | 2024-09-13T12:04:16.312Z | 2024-09-16T12:20:25.973Z |
5045481 | 5045481 | 20240908171035_tork6 | NZ0036 | 2024-09-13T12:04:13.357Z | 2024-09-16T12:20:25.929Z |
5045462 | 5045462 | 20240908170739_pzi21 | NZ0036 | 2024-09-13T12:04:11.067Z | 2024-09-16T12:20:25.871Z |
5045403 | 5045403 | 20240908170132_7frtS | NZ0036 | 2024-09-13T12:04:06.072Z | 2024-09-16T12:20:25.626Z |
5045379 | 5045379 | 20240908165924_vKZc3 | NZ0036 | 2024-09-13T12:04:04.460Z | 2024-09-16T12:20:25.573Z |
5045329 | 5045329 | 20240908165244_h53xL | NZ0036 | 2024-09-13T12:04:00.201Z | 2024-09-16T12:20:25.444Z |
5045321 | 5045321 | 20240908165232_jLT7r | NZ0036 | 2024-09-13T12:03:58.456Z | 2024-09-16T12:20:25.442Z |
5045264 | 5045264 | 20240908164450_8db1g | NZ0036 | 2024-09-13T12:03:48.033Z | 2024-09-16T12:20:25.243Z |
5045257 | 5045257 | 20240908164431_kI3rj | NZ0036 | 2024-09-13T12:03:47.618Z | 2024-09-16T12:20:25.238Z |
5045236 | 5045236 | 20240908163906_moj9Q | NZ0036 | 2024-09-13T12:03:44.977Z | 2024-09-16T12:20:25.013Z |
5045142 | 5045142 | 20240908162521_jZlSi | NZ0036 | 2024-09-13T12:03:35.937Z | 2024-09-16T12:20:24.637Z |
5045129 | 5045129 | 20240908162500_ijJym | NZ0036 | 2024-09-13T12:03:35.205Z | 2024-09-16T12:20:24.624Z |
5045112 | 5045112 | 20240908162043_Z0gea | NZ0036 | 2024-09-13T12:03:33.767Z | 2024-09-16T12:20:24.538Z |
5045058 | 5045058 | 20240908161430_XEvyu | NZ0036 | 2024-09-13T12:03:29.528Z | 2024-09-16T12:20:24.434Z |
5044982 | 5044982 | 20240908160059_2Dz69 | NZ0036 | 2024-09-13T12:03:21.316Z | 2024-09-16T12:20:23.969Z |
5044886 | 5044886 | 20240908155250_LUNbY | NZ0036 | 2024-09-13T12:03:06.982Z | 2024-09-16T12:20:23.761Z |
5044816 | 5044816 | 20240908154626_oS1gz | NZ0036 | 2024-09-13T12:02:59.679Z | 2024-09-16T12:20:23.574Z |
5044735 | 5044735 | 20240908153710_zbTWv | NZ0036 | 2024-09-13T12:02:52.213Z | 2024-09-16T12:20:23.476Z |
5044412 | 5044412 | 20240908145833_NEexG | NZ0036 | 2024-09-13T12:02:08.550Z | 2024-09-16T12:20:21.870Z |
5044372 | 5044372 | 20240908145156_ojocX | NZ0036 | 2024-09-13T12:02:04.334Z | 2024-09-16T12:20:21.778Z |
5044350 | 5044350 | 20240908144805_1nDnV | NZ0036 | 2024-09-13T12:02:01.310Z | 2024-09-16T12:20:21.519Z |
5044343 | 5044343 | 20240908144747_u3nz5 | NZ0036 | 2024-09-13T12:01:59.787Z | 2024-09-16T12:20:21.518Z |
5044254 | 5044254 | 20240908143731_kGGc3 | NZ0036 | 2024-09-13T12:01:46.596Z | 2024-09-16T12:20:21.272Z |
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);