participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,536 rows where station_code = "NZ003S" 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 |
---|---|---|---|---|---|
5317948 | 5317948 | 20241017155811_2guYp | NZ003S | 2024-10-18T12:01:16.623Z | 2024-10-18T12:01:16.623Z |
5298443 | 5298443 | 20241012161954_snN3G | NZ003S | 2024-10-14T12:10:21.185Z | 2024-10-18T12:15:16.231Z |
5298193 | 5298193 | 20241012154655_tyYZL | NZ003S | 2024-10-14T12:10:01.992Z | 2024-10-18T12:15:09.324Z |
5298191 | 5298191 | 20241012154453_pYtsQ | NZ003S | 2024-10-14T12:10:01.863Z | 2024-10-18T12:15:09.306Z |
5298056 | 5298056 | 20241012152223_8vw3R | NZ003S | 2024-10-14T12:09:49.983Z | 2024-10-18T12:15:07.510Z |
5298046 | 5298046 | 20241012152042_k22FF | NZ003S | 2024-10-14T12:09:48.904Z | 2024-10-18T12:15:07.296Z |
5298022 | 5298022 | 20241012151209_1xdhc | NZ003S | 2024-10-14T12:09:45.875Z | 2024-10-18T12:15:06.734Z |
5298015 | 5298015 | 20241012151039_0NUUq | NZ003S | 2024-10-14T12:09:44.001Z | 2024-10-18T12:15:06.696Z |
5298010 | 5298010 | 20241012150820_hoHer | NZ003S | 2024-10-14T12:09:42.864Z | 2024-10-18T12:15:06.626Z |
5297970 | 5297970 | 20241012150422_qqAMz | NZ003S | 2024-10-14T12:09:33.333Z | 2024-10-18T12:15:05.950Z |
5297882 | 5297882 | 20241012145043_i5POB | NZ003S | 2024-10-14T12:09:18.001Z | 2024-10-18T12:15:04.934Z |
5297861 | 5297861 | 20241012144825_AVLA5 | NZ003S | 2024-10-14T12:09:15.634Z | 2024-10-18T12:15:04.688Z |
5297853 | 5297853 | 20241012144627_ZDJlU | NZ003S | 2024-10-14T12:09:15.218Z | 2024-10-18T12:15:04.636Z |
5297787 | 5297787 | 20241012143610_y0bpG | NZ003S | 2024-10-14T12:09:08.912Z | 2024-10-18T12:15:04.027Z |
5297757 | 5297757 | 20241012142938_MEA87 | NZ003S | 2024-10-14T12:09:05.988Z | 2024-10-18T12:15:03.588Z |
5297740 | 5297740 | 20241012142550_f41IO | NZ003S | 2024-10-14T12:09:04.172Z | 2024-10-18T12:15:03.373Z |
5297558 | 5297558 | 20241012134609_U57Hw | NZ003S | 2024-10-14T12:08:44.367Z | 2024-10-18T12:15:00.960Z |
5297504 | 5297504 | 20241012133732_h7Nwl | NZ003S | 2024-10-14T12:08:31.458Z | 2024-10-18T12:15:00.387Z |
5297492 | 5297492 | 20241012133337_3unLC | NZ003S | 2024-10-14T12:08:30.052Z | 2024-10-18T12:15:00.252Z |
5297475 | 5297475 | 20241012133050_7SSgH | NZ003S | 2024-10-14T12:08:28.193Z | 2024-10-18T12:15:00.182Z |
5297451 | 5297451 | 20241012132303_SWecm | NZ003S | 2024-10-14T12:08:23.824Z | 2024-10-18T12:14:59.850Z |
5297286 | 5297286 | 20241012123259_3DKEK | NZ003S | 2024-10-14T12:08:05.061Z | 2024-10-18T12:14:57.444Z |
5297274 | 5297274 | 20241012123139_A3Nt5 | NZ003S | 2024-10-14T12:08:03.600Z | 2024-10-18T12:14:57.240Z |
5296962 | 5296962 | 20241012113213_7xONv | NZ003S | 2024-10-14T12:07:12.253Z | 2024-10-18T12:14:52.623Z |
5296603 | 5296603 | 20241012104034_o3ju8 | NZ003S | 2024-10-14T12:06:27.482Z | 2024-10-18T12:14:43.890Z |
5296393 | 5296393 | 20241012101103_ipmev | NZ003S | 2024-10-14T12:05:57.640Z | 2024-10-18T12:14:37.453Z |
5296384 | 5296384 | 20241012101035_q22LO | NZ003S | 2024-10-14T12:05:56.002Z | 2024-10-18T12:14:37.245Z |
5296379 | 5296379 | 20241012101017_3HNhE | NZ003S | 2024-10-14T12:05:54.203Z | 2024-10-18T12:14:37.086Z |
5296347 | 5296347 | 20241012100034_V1pMO | NZ003S | 2024-10-14T12:05:48.340Z | 2024-10-18T12:14:35.970Z |
5296219 | 5296219 | 20241012094153_UF5F0 | NZ003S | 2024-10-14T12:05:32.637Z | 2024-10-18T12:14:32.095Z |
5296215 | 5296215 | 20241012094119_Kc3sd | NZ003S | 2024-10-14T12:05:32.029Z | 2024-10-18T12:14:31.902Z |
5286375 | 5286375 | 20241012082803_9YHpS | NZ003S | 2024-10-13T12:02:21.801Z | 2024-10-18T12:14:16.288Z |
5286215 | 5286215 | 20241012080023_lWiPS | NZ003S | 2024-10-13T12:01:48.802Z | 2024-10-18T12:14:10.640Z |
5273162 | 5273162 | 20241009163234_KqTol | NZ003S | 2024-10-11T12:12:04.844Z | 2024-10-18T12:22:00.129Z |
5273149 | 5273149 | 20241009163153_E2Y3V | NZ003S | 2024-10-11T12:12:03.522Z | 2024-10-18T12:21:59.914Z |
5273107 | 5273107 | 20241009162449_9wB7a | NZ003S | 2024-10-11T12:12:00.930Z | 2024-10-18T12:21:59.730Z |
5273041 | 5273041 | 20241009161145_OCgjD | NZ003S | 2024-10-11T12:11:56.279Z | 2024-10-18T12:21:59.561Z |
5273008 | 5273008 | 20241009160845_L2TsU | NZ003S | 2024-10-11T12:11:53.183Z | 2024-10-18T12:21:59.399Z |
5272752 | 5272752 | 20241009151611_TAjp6 | NZ003S | 2024-10-11T12:11:18.052Z | 2024-10-18T12:21:58.115Z |
5272567 | 5272567 | 20241009144708_vpjnp | NZ003S | 2024-10-11T12:10:53.284Z | 2024-10-18T12:21:57.280Z |
5272407 | 5272407 | 20241009141515_EYKvw | NZ003S | 2024-10-11T12:10:38.400Z | 2024-10-18T12:21:55.984Z |
5272255 | 5272255 | 20241009133946_0aFRa | NZ003S | 2024-10-11T12:10:26.471Z | 2024-10-18T12:21:55.212Z |
5272122 | 5272122 | 20241009131010_XNL8Q | NZ003S | 2024-10-11T12:10:06.827Z | 2024-10-18T12:21:54.752Z |
5271782 | 5271782 | 20241009114857_fqeJn | NZ003S | 2024-10-11T12:09:24.403Z | 2024-10-18T12:21:51.185Z |
5265291 | 5265291 | 20241009113334_2sLrE | NZ003S | 2024-10-10T12:06:34.549Z | 2024-10-18T12:21:50.431Z |
5265247 | 5265247 | 20241009112754_MpCzj | NZ003S | 2024-10-10T12:06:28.079Z | 2024-10-18T12:21:50.249Z |
5265068 | 5265068 | 20241009104914_gmXMy | NZ003S | 2024-10-10T12:05:58.712Z | 2024-10-18T12:21:48.692Z |
5264994 | 5264994 | 20241009102658_DlYSw | NZ003S | 2024-10-10T12:05:39.475Z | 2024-10-18T12:21:48.317Z |
5264731 | 5264731 | 20241009093550_bQtiT | NZ003S | 2024-10-10T12:04:52.328Z | 2024-10-18T12:21:45.702Z |
5264607 | 5264607 | 20241009091631_1GVt6 | NZ003S | 2024-10-10T12:04:35.972Z | 2024-10-18T12:21:44.709Z |
5264385 | 5264385 | 20241009083707_1VBCd | NZ003S | 2024-10-10T12:03:58.513Z | 2024-10-18T12:21:43.604Z |
5260505 | 5260505 | 20241007163357_z3L9h | NZ003S | 2024-10-09T12:12:39.247Z | 2024-10-16T12:21:11.264Z |
5260502 | 5260502 | 20241007163308_tB8b3 | NZ003S | 2024-10-09T12:12:39.120Z | 2024-10-16T12:21:11.260Z |
5260386 | 5260386 | 20241007161700_XJQ1d | NZ003S | 2024-10-09T12:12:26.261Z | 2024-10-16T12:21:11.170Z |
5260304 | 5260304 | 20241007160511_BHGu5 | NZ003S | 2024-10-09T12:12:18.266Z | 2024-10-16T12:21:10.795Z |
5260217 | 5260217 | 20241007155539_V83dx | NZ003S | 2024-10-09T12:12:06.885Z | 2024-10-16T12:21:10.629Z |
5260204 | 5260204 | 20241007155206_AThjS | NZ003S | 2024-10-09T12:12:05.694Z | 2024-10-16T12:21:10.605Z |
5260201 | 5260201 | 20241007155201_jzI4S | NZ003S | 2024-10-09T12:12:05.408Z | 2024-10-16T12:21:10.603Z |
5260160 | 5260160 | 20241007154535_z64N9 | NZ003S | 2024-10-09T12:12:00.077Z | 2024-10-16T12:21:10.530Z |
5260146 | 5260146 | 20241007154235_DjPKZ | NZ003S | 2024-10-09T12:11:56.874Z | 2024-10-16T12:21:10.518Z |
5260064 | 5260064 | 20241007152849_5sE7g | NZ003S | 2024-10-09T12:11:45.758Z | 2024-10-16T12:21:10.257Z |
5259877 | 5259877 | 20241007145945_yUdxz | NZ003S | 2024-10-09T12:11:29.958Z | 2024-10-16T12:21:09.637Z |
5259757 | 5259757 | 20241007144311_64l7d | NZ003S | 2024-10-09T12:11:23.378Z | 2024-10-16T12:21:09.427Z |
5259679 | 5259679 | 20241007143428_KPlh0 | NZ003S | 2024-10-09T12:11:19.216Z | 2024-10-16T12:21:09.281Z |
5259572 | 5259572 | 20241007141855_8M5mi | NZ003S | 2024-10-09T12:11:10.313Z | 2024-10-16T12:21:08.857Z |
5259562 | 5259562 | 20241007141725_XGIlL | NZ003S | 2024-10-09T12:11:09.351Z | 2024-10-16T12:21:08.853Z |
5259516 | 5259516 | 20241007141239_20tcA | NZ003S | 2024-10-09T12:11:00.679Z | 2024-10-16T12:21:08.788Z |
5259450 | 5259450 | 20241007140230_yGJHd | NZ003S | 2024-10-09T12:10:47.683Z | 2024-10-16T12:21:08.658Z |
5259316 | 5259316 | 20241007134333_3T3JN | NZ003S | 2024-10-09T12:10:34.538Z | 2024-10-16T12:21:08.479Z |
5259252 | 5259252 | 20241007133418_e3EJl | NZ003S | 2024-10-09T12:10:30.243Z | 2024-10-16T12:21:08.444Z |
5259162 | 5259162 | 20241007131713_26WLl | NZ003S | 2024-10-09T12:10:25.228Z | 2024-10-16T12:21:08.314Z |
5259080 | 5259080 | 20241007125837_XsJk3 | NZ003S | 2024-10-09T12:10:19.978Z | 2024-10-16T12:21:08.209Z |
5258956 | 5258956 | 20241007123554_NNees | NZ003S | 2024-10-09T12:10:13.455Z | 2024-10-16T12:21:08.121Z |
5258851 | 5258851 | 20241007120219_b21oE | NZ003S | 2024-10-09T12:09:52.477Z | 2024-10-16T12:21:07.733Z |
5258844 | 5258844 | 20241007120054_LpqdL | NZ003S | 2024-10-09T12:09:52.079Z | 2024-10-16T12:21:07.718Z |
5258787 | 5258787 | 20241007114649_yHkqT | NZ003S | 2024-10-09T12:09:44.597Z | 2024-10-16T12:21:07.536Z |
5258677 | 5258677 | 20241007110318_8miYA | NZ003S | 2024-10-09T12:09:30.083Z | 2024-10-16T12:21:06.495Z |
5258642 | 5258642 | 20241007104535_JFPGr | NZ003S | 2024-10-09T12:09:19.567Z | 2024-10-16T12:21:06.234Z |
5251561 | 5251561 | 20241006130917_z7Exr | NZ003S | 2024-10-08T12:10:13.527Z | 2024-10-15T12:28:53.589Z |
5249775 | 5249775 | 20241007101042_v9rHM | NZ003S | 2024-10-08T12:05:51.529Z | 2024-10-16T12:21:05.307Z |
5249059 | 5249059 | 20241007075619_13dav | NZ003S | 2024-10-08T12:04:00.875Z | 2024-10-16T12:21:02.823Z |
5243249 | 5243249 | 20241005163432_K92eD | NZ003S | 2024-10-07T12:13:23.085Z | 2024-10-14T12:24:30.745Z |
5243216 | 5243216 | 20241005162735_4A71G | NZ003S | 2024-10-07T12:13:21.338Z | 2024-10-14T12:24:30.623Z |
5243195 | 5243195 | 20241005162457_JD4ER | NZ003S | 2024-10-07T12:13:20.440Z | 2024-10-14T12:24:30.554Z |
5243176 | 5243176 | 20241005161708_9X62t | NZ003S | 2024-10-07T12:13:19.305Z | 2024-10-14T12:24:30.498Z |
5243009 | 5243009 | 20241005155601_HkfzP | NZ003S | 2024-10-07T12:13:11.802Z | 2024-10-14T12:24:30.216Z |
5242981 | 5242981 | 20241005155143_ave87 | NZ003S | 2024-10-07T12:13:10.303Z | 2024-10-14T12:24:30.114Z |
5242970 | 5242970 | 20241005154952_coNeo | NZ003S | 2024-10-07T12:13:09.700Z | 2024-10-14T12:24:30.106Z |
5242930 | 5242930 | 20241005154519_rbXzJ | NZ003S | 2024-10-07T12:13:03.640Z | 2024-10-14T12:24:30.077Z |
5242928 | 5242928 | 20241005154512_mf3M8 | NZ003S | 2024-10-07T12:13:03.070Z | 2024-10-14T12:24:30.075Z |
5242806 | 5242806 | 20241005151928_d633i | NZ003S | 2024-10-07T12:12:47.676Z | 2024-10-14T12:24:29.804Z |
5242744 | 5242744 | 20241005150548_AAM7w | NZ003S | 2024-10-07T12:12:37.234Z | 2024-10-14T12:24:29.643Z |
5242731 | 5242731 | 20241005150317_sWfcD | NZ003S | 2024-10-07T12:12:35.122Z | 2024-10-14T12:24:29.601Z |
5242576 | 5242576 | 20241005143024_fV3wU | NZ003S | 2024-10-07T12:12:23.284Z | 2024-10-14T12:24:29.301Z |
5242533 | 5242533 | 20241005142226_Hs2bT | NZ003S | 2024-10-07T12:12:19.302Z | 2024-10-14T12:24:29.049Z |
5242472 | 5242472 | 20241005141245_K3IzA | NZ003S | 2024-10-07T12:12:14.516Z | 2024-10-14T12:24:29.004Z |
5242178 | 5242178 | 20241005131033_eek0e | NZ003S | 2024-10-07T12:11:52.148Z | 2024-10-14T12:24:28.567Z |
5242153 | 5242153 | 20241005130021_r4rC3 | NZ003S | 2024-10-07T12:11:50.313Z | 2024-10-14T12:24:28.527Z |
5242018 | 5242018 | 20241005122755_ozic6 | NZ003S | 2024-10-07T12:11:37.935Z | 2024-10-14T12:24:28.359Z |
5241115 | 5241115 | 20241005094454_AKTg3 | NZ003S | 2024-10-07T12:09:46.999Z | 2024-10-14T12:24:25.541Z |
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);