participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
197 rows where station_code = "NZ003M" 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 |
---|---|---|---|---|---|
5265631 | 5265631 | 20241009142526_E3AEO | NZ003M | 2024-10-10T12:07:38.961Z | 2024-10-18T12:21:56.560Z |
5265618 | 5265618 | 20241009141910_Q2WAT | NZ003M | 2024-10-10T12:07:34.463Z | 2024-10-18T12:21:56.167Z |
5265597 | 5265597 | 20241009140118_ftYfg | NZ003M | 2024-10-10T12:07:27.478Z | 2024-10-18T12:21:55.733Z |
5265556 | 5265556 | 20241009132834_Lnc70 | NZ003M | 2024-10-10T12:07:20.327Z | 2024-10-18T12:21:54.992Z |
5265443 | 5265443 | 20241009121442_lgVUH | NZ003M | 2024-10-10T12:07:05.627Z | 2024-10-18T12:21:53.031Z |
5265328 | 5265328 | 20241009114025_wN7h8 | NZ003M | 2024-10-10T12:06:44.604Z | 2024-10-18T12:21:50.852Z |
5264178 | 5264178 | 20241009074909_ZlkOe | NZ003M | 2024-10-10T12:03:16.919Z | 2024-10-18T12:21:41.766Z |
5251502 | 5251502 | 20241006123117_rD22l | NZ003M | 2024-10-08T12:10:06.554Z | 2024-10-15T12:28:53.371Z |
5207713 | 5207713 | 20241002094201_W2L6T | NZ003M | 2024-10-03T12:06:24.569Z | 2024-10-11T12:23:26.995Z |
5193593 | 5193593 | 20240929124704_5C8m3 | NZ003M | 2024-09-30T12:19:21.405Z | 2024-10-07T12:21:26.565Z |
5173506 | 5173506 | 20240927150452_W6PD2 | NZ003M | 2024-09-28T12:12:23.993Z | 2024-10-05T12:28:55.652Z |
5172696 | 5172696 | 20240927132411_5f7Ta | NZ003M | 2024-09-28T12:11:16.175Z | 2024-10-05T12:28:53.329Z |
5172276 | 5172276 | 20240927120802_3WHK5 | NZ003M | 2024-09-28T12:10:30.343Z | 2024-10-05T12:28:51.120Z |
5166613 | 5166613 | 20240926074718_XyU30 | NZ003M | 2024-09-27T12:03:09.182Z | 2024-10-04T12:25:16.717Z |
5166587 | 5166587 | 20240926074006_INfdx | NZ003M | 2024-09-27T12:03:06.568Z | 2024-10-04T12:25:16.558Z |
5153048 | 5153048 | 20240923111330_rvSrH | NZ003M | 2024-09-24T12:05:47.324Z | 2024-10-01T12:22:16.893Z |
5152823 | 5152823 | 20240923103246_ORMUd | NZ003M | 2024-09-24T12:05:13.558Z | 2024-10-01T12:22:16.303Z |
5152681 | 5152681 | 20240923100833_fje1m | NZ003M | 2024-09-24T12:05:04.270Z | 2024-10-01T12:22:15.616Z |
5152420 | 5152420 | 20240923092014_6Yqbk | NZ003M | 2024-09-24T12:04:42.467Z | 2024-10-01T12:22:14.558Z |
5147493 | 5147493 | 20240922073017_3BWJL | NZ003M | 2024-09-23T12:05:13.279Z | 2024-09-30T12:22:43.698Z |
5147473 | 5147473 | 20240922072617_zYeYd | NZ003M | 2024-09-23T12:05:09.612Z | 2024-09-30T12:22:43.657Z |
5123235 | 5123235 | 20240914092143_YpZFJ | NZ003M | 2024-09-18T12:11:43.143Z | 2024-09-22T12:18:07.066Z |
5083417 | 5083417 | 20240911131454_IK3xA | NZ003M | 2024-09-15T12:18:41.735Z | 2024-09-19T12:21:49.567Z |
5082878 | 5082878 | 20240911111837_0Mal2 | NZ003M | 2024-09-15T12:18:28.525Z | 2024-09-19T12:21:48.800Z |
5071152 | 5071152 | 20240911160626_im2nS | NZ003M | 2024-09-15T12:01:48.105Z | 2024-09-20T12:21:19.772Z |
5070917 | 5070917 | 20240911152828_FfPvC | NZ003M | 2024-09-15T12:01:08.825Z | 2024-09-20T12:21:18.628Z |
5070627 | 5070627 | 20240911144238_OKWY3 | NZ003M | 2024-09-15T12:00:26.025Z | 2024-09-20T12:21:16.148Z |
5044427 | 5044427 | 20240908150054_aQqrb | NZ003M | 2024-09-13T12:02:10.110Z | 2024-09-17T12:18:54.383Z |
5044157 | 5044157 | 20240908141913_T0yYS | NZ003M | 2024-09-13T12:01:34.596Z | 2024-09-17T12:18:53.607Z |
5036674 | 5036674 | 20240905141356_DcyN4 | NZ003M | 2024-09-12T12:13:51.873Z | 2024-09-14T12:22:53.084Z |
5017614 | 5017614 | 20240904162422_4YVsq | NZ003M | 2024-09-10T12:09:19.867Z | 2024-09-13T12:19:47.008Z |
5017153 | 5017153 | 20240904153423_G083l | NZ003M | 2024-09-10T12:08:52.726Z | 2024-09-13T12:19:46.615Z |
4984698 | 4984698 | 20240901104107_4f3CK | NZ003M | 2024-09-07T12:02:17.379Z | 2024-09-10T12:19:05.866Z |
4951148 | 4951148 | 20240811131005_HQ3ya | NZ003M | 2024-09-03T12:00:33.042Z | 2024-09-06T12:00:26.629Z |
4932047 | 4932047 | 20240810114234_8PY13 | NZ003M | 2024-08-31T12:25:17.551Z | 2024-09-02T12:31:21.175Z |
4931329 | 4931329 | 20240810101538_z5yGJ | NZ003M | 2024-08-31T12:24:30.538Z | 2024-09-02T12:30:48.536Z |
4931149 | 4931149 | 20240810094808_lGPu0 | NZ003M | 2024-08-31T12:24:17.864Z | 2024-09-02T12:30:41.022Z |
4930357 | 4930357 | 20240810075952_PsmnS | NZ003M | 2024-08-31T12:23:23.587Z | 2024-09-02T12:30:09.308Z |
4924967 | 4924967 | 20240810142824_T3DHr | NZ003M | 2024-08-31T12:02:46.920Z | 2024-09-06T12:17:18.110Z |
4923598 | 4923598 | 20240810121536_RI74C | NZ003M | 2024-08-31T12:00:47.844Z | 2024-09-06T12:16:06.743Z |
4907371 | 4907371 | 20240809141411_sKuW6 | NZ003M | 2024-08-29T12:02:58.371Z | 2024-09-02T12:18:20.649Z |
4907248 | 4907248 | 20240809140201_iqfnU | NZ003M | 2024-08-29T12:02:49.063Z | 2024-09-02T12:18:16.308Z |
4906925 | 4906925 | 20240809132831_jx6Hw | NZ003M | 2024-08-29T12:02:26.178Z | 2024-09-02T12:18:02.247Z |
4906847 | 4906847 | 20240809131934_DDWFT | NZ003M | 2024-08-29T12:02:20.912Z | 2024-09-02T12:17:59.978Z |
4906748 | 4906748 | 20240809131130_Vgnuz | NZ003M | 2024-08-29T12:02:14.048Z | 2024-09-02T12:17:57.148Z |
4906561 | 4906561 | 20240809125100_2IiSU | NZ003M | 2024-08-29T12:02:00.606Z | 2024-09-02T12:17:42.222Z |
4906231 | 4906231 | 20240809121650_W9QHB | NZ003M | 2024-08-29T12:01:37.218Z | 2024-09-02T12:17:30.488Z |
4897076 | 4897076 | 20240807170605_RbQFg | NZ003M | 2024-08-28T12:15:02.938Z | 2024-08-28T12:15:02.938Z |
4896866 | 4896866 | 20240807163328_X4e7w | NZ003M | 2024-08-28T12:14:49.895Z | 2024-08-28T12:14:49.895Z |
4896732 | 4896732 | 20240807161219_xjOFx | NZ003M | 2024-08-28T12:14:43.208Z | 2024-08-28T12:14:43.208Z |
4896630 | 4896630 | 20240807155015_dqPRl | NZ003M | 2024-08-28T12:14:37.976Z | 2024-08-28T12:14:37.976Z |
4896478 | 4896478 | 20240807151657_dcxm0 | NZ003M | 2024-08-28T12:14:23.006Z | 2024-08-28T12:14:23.006Z |
4896444 | 4896444 | 20240807150935_x3jNJ | NZ003M | 2024-08-28T12:14:18.161Z | 2024-08-28T12:14:18.161Z |
4896371 | 4896371 | 20240807145804_UslZ7 | NZ003M | 2024-08-28T12:14:14.909Z | 2024-08-28T12:14:14.909Z |
4896221 | 4896221 | 20240807143915_gC0tn | NZ003M | 2024-08-28T12:14:06.164Z | 2024-08-28T12:14:06.164Z |
4896146 | 4896146 | 20240807142352_odjVE | NZ003M | 2024-08-28T12:14:02.087Z | 2024-08-28T12:14:02.087Z |
4896144 | 4896144 | 20240807142338_CKrdo | NZ003M | 2024-08-28T12:14:01.952Z | 2024-08-28T12:14:01.952Z |
4895817 | 4895817 | 20240807132544_WlY1D | NZ003M | 2024-08-28T12:13:39.378Z | 2024-08-28T12:13:39.378Z |
4895805 | 4895805 | 20240807132348_BWPq9 | NZ003M | 2024-08-28T12:13:38.976Z | 2024-08-28T12:13:38.976Z |
4895487 | 4895487 | 20240807123738_FmuEw | NZ003M | 2024-08-28T12:13:24.933Z | 2024-08-28T12:13:24.933Z |
4895048 | 4895048 | 20240807111341_NAfqt | NZ003M | 2024-08-28T12:12:57.397Z | 2024-08-28T12:12:57.397Z |
4894810 | 4894810 | 20240807104349_L0Xhq | NZ003M | 2024-08-28T12:12:44.565Z | 2024-08-28T12:12:44.565Z |
4888161 | 4888161 | 20240808172954_41Cml | NZ003M | 2024-08-28T12:04:19.199Z | 2024-08-30T12:18:01.573Z |
4869955 | 4869955 | 20240806173830_RslkW | NZ003M | 2024-08-19T12:07:24.777Z | 2024-08-27T12:08:25.121Z |
4869343 | 4869343 | 20240806171311_qFolM | NZ003M | 2024-08-19T12:07:05.157Z | 2024-08-27T12:08:05.759Z |
4869171 | 4869171 | 20240806170440_ewNXx | NZ003M | 2024-08-19T12:06:53.399Z | 2024-08-27T12:07:59.991Z |
4868162 | 4868162 | 20240806055348_w0YMQ | NZ003M | 2024-08-18T12:24:01.029Z | 2024-08-19T12:28:37.733Z |
4866957 | 4866957 | 20240806161424_h6bkk | NZ003M | 2024-08-18T12:08:11.589Z | 2024-08-27T12:07:20.519Z |
4865880 | 4865880 | 20240806151900_5tzAM | NZ003M | 2024-08-18T12:07:16.617Z | 2024-08-27T12:06:34.196Z |
4863819 | 4863819 | 20240806134329_Admu2 | NZ003M | 2024-08-18T12:05:27.338Z | 2024-08-27T12:05:10.841Z |
4863059 | 4863059 | 20240806130506_ocKCE | NZ003M | 2024-08-18T12:04:58.487Z | 2024-08-27T12:04:38.051Z |
4862712 | 4862712 | 20240806124805_1CpgI | NZ003M | 2024-08-18T12:04:37.491Z | 2024-08-27T12:04:27.203Z |
4862679 | 4862679 | 20240806124622_lTqRB | NZ003M | 2024-08-18T12:04:36.255Z | 2024-08-27T12:04:24.655Z |
4862129 | 4862129 | 20240806121624_aM4Gu | NZ003M | 2024-08-18T12:04:11.121Z | 2024-08-27T12:04:02.556Z |
4862024 | 4862024 | 20240806121117_xmlKp | NZ003M | 2024-08-18T12:04:07.167Z | 2024-08-27T12:03:59.115Z |
4861551 | 4861551 | 20240806114049_Z9S3a | NZ003M | 2024-08-18T12:03:46.385Z | 2024-08-27T12:03:38.288Z |
4860152 | 4860152 | 20240806102042_2bykZ | NZ003M | 2024-08-18T12:02:32.051Z | 2024-08-27T12:02:32.365Z |
4859799 | 4859799 | 20240806100052_qlRWw | NZ003M | 2024-08-18T12:02:10.187Z | 2024-08-27T12:02:15.553Z |
4859746 | 4859746 | 20240806095734_lBoWv | NZ003M | 2024-08-18T12:02:05.959Z | 2024-08-27T12:02:12.947Z |
4788095 | 4788095 | 20240802083155_Ipyph | NZ003M | 2024-08-11T12:03:47.386Z | 2024-08-13T12:15:44.360Z |
4787949 | 4787949 | 20240802080942_1oDfC | NZ003M | 2024-08-11T12:03:24.528Z | 2024-08-13T12:15:42.649Z |
4787347 | 4787347 | 20240802061256_8gMJ8 | NZ003M | 2024-08-11T12:01:43.716Z | 2024-08-13T12:15:28.233Z |
4775705 | 4775705 | 20240801133624_tx73T | NZ003M | 2024-08-07T12:08:46.247Z | 2024-08-11T12:12:42.285Z |
4775533 | 4775533 | 20240801132330_3GqIQ | NZ003M | 2024-08-07T12:08:41.696Z | 2024-08-11T12:12:40.996Z |
4775110 | 4775110 | 20240801124946_Xl7WL | NZ003M | 2024-08-07T12:08:13.288Z | 2024-08-11T12:12:34.718Z |
4774335 | 4774335 | 20240801113129_H204L | NZ003M | 2024-08-07T12:07:19.847Z | 2024-08-11T12:12:19.895Z |
4773795 | 4773795 | 20240801103517_V90jz | NZ003M | 2024-08-07T12:06:25.507Z | 2024-08-11T12:12:07.470Z |
4725878 | 4725878 | 20240728150704_Gggwr | NZ003M | 2024-07-31T12:11:47.615Z | 2024-08-05T12:20:21.570Z |
4725844 | 4725844 | 20240728145642_7tGly | NZ003M | 2024-07-31T12:11:45.510Z | 2024-08-05T12:20:21.528Z |
4725705 | 4725705 | 20240728142303_gPH92 | NZ003M | 2024-07-31T12:11:38.224Z | 2024-08-05T12:20:21.151Z |
4725668 | 4725668 | 20240728141428_8Ae6L | NZ003M | 2024-07-31T12:11:36.457Z | 2024-08-05T12:20:21.035Z |
4693219 | 4693219 | 20240726110338_v3CFd | NZ003M | 2024-07-27T12:08:32.088Z | 2024-08-03T12:21:38.748Z |
4692963 | 4692963 | 20240726103256_aTADx | NZ003M | 2024-07-27T12:08:19.170Z | 2024-08-03T12:21:37.466Z |
4692941 | 4692941 | 20240726103010_B3D3V | NZ003M | 2024-07-27T12:08:17.727Z | 2024-08-03T12:21:37.295Z |
4659583 | 4659583 | 20240718145550_sjZei | NZ003M | 2024-07-19T12:00:27.516Z | 2024-07-27T12:16:47.365Z |
4636918 | 4636918 | 20240714140753_D1fDQ | NZ003M | 2024-07-16T12:02:04.415Z | 2024-07-23T12:08:35.571Z |
4632069 | 4632069 | 20240712142918_os9lC | NZ003M | 2024-07-15T12:05:09.922Z | 2024-07-21T12:13:25.557Z |
4631902 | 4631902 | 20240712140719_m6Q3n | NZ003M | 2024-07-15T12:04:59.007Z | 2024-07-21T12:13:25.484Z |
4624831 | 4624831 | 20240711134052_ZcpCP | NZ003M | 2024-07-14T12:06:00.731Z | 2024-07-20T12:13:09.718Z |
4601574 | 4601574 | 20240708174159_1wRhc | NZ003M | 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);