participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
196 rows where station_code = "NZ003L" 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 |
---|---|---|---|---|---|
5265630 | 5265630 | 20241009142526_E3AEO | NZ003L | 2024-10-10T12:07:38.961Z | 2024-10-18T12:21:56.560Z |
5265617 | 5265617 | 20241009141910_Q2WAT | NZ003L | 2024-10-10T12:07:34.463Z | 2024-10-18T12:21:56.167Z |
5265596 | 5265596 | 20241009140118_ftYfg | NZ003L | 2024-10-10T12:07:27.478Z | 2024-10-18T12:21:55.733Z |
5265555 | 5265555 | 20241009132834_Lnc70 | NZ003L | 2024-10-10T12:07:20.327Z | 2024-10-18T12:21:54.992Z |
5265442 | 5265442 | 20241009121442_lgVUH | NZ003L | 2024-10-10T12:07:05.627Z | 2024-10-18T12:21:53.031Z |
5265327 | 5265327 | 20241009114025_wN7h8 | NZ003L | 2024-10-10T12:06:44.604Z | 2024-10-18T12:21:50.852Z |
5264177 | 5264177 | 20241009074909_ZlkOe | NZ003L | 2024-10-10T12:03:16.919Z | 2024-10-18T12:21:41.766Z |
5251501 | 5251501 | 20241006123117_rD22l | NZ003L | 2024-10-08T12:10:06.554Z | 2024-10-15T12:28:53.371Z |
5207712 | 5207712 | 20241002094201_W2L6T | NZ003L | 2024-10-03T12:06:24.527Z | 2024-10-11T12:23:26.995Z |
5193592 | 5193592 | 20240929124704_5C8m3 | NZ003L | 2024-09-30T12:19:21.405Z | 2024-10-07T12:21:26.565Z |
5173505 | 5173505 | 20240927150452_W6PD2 | NZ003L | 2024-09-28T12:12:23.993Z | 2024-10-05T12:28:55.652Z |
5172695 | 5172695 | 20240927132411_5f7Ta | NZ003L | 2024-09-28T12:11:16.175Z | 2024-10-05T12:28:53.329Z |
5172275 | 5172275 | 20240927120802_3WHK5 | NZ003L | 2024-09-28T12:10:30.343Z | 2024-10-05T12:28:51.120Z |
5166612 | 5166612 | 20240926074718_XyU30 | NZ003L | 2024-09-27T12:03:09.182Z | 2024-10-04T12:25:16.717Z |
5166586 | 5166586 | 20240926074006_INfdx | NZ003L | 2024-09-27T12:03:06.558Z | 2024-10-04T12:25:16.558Z |
5153047 | 5153047 | 20240923111330_rvSrH | NZ003L | 2024-09-24T12:05:47.324Z | 2024-10-01T12:22:16.893Z |
5152822 | 5152822 | 20240923103246_ORMUd | NZ003L | 2024-09-24T12:05:13.558Z | 2024-10-01T12:22:16.302Z |
5152680 | 5152680 | 20240923100833_fje1m | NZ003L | 2024-09-24T12:05:04.270Z | 2024-10-01T12:22:15.616Z |
5152419 | 5152419 | 20240923092014_6Yqbk | NZ003L | 2024-09-24T12:04:42.467Z | 2024-10-01T12:22:14.558Z |
5147492 | 5147492 | 20240922073017_3BWJL | NZ003L | 2024-09-23T12:05:13.279Z | 2024-09-30T12:22:43.698Z |
5147472 | 5147472 | 20240922072617_zYeYd | NZ003L | 2024-09-23T12:05:09.612Z | 2024-09-30T12:22:43.657Z |
5123234 | 5123234 | 20240914092143_YpZFJ | NZ003L | 2024-09-18T12:11:43.143Z | 2024-09-22T12:18:07.066Z |
5083416 | 5083416 | 20240911131454_IK3xA | NZ003L | 2024-09-15T12:18:41.735Z | 2024-09-19T12:21:49.567Z |
5082877 | 5082877 | 20240911111837_0Mal2 | NZ003L | 2024-09-15T12:18:28.525Z | 2024-09-19T12:21:48.800Z |
5071151 | 5071151 | 20240911160626_im2nS | NZ003L | 2024-09-15T12:01:48.105Z | 2024-09-20T12:21:19.772Z |
5070916 | 5070916 | 20240911152828_FfPvC | NZ003L | 2024-09-15T12:01:08.825Z | 2024-09-20T12:21:18.628Z |
5070626 | 5070626 | 20240911144238_OKWY3 | NZ003L | 2024-09-15T12:00:26.025Z | 2024-09-20T12:21:16.148Z |
5044426 | 5044426 | 20240908150054_aQqrb | NZ003L | 2024-09-13T12:02:10.110Z | 2024-09-17T12:18:54.383Z |
5044156 | 5044156 | 20240908141913_T0yYS | NZ003L | 2024-09-13T12:01:34.596Z | 2024-09-17T12:18:53.607Z |
5036673 | 5036673 | 20240905141356_DcyN4 | NZ003L | 2024-09-12T12:13:51.873Z | 2024-09-14T12:22:53.084Z |
5017613 | 5017613 | 20240904162422_4YVsq | NZ003L | 2024-09-10T12:09:19.867Z | 2024-09-13T12:19:47.007Z |
5017152 | 5017152 | 20240904153423_G083l | NZ003L | 2024-09-10T12:08:52.726Z | 2024-09-13T12:19:46.615Z |
4984697 | 4984697 | 20240901104107_4f3CK | NZ003L | 2024-09-07T12:02:17.379Z | 2024-09-10T12:19:05.866Z |
4951147 | 4951147 | 20240811131005_HQ3ya | NZ003L | 2024-09-03T12:00:33.034Z | 2024-09-06T12:00:26.629Z |
4932046 | 4932046 | 20240810114234_8PY13 | NZ003L | 2024-08-31T12:25:17.551Z | 2024-09-02T12:31:21.175Z |
4931328 | 4931328 | 20240810101538_z5yGJ | NZ003L | 2024-08-31T12:24:30.538Z | 2024-09-02T12:30:48.536Z |
4931148 | 4931148 | 20240810094808_lGPu0 | NZ003L | 2024-08-31T12:24:17.863Z | 2024-09-02T12:30:41.022Z |
4930356 | 4930356 | 20240810075952_PsmnS | NZ003L | 2024-08-31T12:23:23.582Z | 2024-09-02T12:30:09.308Z |
4924966 | 4924966 | 20240810142824_T3DHr | NZ003L | 2024-08-31T12:02:46.920Z | 2024-09-06T12:17:18.110Z |
4923597 | 4923597 | 20240810121536_RI74C | NZ003L | 2024-08-31T12:00:47.844Z | 2024-09-06T12:16:06.743Z |
4907370 | 4907370 | 20240809141411_sKuW6 | NZ003L | 2024-08-29T12:02:58.371Z | 2024-09-02T12:18:20.649Z |
4907247 | 4907247 | 20240809140201_iqfnU | NZ003L | 2024-08-29T12:02:49.063Z | 2024-09-02T12:18:16.308Z |
4906924 | 4906924 | 20240809132831_jx6Hw | NZ003L | 2024-08-29T12:02:26.178Z | 2024-09-02T12:18:02.247Z |
4906846 | 4906846 | 20240809131934_DDWFT | NZ003L | 2024-08-29T12:02:20.912Z | 2024-09-02T12:17:59.978Z |
4906747 | 4906747 | 20240809131130_Vgnuz | NZ003L | 2024-08-29T12:02:14.048Z | 2024-09-02T12:17:57.148Z |
4906560 | 4906560 | 20240809125100_2IiSU | NZ003L | 2024-08-29T12:02:00.606Z | 2024-09-02T12:17:42.222Z |
4906230 | 4906230 | 20240809121650_W9QHB | NZ003L | 2024-08-29T12:01:37.211Z | 2024-09-02T12:17:30.488Z |
4897075 | 4897075 | 20240807170605_RbQFg | NZ003L | 2024-08-28T12:15:02.938Z | 2024-08-28T12:15:02.938Z |
4896865 | 4896865 | 20240807163328_X4e7w | NZ003L | 2024-08-28T12:14:49.895Z | 2024-08-28T12:14:49.895Z |
4896731 | 4896731 | 20240807161219_xjOFx | NZ003L | 2024-08-28T12:14:43.208Z | 2024-08-28T12:14:43.208Z |
4896629 | 4896629 | 20240807155015_dqPRl | NZ003L | 2024-08-28T12:14:37.976Z | 2024-08-28T12:14:37.976Z |
4896477 | 4896477 | 20240807151657_dcxm0 | NZ003L | 2024-08-28T12:14:23.006Z | 2024-08-28T12:14:23.006Z |
4896443 | 4896443 | 20240807150935_x3jNJ | NZ003L | 2024-08-28T12:14:18.161Z | 2024-08-28T12:14:18.161Z |
4896370 | 4896370 | 20240807145804_UslZ7 | NZ003L | 2024-08-28T12:14:14.909Z | 2024-08-28T12:14:14.909Z |
4896220 | 4896220 | 20240807143915_gC0tn | NZ003L | 2024-08-28T12:14:06.164Z | 2024-08-28T12:14:06.164Z |
4896145 | 4896145 | 20240807142352_odjVE | NZ003L | 2024-08-28T12:14:02.086Z | 2024-08-28T12:14:02.086Z |
4896143 | 4896143 | 20240807142338_CKrdo | NZ003L | 2024-08-28T12:14:01.952Z | 2024-08-28T12:14:01.952Z |
4895816 | 4895816 | 20240807132544_WlY1D | NZ003L | 2024-08-28T12:13:39.378Z | 2024-08-28T12:13:39.378Z |
4895804 | 4895804 | 20240807132348_BWPq9 | NZ003L | 2024-08-28T12:13:38.976Z | 2024-08-28T12:13:38.976Z |
4895486 | 4895486 | 20240807123738_FmuEw | NZ003L | 2024-08-28T12:13:24.933Z | 2024-08-28T12:13:24.933Z |
4895047 | 4895047 | 20240807111341_NAfqt | NZ003L | 2024-08-28T12:12:57.397Z | 2024-08-28T12:12:57.397Z |
4894809 | 4894809 | 20240807104349_L0Xhq | NZ003L | 2024-08-28T12:12:44.565Z | 2024-08-28T12:12:44.565Z |
4888160 | 4888160 | 20240808172954_41Cml | NZ003L | 2024-08-28T12:04:19.199Z | 2024-08-30T12:18:01.573Z |
4869954 | 4869954 | 20240806173830_RslkW | NZ003L | 2024-08-19T12:07:24.771Z | 2024-08-27T12:08:25.121Z |
4869342 | 4869342 | 20240806171311_qFolM | NZ003L | 2024-08-19T12:07:05.157Z | 2024-08-27T12:08:05.759Z |
4869170 | 4869170 | 20240806170440_ewNXx | NZ003L | 2024-08-19T12:06:53.394Z | 2024-08-27T12:07:59.991Z |
4868161 | 4868161 | 20240806055348_w0YMQ | NZ003L | 2024-08-18T12:24:01.029Z | 2024-08-19T12:28:37.733Z |
4866956 | 4866956 | 20240806161424_h6bkk | NZ003L | 2024-08-18T12:08:11.589Z | 2024-08-27T12:07:20.519Z |
4865879 | 4865879 | 20240806151900_5tzAM | NZ003L | 2024-08-18T12:07:16.617Z | 2024-08-27T12:06:34.196Z |
4863818 | 4863818 | 20240806134329_Admu2 | NZ003L | 2024-08-18T12:05:27.338Z | 2024-08-27T12:05:10.841Z |
4863058 | 4863058 | 20240806130506_ocKCE | NZ003L | 2024-08-18T12:04:58.487Z | 2024-08-27T12:04:38.051Z |
4862711 | 4862711 | 20240806124805_1CpgI | NZ003L | 2024-08-18T12:04:37.491Z | 2024-08-27T12:04:27.203Z |
4862678 | 4862678 | 20240806124622_lTqRB | NZ003L | 2024-08-18T12:04:36.255Z | 2024-08-27T12:04:24.655Z |
4862128 | 4862128 | 20240806121624_aM4Gu | NZ003L | 2024-08-18T12:04:11.121Z | 2024-08-27T12:04:02.556Z |
4862023 | 4862023 | 20240806121117_xmlKp | NZ003L | 2024-08-18T12:04:07.167Z | 2024-08-27T12:03:59.115Z |
4861550 | 4861550 | 20240806114049_Z9S3a | NZ003L | 2024-08-18T12:03:46.385Z | 2024-08-27T12:03:38.288Z |
4860151 | 4860151 | 20240806102042_2bykZ | NZ003L | 2024-08-18T12:02:32.051Z | 2024-08-27T12:02:32.365Z |
4859798 | 4859798 | 20240806100052_qlRWw | NZ003L | 2024-08-18T12:02:10.187Z | 2024-08-27T12:02:15.553Z |
4859745 | 4859745 | 20240806095734_lBoWv | NZ003L | 2024-08-18T12:02:05.956Z | 2024-08-27T12:02:12.947Z |
4788094 | 4788094 | 20240802083155_Ipyph | NZ003L | 2024-08-11T12:03:47.386Z | 2024-08-13T12:15:44.360Z |
4787948 | 4787948 | 20240802080942_1oDfC | NZ003L | 2024-08-11T12:03:24.528Z | 2024-08-13T12:15:42.649Z |
4787346 | 4787346 | 20240802061256_8gMJ8 | NZ003L | 2024-08-11T12:01:43.697Z | 2024-08-13T12:15:28.233Z |
4775704 | 4775704 | 20240801133624_tx73T | NZ003L | 2024-08-07T12:08:46.247Z | 2024-08-11T12:12:42.285Z |
4775532 | 4775532 | 20240801132330_3GqIQ | NZ003L | 2024-08-07T12:08:41.696Z | 2024-08-11T12:12:40.996Z |
4775109 | 4775109 | 20240801124946_Xl7WL | NZ003L | 2024-08-07T12:08:13.288Z | 2024-08-11T12:12:34.718Z |
4774334 | 4774334 | 20240801113129_H204L | NZ003L | 2024-08-07T12:07:19.847Z | 2024-08-11T12:12:19.895Z |
4773794 | 4773794 | 20240801103517_V90jz | NZ003L | 2024-08-07T12:06:25.487Z | 2024-08-11T12:12:07.470Z |
4725877 | 4725877 | 20240728150704_Gggwr | NZ003L | 2024-07-31T12:11:47.615Z | 2024-08-05T12:20:21.570Z |
4725843 | 4725843 | 20240728145642_7tGly | NZ003L | 2024-07-31T12:11:45.510Z | 2024-08-05T12:20:21.528Z |
4725704 | 4725704 | 20240728142303_gPH92 | NZ003L | 2024-07-31T12:11:38.224Z | 2024-08-05T12:20:21.151Z |
4725667 | 4725667 | 20240728141428_8Ae6L | NZ003L | 2024-07-31T12:11:36.457Z | 2024-08-05T12:20:21.035Z |
4693218 | 4693218 | 20240726110338_v3CFd | NZ003L | 2024-07-27T12:08:32.088Z | 2024-08-03T12:21:38.748Z |
4692962 | 4692962 | 20240726103256_aTADx | NZ003L | 2024-07-27T12:08:19.170Z | 2024-08-03T12:21:37.465Z |
4692940 | 4692940 | 20240726103010_B3D3V | NZ003L | 2024-07-27T12:08:17.727Z | 2024-08-03T12:21:37.295Z |
4659582 | 4659582 | 20240718145550_sjZei | NZ003L | 2024-07-19T12:00:27.500Z | 2024-07-27T12:16:47.365Z |
4636917 | 4636917 | 20240714140753_D1fDQ | NZ003L | 2024-07-16T12:02:04.405Z | 2024-07-23T12:08:35.571Z |
4632068 | 4632068 | 20240712142918_os9lC | NZ003L | 2024-07-15T12:05:09.922Z | 2024-07-21T12:13:25.557Z |
4631901 | 4631901 | 20240712140719_m6Q3n | NZ003L | 2024-07-15T12:04:59.007Z | 2024-07-21T12:13:25.484Z |
4624830 | 4624830 | 20240711134052_ZcpCP | NZ003L | 2024-07-14T12:06:00.731Z | 2024-07-20T12:13:09.718Z |
4601573 | 4601573 | 20240708174159_1wRhc | NZ003L | 2024-07-11T12:08:28.077Z | 2024-07-16T12:09:21.408Z |
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);