participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
542 rows where station_code = "NZ0025" 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 |
---|---|---|---|---|---|
5310039 | 5310039 | 20241014152942_6jbF4 | NZ0025 | 2024-10-16T12:06:24.258Z | 2024-10-18T12:09:20.326Z |
5305742 | 5305742 | 20241013164204_tc6Jd | NZ0025 | 2024-10-15T12:05:14.605Z | 2024-10-18T12:12:37.161Z |
5305716 | 5305716 | 20241013163749_EeiNV | NZ0025 | 2024-10-15T12:05:09.930Z | 2024-10-18T12:12:35.578Z |
5305660 | 5305660 | 20241013162515_dX3YJ | NZ0025 | 2024-10-15T12:05:00.686Z | 2024-10-18T12:12:33.634Z |
5305634 | 5305634 | 20241013162044_P7kXH | NZ0025 | 2024-10-15T12:04:58.658Z | 2024-10-18T12:12:32.806Z |
5305617 | 5305617 | 20241013161705_pouoM | NZ0025 | 2024-10-15T12:04:55.848Z | 2024-10-18T12:12:31.105Z |
5305582 | 5305582 | 20241013155858_T3MXN | NZ0025 | 2024-10-15T12:04:51.281Z | 2024-10-18T12:12:28.364Z |
5305523 | 5305523 | 20241013154226_TPVDW | NZ0025 | 2024-10-15T12:04:44.963Z | 2024-10-18T12:12:25.822Z |
5305429 | 5305429 | 20241013151152_zAOZL | NZ0025 | 2024-10-15T12:04:35.716Z | 2024-10-18T12:12:22.361Z |
5305388 | 5305388 | 20241013145811_nDMvl | NZ0025 | 2024-10-15T12:04:27.560Z | 2024-10-18T12:12:19.708Z |
5305370 | 5305370 | 20241013145142_qImNk | NZ0025 | 2024-10-15T12:04:24.080Z | 2024-10-18T12:12:18.723Z |
5305282 | 5305282 | 20241013133530_z3CQt | NZ0025 | 2024-10-15T12:04:07.083Z | 2024-10-18T12:12:15.670Z |
5304815 | 5304815 | 20241013111726_AkJRs | NZ0025 | 2024-10-15T12:02:44.894Z | 2024-10-18T12:12:06.039Z |
5304623 | 5304623 | 20241013105356_gLoxL | NZ0025 | 2024-10-15T12:02:18.736Z | 2024-10-18T12:12:00.017Z |
5295860 | 5295860 | 20241013091303_LL8d1 | NZ0025 | 2024-10-14T12:03:39.001Z | 2024-10-18T12:11:52.018Z |
5290229 | 5290229 | 20241011164817_mzGD9 | NZ0025 | 2024-10-13T12:12:04.171Z | 2024-10-18T12:19:09.377Z |
5290207 | 5290207 | 20241011164340_OvKmx | NZ0025 | 2024-10-13T12:12:02.574Z | 2024-10-18T12:19:09.244Z |
5290158 | 5290158 | 20241011163828_YfCr5 | NZ0025 | 2024-10-13T12:12:00.146Z | 2024-10-18T12:19:09.055Z |
5290078 | 5290078 | 20241011163013_9Uv3i | NZ0025 | 2024-10-13T12:11:54.615Z | 2024-10-18T12:19:08.597Z |
5289674 | 5289674 | 20241011155402_JPwCI | NZ0025 | 2024-10-13T12:11:13.483Z | 2024-10-18T12:19:06.785Z |
5289482 | 5289482 | 20241011153317_p2IQX | NZ0025 | 2024-10-13T12:10:53.169Z | 2024-10-18T12:19:05.640Z |
5289432 | 5289432 | 20241011152848_MRdfm | NZ0025 | 2024-10-13T12:10:45.355Z | 2024-10-18T12:19:05.130Z |
5288447 | 5288447 | 20241011135908_wJNzu | NZ0025 | 2024-10-13T12:09:18.634Z | 2024-10-18T12:18:54.907Z |
5287922 | 5287922 | 20241011122800_2CauE | NZ0025 | 2024-10-13T12:08:18.156Z | 2024-10-18T12:18:47.317Z |
5287158 | 5287158 | 20241011110555_mPbpo | NZ0025 | 2024-10-13T12:06:27.504Z | 2024-10-18T12:18:32.353Z |
5280783 | 5280783 | 20241010164058_egkYm | NZ0025 | 2024-10-12T12:12:50.896Z | 2024-10-18T12:20:53.676Z |
5280712 | 5280712 | 20241010163036_izHkJ | NZ0025 | 2024-10-12T12:12:44.675Z | 2024-10-18T12:20:52.692Z |
5280340 | 5280340 | 20241010160054_Ftp2j | NZ0025 | 2024-10-12T12:12:22.592Z | 2024-10-18T12:20:50.500Z |
5280290 | 5280290 | 20241010155715_ecFXS | NZ0025 | 2024-10-12T12:12:13.736Z | 2024-10-18T12:20:50.288Z |
5280049 | 5280049 | 20241010153723_22t1j | NZ0025 | 2024-10-12T12:11:48.634Z | 2024-10-18T12:20:48.600Z |
5279764 | 5279764 | 20241010151541_xKN1Q | NZ0025 | 2024-10-12T12:11:18.035Z | 2024-10-18T12:20:47.160Z |
5279071 | 5279071 | 20241010135918_V3d5w | NZ0025 | 2024-10-12T12:10:08.202Z | 2024-10-18T12:20:39.643Z |
5278955 | 5278955 | 20241010134718_F5KUK | NZ0025 | 2024-10-12T12:09:59.721Z | 2024-10-18T12:20:38.678Z |
5278845 | 5278845 | 20241010133050_amb6B | NZ0025 | 2024-10-12T12:09:49.755Z | 2024-10-18T12:20:36.244Z |
5278829 | 5278829 | 20241010132735_BhPez | NZ0025 | 2024-10-12T12:09:45.705Z | 2024-10-18T12:20:35.760Z |
5278734 | 5278734 | 20241010131802_dQG3e | NZ0025 | 2024-10-12T12:09:29.091Z | 2024-10-18T12:20:35.230Z |
5278632 | 5278632 | 20241010130246_2p43Q | NZ0025 | 2024-10-12T12:09:18.299Z | 2024-10-18T12:20:34.100Z |
5278628 | 5278628 | 20241010125900_RsRio | NZ0025 | 2024-10-12T12:09:17.664Z | 2024-10-18T12:20:34.033Z |
5278594 | 5278594 | 20241010125448_XVktv | NZ0025 | 2024-10-12T12:09:15.150Z | 2024-10-18T12:20:33.771Z |
5278560 | 5278560 | 20241010124636_K7QIu | NZ0025 | 2024-10-12T12:09:11.954Z | 2024-10-18T12:20:33.454Z |
5273219 | 5273219 | 20241009164053_QBh0Z | NZ0025 | 2024-10-11T12:12:08.469Z | 2024-10-18T12:22:00.433Z |
5271710 | 5271710 | 20241010122942_XS7Qi | NZ0025 | 2024-10-11T12:07:27.355Z | 2024-10-18T12:20:32.337Z |
5271674 | 5271674 | 20241010122452_vm5el | NZ0025 | 2024-10-11T12:07:23.701Z | 2024-10-18T12:20:31.553Z |
5270595 | 5270595 | 20241010100030_2Czdf | NZ0025 | 2024-10-11T12:04:56.138Z | 2024-10-18T12:20:17.209Z |
5265945 | 5265945 | 20241008113502_3nGLT | NZ0025 | 2024-10-10T12:10:34.874Z | 2024-10-17T12:20:01.796Z |
5265842 | 5265842 | 20241008095807_A7s18 | NZ0025 | 2024-10-10T12:10:08.906Z | 2024-10-17T12:20:00.266Z |
5265839 | 5265839 | 20241008095659_ruZeL | NZ0025 | 2024-10-10T12:10:07.578Z | 2024-10-17T12:20:00.218Z |
5265834 | 5265834 | 20241008094833_N86bs | NZ0025 | 2024-10-10T12:10:02.672Z | 2024-10-17T12:20:00.029Z |
5243427 | 5243427 | 20241005171105_86Eb3 | NZ0025 | 2024-10-07T12:13:32.968Z | 2024-10-14T12:24:31.037Z |
5243409 | 5243409 | 20241005170505_Ly17J | NZ0025 | 2024-10-07T12:13:30.909Z | 2024-10-14T12:24:30.975Z |
5243277 | 5243277 | 20241005163809_cZsUg | NZ0025 | 2024-10-07T12:13:24.206Z | 2024-10-14T12:24:30.776Z |
5243230 | 5243230 | 20241005163041_xycMr | NZ0025 | 2024-10-07T12:13:22.049Z | 2024-10-14T12:24:30.628Z |
5243212 | 5243212 | 20241005162717_1uQ3L | NZ0025 | 2024-10-07T12:13:21.158Z | 2024-10-14T12:24:30.617Z |
5243077 | 5243077 | 20241005160454_7yNJA | NZ0025 | 2024-10-07T12:13:15.242Z | 2024-10-14T12:24:30.305Z |
5242895 | 5242895 | 20241005153652_UprjA | NZ0025 | 2024-10-07T12:12:59.491Z | 2024-10-14T12:24:29.966Z |
5242850 | 5242850 | 20241005152408_XpGWz | NZ0025 | 2024-10-07T12:12:53.086Z | 2024-10-14T12:24:29.902Z |
5242830 | 5242830 | 20241005152057_CTNDZ | NZ0025 | 2024-10-07T12:12:50.052Z | 2024-10-14T12:24:29.863Z |
5242827 | 5242827 | 20241005152036_mjhAA | NZ0025 | 2024-10-07T12:12:49.874Z | 2024-10-14T12:24:29.830Z |
5242812 | 5242812 | 20241005151929_upsUF | NZ0025 | 2024-10-07T12:12:48.112Z | 2024-10-14T12:24:29.823Z |
5242569 | 5242569 | 20241005142920_qkejm | NZ0025 | 2024-10-07T12:12:22.441Z | 2024-10-14T12:24:29.297Z |
5242565 | 5242565 | 20241005142842_G5gjW | NZ0025 | 2024-10-07T12:12:21.846Z | 2024-10-14T12:24:29.295Z |
5242561 | 5242561 | 20241005142749_naQo9 | NZ0025 | 2024-10-07T12:12:21.703Z | 2024-10-14T12:24:29.274Z |
5242366 | 5242366 | 20241005135659_hZqr7 | NZ0025 | 2024-10-07T12:12:05.658Z | 2024-10-14T12:24:28.887Z |
5241991 | 5241991 | 20241005121855_bWRXe | NZ0025 | 2024-10-07T12:11:30.148Z | 2024-10-14T12:24:28.277Z |
5240963 | 5240963 | 20241005090657_cQOC4 | NZ0025 | 2024-10-07T12:09:34.207Z | 2024-10-14T12:24:25.092Z |
5231667 | 5231667 | 20241004150649_kD5Cf | NZ0025 | 2024-10-06T12:10:38.282Z | 2024-10-13T12:26:18.133Z |
5231645 | 5231645 | 20241004150417_Fk2jC | NZ0025 | 2024-10-06T12:10:35.682Z | 2024-10-13T12:26:18.090Z |
5231220 | 5231220 | 20241004135215_9NEDW | NZ0025 | 2024-10-06T12:09:57.253Z | 2024-10-13T12:26:17.486Z |
5231197 | 5231197 | 20241004134820_rbn8I | NZ0025 | 2024-10-06T12:09:53.987Z | 2024-10-13T12:26:17.467Z |
5231154 | 5231154 | 20241004133609_tC2qX | NZ0025 | 2024-10-06T12:09:50.252Z | 2024-10-13T12:26:17.369Z |
5230714 | 5230714 | 20241004123054_9BCsh | NZ0025 | 2024-10-06T12:09:05.984Z | 2024-10-13T12:26:16.775Z |
5230364 | 5230364 | 20241004115053_A3DeU | NZ0025 | 2024-10-06T12:08:28.038Z | 2024-10-13T12:26:16.157Z |
5198187 | 5198187 | 20240929172238_8sUzw | NZ0025 | 2024-10-01T12:14:28.854Z | 2024-10-07T12:21:30.875Z |
5198137 | 5198137 | 20240929170928_gIUe8 | NZ0025 | 2024-10-01T12:14:22.579Z | 2024-10-07T12:21:30.738Z |
5197947 | 5197947 | 20240929163326_58ag2 | NZ0025 | 2024-10-01T12:14:03.445Z | 2024-10-07T12:21:30.198Z |
5197939 | 5197939 | 20240929163248_c34eZ | NZ0025 | 2024-10-01T12:14:01.847Z | 2024-10-07T12:21:30.191Z |
5197703 | 5197703 | 20240929155337_nhti9 | NZ0025 | 2024-10-01T12:13:43.783Z | 2024-10-07T12:21:29.670Z |
5194244 | 5194244 | 20240929154153_Zjb1h | NZ0025 | 2024-09-30T12:19:35.591Z | 2024-10-07T12:21:29.528Z |
5173551 | 5173551 | 20240927150800_JtrqK | NZ0025 | 2024-09-28T12:12:30.486Z | 2024-10-05T12:28:55.677Z |
5173420 | 5173420 | 20240927144933_YaGM4 | NZ0025 | 2024-09-28T12:12:17.347Z | 2024-10-05T12:28:55.507Z |
5173405 | 5173405 | 20240927144843_CA9HI | NZ0025 | 2024-09-28T12:12:15.743Z | 2024-10-05T12:28:55.502Z |
5167960 | 5167960 | 20240926164250_U3Pnv | NZ0025 | 2024-09-27T12:06:18.489Z | 2024-10-04T12:25:31.443Z |
5167885 | 5167885 | 20240926160528_2tz1j | NZ0025 | 2024-09-27T12:06:02.080Z | 2024-10-04T12:25:30.796Z |
5163105 | 5163105 | 20240924133347_k2MPc | NZ0025 | 2024-09-26T12:11:26.121Z | 2024-10-02T12:18:59.275Z |
5163060 | 5163060 | 20240924132502_c2GuG | NZ0025 | 2024-09-26T12:11:22.338Z | 2024-10-02T12:18:59.004Z |
5162013 | 5162013 | 20240924103721_xBmFj | NZ0025 | 2024-09-26T12:10:20.256Z | 2024-10-02T12:18:56.090Z |
5162011 | 5162011 | 20240924103651_uVwxP | NZ0025 | 2024-09-26T12:10:19.496Z | 2024-10-02T12:18:56.074Z |
5162004 | 5162004 | 20240924103536_R2wQG | NZ0025 | 2024-09-26T12:10:18.048Z | 2024-10-02T12:18:55.969Z |
5161954 | 5161954 | 20240924102702_58jo5 | NZ0025 | 2024-09-26T12:10:13.166Z | 2024-10-02T12:18:55.898Z |
5157565 | 5157565 | 20240924095800_5KlWC | NZ0025 | 2024-09-25T12:10:52.068Z | 2024-10-02T12:18:54.898Z |
5157348 | 5157348 | 20240924091826_KtPru | NZ0025 | 2024-09-25T12:10:25.048Z | 2024-10-02T12:18:54.215Z |
5152859 | 5152859 | 20240923103855_xucaJ | NZ0025 | 2024-09-24T12:05:15.590Z | 2024-10-01T12:22:16.351Z |
5152734 | 5152734 | 20240923101633_mu5p4 | NZ0025 | 2024-09-24T12:05:07.230Z | 2024-10-01T12:22:16.070Z |
5152555 | 5152555 | 20240923094417_gREiZ | NZ0025 | 2024-09-24T12:04:55.947Z | 2024-10-01T12:22:14.886Z |
5143729 | 5143729 | 20240921081202_wLu04 | NZ0025 | 2024-09-22T12:05:26.603Z | 2024-09-29T12:22:09.540Z |
5141052 | 5141052 | 20240920143526_wEM4I | NZ0025 | 2024-09-21T12:04:52.174Z | 2024-09-28T12:23:24.106Z |
5141050 | 5141050 | 20240920143505_eJlH5 | NZ0025 | 2024-09-21T12:04:52.022Z | 2024-09-28T12:23:24.104Z |
5140948 | 5140948 | 20240920135544_IODI7 | NZ0025 | 2024-09-21T12:04:43.976Z | 2024-09-28T12:23:23.661Z |
5140681 | 5140681 | 20240920114303_19oKz | NZ0025 | 2024-09-21T12:04:28.485Z | 2024-09-28T12:23:22.457Z |
5140531 | 5140531 | 20240920104257_wROXE | NZ0025 | 2024-09-21T12:04:12.462Z | 2024-09-28T12:23:21.310Z |
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);