participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,588 rows where station_code = "NZ0019" 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 |
---|---|---|---|---|---|
5071439 | 5071439 | 20240911165435_WT0LB | NZ0019 | 2024-09-15T12:02:32.875Z | 2024-09-16T12:17:28.810Z |
5071047 | 5071047 | 20240911155106_3SvKa | NZ0019 | 2024-09-15T12:01:29.801Z | 2024-09-16T12:17:28.720Z |
5070931 | 5070931 | 20240911152922_vcei1 | NZ0019 | 2024-09-15T12:01:10.596Z | 2024-09-16T12:17:28.693Z |
5070896 | 5070896 | 20240911152631_NUmX7 | NZ0019 | 2024-09-15T12:01:06.217Z | 2024-09-16T12:17:28.684Z |
5069065 | 5069065 | 20240910133700_AENBE | NZ0019 | 2024-09-14T12:19:25.104Z | 2024-09-16T12:20:16.346Z |
5068884 | 5068884 | 20240910125515_63LZ7 | NZ0019 | 2024-09-14T12:19:22.593Z | 2024-09-16T12:20:15.540Z |
5068845 | 5068845 | 20240910124446_vxhN5 | NZ0019 | 2024-09-14T12:19:22.035Z | 2024-09-16T12:20:15.439Z |
5068837 | 5068837 | 20240910123844_syCcJ | NZ0019 | 2024-09-14T12:19:21.875Z | 2024-09-16T12:20:15.434Z |
5068783 | 5068783 | 20240910122412_DRP6e | NZ0019 | 2024-09-14T12:19:21.420Z | 2024-09-16T12:20:15.079Z |
5068739 | 5068739 | 20240910121428_3ovub | NZ0019 | 2024-09-14T12:19:20.929Z | 2024-09-16T12:20:14.949Z |
5068687 | 5068687 | 20240910120545_36euH | NZ0019 | 2024-09-14T12:19:20.363Z | 2024-09-16T12:20:14.713Z |
5068486 | 5068486 | 20240910113946_8Z3gl | NZ0019 | 2024-09-14T12:19:16.396Z | 2024-09-16T12:20:14.163Z |
5068391 | 5068391 | 20240910112547_RgmDq | NZ0019 | 2024-09-14T12:19:13.645Z | 2024-09-16T12:20:13.775Z |
5062673 | 5062673 | 20240909175833_KDuap | NZ0019 | 2024-09-14T12:12:42.028Z | 2024-09-16T12:19:38.588Z |
5062457 | 5062457 | 20240909172807_mewMJ | NZ0019 | 2024-09-14T12:12:23.924Z | 2024-09-16T12:19:37.451Z |
5062380 | 5062380 | 20240909171755_lmmxA | NZ0019 | 2024-09-14T12:12:15.890Z | 2024-09-16T12:19:37.130Z |
5062365 | 5062365 | 20240909171635_MF1H2 | NZ0019 | 2024-09-14T12:12:14.054Z | 2024-09-16T12:19:37.108Z |
5062185 | 5062185 | 20240909165544_iosR4 | NZ0019 | 2024-09-14T12:11:54.653Z | 2024-09-16T12:19:36.354Z |
5061698 | 5061698 | 20240909154354_kCdkq | NZ0019 | 2024-09-14T12:11:12.772Z | 2024-09-16T12:19:33.200Z |
5061643 | 5061643 | 20240909153449_tjSJO | NZ0019 | 2024-09-14T12:11:05.432Z | 2024-09-16T12:19:32.908Z |
5061570 | 5061570 | 20240909152414_HL2bm | NZ0019 | 2024-09-14T12:10:58.280Z | 2024-09-16T12:19:32.134Z |
5061542 | 5061542 | 20240909152153_8E2Q1 | NZ0019 | 2024-09-14T12:10:56.906Z | 2024-09-16T12:19:32.072Z |
5061451 | 5061451 | 20240909150821_p22xE | NZ0019 | 2024-09-14T12:10:50.792Z | 2024-09-16T12:19:31.696Z |
5061374 | 5061374 | 20240909145755_mluS8 | NZ0019 | 2024-09-14T12:10:45.034Z | 2024-09-16T12:19:31.212Z |
5061363 | 5061363 | 20240909145712_HLP2q | NZ0019 | 2024-09-14T12:10:44.520Z | 2024-09-16T12:19:31.141Z |
5061332 | 5061332 | 20240909144934_k7ey8 | NZ0019 | 2024-09-14T12:10:42.936Z | 2024-09-16T12:19:30.601Z |
5061315 | 5061315 | 20240909144554_Prjrv | NZ0019 | 2024-09-14T12:10:41.866Z | 2024-09-16T12:19:30.570Z |
5061086 | 5061086 | 20240909141355_BAcFO | NZ0019 | 2024-09-14T12:10:14.911Z | 2024-09-16T12:19:29.274Z |
5061008 | 5061008 | 20240909134953_o4BUf | NZ0019 | 2024-09-14T12:10:04.873Z | 2024-09-16T12:19:28.574Z |
5059373 | 5059373 | 20240910173517_92TFQ | NZ0019 | 2024-09-14T12:05:49.383Z | 2024-09-16T12:18:04.268Z |
5059335 | 5059335 | 20240910173245_2vcbr | NZ0019 | 2024-09-14T12:05:46.653Z | 2024-09-16T12:18:04.040Z |
5059134 | 5059134 | 20240910171617_g53Nv | NZ0019 | 2024-09-14T12:05:18.116Z | 2024-09-16T12:18:02.166Z |
5058994 | 5058994 | 20240910170729_F18PJ | NZ0019 | 2024-09-14T12:05:05.292Z | 2024-09-16T12:18:00.332Z |
5058969 | 5058969 | 20240910170532_1LBmk | NZ0019 | 2024-09-14T12:05:02.916Z | 2024-09-16T12:18:00.138Z |
5058949 | 5058949 | 20240910170303_VExsX | NZ0019 | 2024-09-14T12:04:58.277Z | 2024-09-16T12:18:00.058Z |
5058935 | 5058935 | 20240910170151_7yG5w | NZ0019 | 2024-09-14T12:04:53.169Z | 2024-09-16T12:17:59.937Z |
5058925 | 5058925 | 20240910170124_GoiS3 | NZ0019 | 2024-09-14T12:04:51.853Z | 2024-09-16T12:17:59.863Z |
5058800 | 5058800 | 20240910164838_iR3D3 | NZ0019 | 2024-09-14T12:04:33.838Z | 2024-09-16T12:17:58.334Z |
5058732 | 5058732 | 20240910164032_h2vmo | NZ0019 | 2024-09-14T12:04:25.297Z | 2024-09-16T12:17:57.514Z |
5058707 | 5058707 | 20240910163832_CJ2sX | NZ0019 | 2024-09-14T12:04:22.301Z | 2024-09-16T12:17:57.335Z |
5058684 | 5058684 | 20240910163611_YDrHr | NZ0019 | 2024-09-14T12:04:19.089Z | 2024-09-16T12:17:57.112Z |
5058645 | 5058645 | 20240910163251_oH7O3 | NZ0019 | 2024-09-14T12:04:15.002Z | 2024-09-16T12:17:56.779Z |
5058576 | 5058576 | 20240910162821_9CYHq | NZ0019 | 2024-09-14T12:04:02.641Z | 2024-09-16T12:17:56.131Z |
5058525 | 5058525 | 20240910161937_owSFD | NZ0019 | 2024-09-14T12:03:50.896Z | 2024-09-16T12:17:55.666Z |
5058516 | 5058516 | 20240910161915_wJEC8 | NZ0019 | 2024-09-14T12:03:50.282Z | 2024-09-16T12:17:55.625Z |
5058385 | 5058385 | 20240910160844_hxF9n | NZ0019 | 2024-09-14T12:03:38.668Z | 2024-09-16T12:17:53.807Z |
5058160 | 5058160 | 20240910154900_Zxd4l | NZ0019 | 2024-09-14T12:03:03.923Z | 2024-09-16T12:17:51.267Z |
5057885 | 5057885 | 20240910152220_wnqAn | NZ0019 | 2024-09-14T12:02:19.416Z | 2024-09-16T12:17:48.140Z |
5057752 | 5057752 | 20240910151036_b9l26 | NZ0019 | 2024-09-14T12:01:53.326Z | 2024-09-16T12:17:47.008Z |
5057703 | 5057703 | 20240910150610_22wzz | NZ0019 | 2024-09-14T12:01:46.656Z | 2024-09-16T12:17:46.401Z |
5057511 | 5057511 | 20240910143927_FXlbH | NZ0019 | 2024-09-14T12:01:17.676Z | 2024-09-16T12:17:44.701Z |
5057396 | 5057396 | 20240910142215_n6yVm | NZ0019 | 2024-09-14T12:00:59.900Z | 2024-09-16T12:17:43.561Z |
5057259 | 5057259 | 20240910140606_Cr8vw | NZ0019 | 2024-09-14T12:00:42.239Z | 2024-09-16T12:17:41.892Z |
5057231 | 5057231 | 20240910140230_50JAG | NZ0019 | 2024-09-14T12:00:36.022Z | 2024-09-16T12:17:41.529Z |
5057137 | 5057137 | 20240910134807_wyOF3 | NZ0019 | 2024-09-14T12:00:19.688Z | 2024-09-16T12:17:39.199Z |
5055983 | 5055983 | 20240908092905_5mmnu | NZ0019 | 2024-09-13T12:17:26.330Z | 2024-09-16T12:21:22.919Z |
5051569 | 5051569 | 20240907174648_fc7UZ | NZ0019 | 2024-09-13T12:14:23.344Z | 2024-09-16T12:21:01.346Z |
5051482 | 5051482 | 20240907173338_S6w4b | NZ0019 | 2024-09-13T12:14:18.581Z | 2024-09-16T12:21:00.569Z |
5051438 | 5051438 | 20240907172740_uAlB5 | NZ0019 | 2024-09-13T12:14:14.970Z | 2024-09-16T12:21:00.477Z |
5051357 | 5051357 | 20240907172024_26k0v | NZ0019 | 2024-09-13T12:14:12.075Z | 2024-09-16T12:21:00.202Z |
5051331 | 5051331 | 20240907171638_ACVzV | NZ0019 | 2024-09-13T12:14:11.327Z | 2024-09-16T12:21:00.115Z |
5051327 | 5051327 | 20240907171636_uH8fT | NZ0019 | 2024-09-13T12:14:11.218Z | 2024-09-16T12:21:00.113Z |
5051236 | 5051236 | 20240907170717_dCdmZ | NZ0019 | 2024-09-13T12:14:07.220Z | 2024-09-16T12:20:59.916Z |
5051227 | 5051227 | 20240907170519_p2fq2 | NZ0019 | 2024-09-13T12:14:06.904Z | 2024-09-16T12:20:59.906Z |
5051180 | 5051180 | 20240907165724_SW4o4 | NZ0019 | 2024-09-13T12:14:05.075Z | 2024-09-16T12:20:59.776Z |
5051171 | 5051171 | 20240907165702_tc9gf | NZ0019 | 2024-09-13T12:14:05.011Z | 2024-09-16T12:20:59.771Z |
5051114 | 5051114 | 20240907164959_KPydt | NZ0019 | 2024-09-13T12:14:02.672Z | 2024-09-16T12:20:59.610Z |
5051044 | 5051044 | 20240907163930_iViU9 | NZ0019 | 2024-09-13T12:13:58.565Z | 2024-09-16T12:20:59.511Z |
5051019 | 5051019 | 20240907163734_aPJFT | NZ0019 | 2024-09-13T12:13:57.495Z | 2024-09-16T12:20:59.475Z |
5050988 | 5050988 | 20240907163021_qpcB6 | NZ0019 | 2024-09-13T12:13:55.635Z | 2024-09-16T12:20:59.422Z |
5050793 | 5050793 | 20240907160757_6qF3n | NZ0019 | 2024-09-13T12:13:46.851Z | 2024-09-16T12:20:58.524Z |
5050719 | 5050719 | 20240907160221_N3JkL | NZ0019 | 2024-09-13T12:13:44.819Z | 2024-09-16T12:20:58.380Z |
5050697 | 5050697 | 20240907160035_4jAkR | NZ0019 | 2024-09-13T12:13:44.099Z | 2024-09-16T12:20:58.359Z |
5050672 | 5050672 | 20240907155752_Dj8IJ | NZ0019 | 2024-09-13T12:13:43.336Z | 2024-09-16T12:20:58.339Z |
5050585 | 5050585 | 20240907154546_ZBzdq | NZ0019 | 2024-09-13T12:13:38.053Z | 2024-09-16T12:20:58.050Z |
5050526 | 5050526 | 20240907153411_5Az62 | NZ0019 | 2024-09-13T12:13:35.427Z | 2024-09-16T12:20:57.942Z |
5050480 | 5050480 | 20240907152440_OHZlX | NZ0019 | 2024-09-13T12:13:33.174Z | 2024-09-16T12:20:57.811Z |
5050361 | 5050361 | 20240907151316_Ls753 | NZ0019 | 2024-09-13T12:13:27.450Z | 2024-09-16T12:20:57.381Z |
5050107 | 5050107 | 20240909124722_ozaY8 | NZ0019 | 2024-09-13T12:12:40.760Z | 2024-09-16T12:20:45.532Z |
5050075 | 5050075 | 20240909123912_nWSlT | NZ0019 | 2024-09-13T12:12:38.933Z | 2024-09-16T12:20:45.397Z |
5050032 | 5050032 | 20240909123133_IJ367 | NZ0019 | 2024-09-13T12:12:37.359Z | 2024-09-16T12:20:45.262Z |
5049866 | 5049866 | 20240909115154_mYfed | NZ0019 | 2024-09-13T12:12:29.365Z | 2024-09-16T12:20:44.639Z |
5049779 | 5049779 | 20240909113849_740vY | NZ0019 | 2024-09-13T12:12:26.069Z | 2024-09-16T12:20:44.152Z |
5049706 | 5049706 | 20240909113025_qFxNt | NZ0019 | 2024-09-13T12:12:23.428Z | 2024-09-16T12:20:43.781Z |
5049522 | 5049522 | 20240909110832_ZQbQV | NZ0019 | 2024-09-13T12:12:16.964Z | 2024-09-16T12:20:43.128Z |
5049253 | 5049253 | 20240909102803_6T2QE | NZ0019 | 2024-09-13T12:11:50.809Z | 2024-09-16T12:20:42.165Z |
5049073 | 5049073 | 20240909095921_qlO0c | NZ0019 | 2024-09-13T12:11:31.321Z | 2024-09-16T12:20:41.418Z |
5048906 | 5048906 | 20240909092816_z2G4J | NZ0019 | 2024-09-13T12:11:22.113Z | 2024-09-16T12:20:40.588Z |
5048827 | 5048827 | 20240909091821_ShXvf | NZ0019 | 2024-09-13T12:11:17.620Z | 2024-09-16T12:20:40.363Z |
5048819 | 5048819 | 20240909091656_sPtYN | NZ0019 | 2024-09-13T12:11:17.323Z | 2024-09-16T12:20:40.297Z |
5048600 | 5048600 | 20240909083536_7kso6 | NZ0019 | 2024-09-13T12:10:57.612Z | 2024-09-16T12:20:39.609Z |
5048489 | 5048489 | 20240909081708_gq42o | NZ0019 | 2024-09-13T12:10:41.024Z | 2024-09-16T12:20:39.172Z |
5044809 | 5044809 | 20240908154604_BhPEe | NZ0019 | 2024-09-13T12:02:59.287Z | 2024-09-16T12:20:23.572Z |
5044798 | 5044798 | 20240908154446_Q625s | NZ0019 | 2024-09-13T12:02:57.825Z | 2024-09-16T12:20:23.545Z |
5044742 | 5044742 | 20240908153910_18q03 | NZ0019 | 2024-09-13T12:02:52.747Z | 2024-09-16T12:20:23.478Z |
5044716 | 5044716 | 20240908153140_9tPJA | NZ0019 | 2024-09-13T12:02:50.208Z | 2024-09-16T12:20:23.406Z |
5044703 | 5044703 | 20240908153117_O35hS | NZ0019 | 2024-09-13T12:02:49.428Z | 2024-09-16T12:20:23.352Z |
5044592 | 5044592 | 20240908152031_GTpU6 | NZ0019 | 2024-09-13T12:02:27.168Z | 2024-09-16T12:20:22.761Z |
5044221 | 5044221 | 20240908143130_qldmx | NZ0019 | 2024-09-13T12:01:42.689Z | 2024-09-16T12:20:20.573Z |
5044177 | 5044177 | 20240908142230_yIcG2 | NZ0019 | 2024-09-13T12:01:37.092Z | 2024-09-16T12:20:20.079Z |
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);