participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,031 rows where station_code = "NZ002Z" 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 |
---|---|---|---|---|---|
5083726 | 5083726 | 20240911141357_oQZ5s | NZ002Z | 2024-09-15T12:18:45.823Z | 2024-09-16T12:19:20.370Z |
5083624 | 5083624 | 20240911135957_fi4oa | NZ002Z | 2024-09-15T12:18:44.666Z | 2024-09-16T12:19:19.783Z |
5083617 | 5083617 | 20240911135800_LulOC | NZ002Z | 2024-09-15T12:18:44.619Z | 2024-09-16T12:19:19.762Z |
5083580 | 5083580 | 20240911135339_Vcuut | NZ002Z | 2024-09-15T12:18:44.242Z | 2024-09-16T12:19:19.677Z |
5083533 | 5083533 | 20240911134311_bhbEM | NZ002Z | 2024-09-15T12:18:43.432Z | 2024-09-16T12:19:19.396Z |
5083517 | 5083517 | 20240911134046_QlhfR | NZ002Z | 2024-09-15T12:18:43.144Z | 2024-09-16T12:19:19.056Z |
5083489 | 5083489 | 20240911133150_AB6vw | NZ002Z | 2024-09-15T12:18:42.563Z | 2024-09-16T12:19:18.711Z |
5083481 | 5083481 | 20240911132906_xjoFJ | NZ002Z | 2024-09-15T12:18:42.466Z | 2024-09-16T12:19:18.701Z |
5083473 | 5083473 | 20240911132834_MzsC2 | NZ002Z | 2024-09-15T12:18:42.462Z | 2024-09-16T12:19:18.686Z |
5083425 | 5083425 | 20240911131644_LHqmp | NZ002Z | 2024-09-15T12:18:41.904Z | 2024-09-16T12:19:18.534Z |
5083347 | 5083347 | 20240911130012_RnmXq | NZ002Z | 2024-09-15T12:18:39.965Z | 2024-09-16T12:19:18.082Z |
5083330 | 5083330 | 20240911125646_nf3u8 | NZ002Z | 2024-09-15T12:18:39.415Z | 2024-09-16T12:19:17.999Z |
5083318 | 5083318 | 20240911125427_d33Iy | NZ002Z | 2024-09-15T12:18:38.829Z | 2024-09-16T12:19:17.958Z |
5083271 | 5083271 | 20240911124315_EmU4m | NZ002Z | 2024-09-15T12:18:38.016Z | 2024-09-16T12:19:17.673Z |
5083261 | 5083261 | 20240911123858_nD0pP | NZ002Z | 2024-09-15T12:18:37.714Z | 2024-09-16T12:19:17.643Z |
5083258 | 5083258 | 20240911123835_Nvknj | NZ002Z | 2024-09-15T12:18:37.694Z | 2024-09-16T12:19:17.642Z |
5083243 | 5083243 | 20240911123731_LlP9K | NZ002Z | 2024-09-15T12:18:37.552Z | 2024-09-16T12:19:17.480Z |
5083209 | 5083209 | 20240911122909_KZgZn | NZ002Z | 2024-09-15T12:18:37.018Z | 2024-09-16T12:19:17.265Z |
5083147 | 5083147 | 20240911121503_QuIx2 | NZ002Z | 2024-09-15T12:18:36.206Z | 2024-09-16T12:19:16.923Z |
5082571 | 5082571 | 20240911102824_eOVIu | NZ002Z | 2024-09-15T12:18:20.317Z | 2024-09-16T12:19:13.405Z |
5082481 | 5082481 | 20240911101449_NQ26a | NZ002Z | 2024-09-15T12:18:16.108Z | 2024-09-16T12:19:12.272Z |
5082451 | 5082451 | 20240911101107_PyzHm | NZ002Z | 2024-09-15T12:18:15.436Z | 2024-09-16T12:19:12.058Z |
5082372 | 5082372 | 20240911100027_Rmjco | NZ002Z | 2024-09-15T12:18:12.930Z | 2024-09-16T12:19:11.474Z |
5082042 | 5082042 | 20240911091436_q7Kkp | NZ002Z | 2024-09-15T12:18:00.387Z | 2024-09-16T12:19:08.134Z |
5081961 | 5081961 | 20240911090616_fDfxN | NZ002Z | 2024-09-15T12:17:56.247Z | 2024-09-16T12:19:07.604Z |
5081790 | 5081790 | 20240911084332_laXY2 | NZ002Z | 2024-09-15T12:17:48.243Z | 2024-09-16T12:19:05.850Z |
5081778 | 5081778 | 20240911084201_lS3W8 | NZ002Z | 2024-09-15T12:17:46.791Z | 2024-09-16T12:19:05.628Z |
5071603 | 5071603 | 20240911172516_m5Eii | NZ002Z | 2024-09-15T12:03:03.298Z | 2024-09-16T12:17:28.873Z |
5071593 | 5071593 | 20240911172405_3UhcB | NZ002Z | 2024-09-15T12:03:02.541Z | 2024-09-16T12:17:28.872Z |
5071324 | 5071324 | 20240911163420_hWphc | NZ002Z | 2024-09-15T12:02:18.161Z | 2024-09-16T12:17:28.784Z |
5071247 | 5071247 | 20240911162156_DYgfl | NZ002Z | 2024-09-15T12:02:00.888Z | 2024-09-16T12:17:28.768Z |
5071173 | 5071173 | 20240911161222_NsSHD | NZ002Z | 2024-09-15T12:01:50.588Z | 2024-09-16T12:17:28.752Z |
5071131 | 5071131 | 20240911160219_pZ5b4 | NZ002Z | 2024-09-15T12:01:45.231Z | 2024-09-16T12:17:28.742Z |
5070997 | 5070997 | 20240911154039_rRDJD | NZ002Z | 2024-09-15T12:01:20.000Z | 2024-09-16T12:17:28.709Z |
5070960 | 5070960 | 20240911153513_p2nA9 | NZ002Z | 2024-09-15T12:01:14.847Z | 2024-09-16T12:17:28.701Z |
5070908 | 5070908 | 20240911152746_nohQ3 | NZ002Z | 2024-09-15T12:01:07.842Z | 2024-09-16T12:17:28.687Z |
5070870 | 5070870 | 20240911152132_3SP2E | NZ002Z | 2024-09-15T12:01:01.982Z | 2024-09-16T12:17:28.679Z |
5070825 | 5070825 | 20240911151413_8QFC6 | NZ002Z | 2024-09-15T12:00:57.699Z | 2024-09-16T12:17:28.671Z |
5070789 | 5070789 | 20240911151107_YuJST | NZ002Z | 2024-09-15T12:00:51.239Z | 2024-09-16T12:17:28.665Z |
5070767 | 5070767 | 20240911150901_LCQib | NZ002Z | 2024-09-15T12:00:47.234Z | 2024-09-16T12:17:28.662Z |
5070699 | 5070699 | 20240911145608_caDzY | NZ002Z | 2024-09-15T12:00:36.951Z | 2024-09-16T12:17:28.648Z |
5070648 | 5070648 | 20240911144601_7ro5l | NZ002Z | 2024-09-15T12:00:27.955Z | 2024-09-16T12:17:28.636Z |
5070642 | 5070642 | 20240911144545_j2d1Y | NZ002Z | 2024-09-15T12:00:27.633Z | 2024-09-16T12:17:28.635Z |
5070603 | 5070603 | 20240911143923_ZG1id | NZ002Z | 2024-09-15T12:00:23.659Z | 2024-09-16T12:17:28.627Z |
5070597 | 5070597 | 20240911143723_PBWSR | NZ002Z | 2024-09-15T12:00:22.912Z | 2024-09-16T12:17:28.626Z |
5070553 | 5070553 | 20240911143102_c3Yn2 | NZ002Z | 2024-09-15T12:00:17.834Z | 2024-09-16T12:17:28.616Z |
5070545 | 5070545 | 20240911143057_Rnhrh | NZ002Z | 2024-09-15T12:00:17.125Z | 2024-09-16T12:17:28.615Z |
5070489 | 5070489 | 20240908101221_EIcZh | NZ002Z | 2024-09-14T12:21:58.732Z | 2024-09-16T12:21:24.491Z |
5069036 | 5069036 | 20240910132852_WeGfu | NZ002Z | 2024-09-14T12:19:24.327Z | 2024-09-16T12:20:16.212Z |
5069031 | 5069031 | 20240910132559_fjBrU | NZ002Z | 2024-09-14T12:19:24.159Z | 2024-09-16T12:20:16.195Z |
5069002 | 5069002 | 20240910132038_OeCEW | NZ002Z | 2024-09-14T12:19:23.652Z | 2024-09-16T12:20:16.131Z |
5068977 | 5068977 | 20240910131719_EAw3r | NZ002Z | 2024-09-14T12:19:23.443Z | 2024-09-16T12:20:16.035Z |
5068945 | 5068945 | 20240910131020_VgqoI | NZ002Z | 2024-09-14T12:19:23.158Z | 2024-09-16T12:20:15.879Z |
5068912 | 5068912 | 20240910125824_YoSKl | NZ002Z | 2024-09-14T12:19:22.813Z | 2024-09-16T12:20:15.669Z |
5068908 | 5068908 | 20240910125759_2E384 | NZ002Z | 2024-09-14T12:19:22.800Z | 2024-09-16T12:20:15.654Z |
5068891 | 5068891 | 20240910125516_SFKTr | NZ002Z | 2024-09-14T12:19:22.599Z | 2024-09-16T12:20:15.541Z |
5068814 | 5068814 | 20240910123135_VxHJO | NZ002Z | 2024-09-14T12:19:21.714Z | 2024-09-16T12:20:15.380Z |
5068449 | 5068449 | 20240910113341_LJpYJ | NZ002Z | 2024-09-14T12:19:15.693Z | 2024-09-16T12:20:13.968Z |
5068233 | 5068233 | 20240910111329_5lwcs | NZ002Z | 2024-09-14T12:19:11.131Z | 2024-09-16T12:20:13.197Z |
5067598 | 5067598 | 20240910094943_H7Uj2 | NZ002Z | 2024-09-14T12:18:50.405Z | 2024-09-16T12:20:10.348Z |
5067557 | 5067557 | 20240910094349_D7oW8 | NZ002Z | 2024-09-14T12:18:48.673Z | 2024-09-16T12:20:09.977Z |
5067551 | 5067551 | 20240910094326_dMqSw | NZ002Z | 2024-09-14T12:18:48.340Z | 2024-09-16T12:20:09.849Z |
5067118 | 5067118 | 20240910085712_x3s7R | NZ002Z | 2024-09-14T12:18:32.691Z | 2024-09-16T12:20:07.429Z |
5066951 | 5066951 | 20240910083411_mqSNJ | NZ002Z | 2024-09-14T12:18:22.835Z | 2024-09-16T12:20:06.538Z |
5066917 | 5066917 | 20240910083112_Q0eM8 | NZ002Z | 2024-09-14T12:18:19.287Z | 2024-09-16T12:20:06.379Z |
5061351 | 5061351 | 20240909145245_NUJ2Y | NZ002Z | 2024-09-14T12:10:43.679Z | 2024-09-16T12:19:30.637Z |
5061129 | 5061129 | 20240909142034_ggfB8 | NZ002Z | 2024-09-14T12:10:19.422Z | 2024-09-16T12:19:29.337Z |
5060994 | 5060994 | 20240909134405_9zphe | NZ002Z | 2024-09-14T12:10:03.654Z | 2024-09-16T12:19:28.555Z |
5060986 | 5060986 | 20240909134150_0k2iL | NZ002Z | 2024-09-14T12:10:02.169Z | 2024-09-16T12:19:28.490Z |
5060974 | 5060974 | 20240909134035_cnsVD | NZ002Z | 2024-09-14T12:10:00.858Z | 2024-09-16T12:19:28.467Z |
5060972 | 5060972 | 20240909133901_F9HPo | NZ002Z | 2024-09-14T12:10:00.573Z | 2024-09-16T12:19:28.462Z |
5059315 | 5059315 | 20240910173004_AhAp3 | NZ002Z | 2024-09-14T12:05:42.509Z | 2024-09-16T12:18:03.810Z |
5059154 | 5059154 | 20240910171734_FlqtL | NZ002Z | 2024-09-14T12:05:20.070Z | 2024-09-16T12:18:02.267Z |
5059110 | 5059110 | 20240910171341_2DWoE | NZ002Z | 2024-09-14T12:05:15.355Z | 2024-09-16T12:18:01.804Z |
5059038 | 5059038 | 20240910170834_ZULkp | NZ002Z | 2024-09-14T12:05:08.077Z | 2024-09-16T12:18:01.222Z |
5059031 | 5059031 | 20240910170831_PdgP7 | NZ002Z | 2024-09-14T12:05:07.424Z | 2024-09-16T12:18:01.199Z |
5059005 | 5059005 | 20240910170733_rGGG4 | NZ002Z | 2024-09-14T12:05:05.744Z | 2024-09-16T12:18:00.355Z |
5058896 | 5058896 | 20240910165543_Nzi6i | NZ002Z | 2024-09-14T12:04:46.767Z | 2024-09-16T12:17:59.623Z |
5058780 | 5058780 | 20240910164612_nSsX2 | NZ002Z | 2024-09-14T12:04:31.436Z | 2024-09-16T12:17:58.072Z |
5058538 | 5058538 | 20240910162104_d34A5 | NZ002Z | 2024-09-14T12:03:53.469Z | 2024-09-16T12:17:55.845Z |
5058480 | 5058480 | 20240910161512_8VgFO | NZ002Z | 2024-09-14T12:03:46.170Z | 2024-09-16T12:17:54.935Z |
5058471 | 5058471 | 20240910161435_EZjSy | NZ002Z | 2024-09-14T12:03:45.296Z | 2024-09-16T12:17:54.884Z |
5058340 | 5058340 | 20240910160539_Dfscx | NZ002Z | 2024-09-14T12:03:33.452Z | 2024-09-16T12:17:53.085Z |
5058336 | 5058336 | 20240910160532_gNSZy | NZ002Z | 2024-09-14T12:03:33.111Z | 2024-09-16T12:17:53.007Z |
5058284 | 5058284 | 20240910160047_5X52L | NZ002Z | 2024-09-14T12:03:19.790Z | 2024-09-16T12:17:52.408Z |
5058242 | 5058242 | 20240910155725_G82Lx | NZ002Z | 2024-09-14T12:03:15.233Z | 2024-09-16T12:17:51.988Z |
5058168 | 5058168 | 20240910154906_2nfhj | NZ002Z | 2024-09-14T12:03:04.340Z | 2024-09-16T12:17:51.276Z |
5058106 | 5058106 | 20240910154511_oOKBK | NZ002Z | 2024-09-14T12:02:57.595Z | 2024-09-16T12:17:50.191Z |
5058004 | 5058004 | 20240910153511_BSIjA | NZ002Z | 2024-09-14T12:02:36.114Z | 2024-09-16T12:17:49.260Z |
5057949 | 5057949 | 20240910152903_9tFoQ | NZ002Z | 2024-09-14T12:02:27.963Z | 2024-09-16T12:17:48.739Z |
5057944 | 5057944 | 20240910152853_lo4bu | NZ002Z | 2024-09-14T12:02:27.513Z | 2024-09-16T12:17:48.728Z |
5057868 | 5057868 | 20240910152041_353ru | NZ002Z | 2024-09-14T12:02:16.963Z | 2024-09-16T12:17:48.064Z |
5057821 | 5057821 | 20240910151640_9xMEZ | NZ002Z | 2024-09-14T12:02:10.843Z | 2024-09-16T12:17:47.835Z |
5057799 | 5057799 | 20240910151523_YjHQH | NZ002Z | 2024-09-14T12:02:08.414Z | 2024-09-16T12:17:47.782Z |
5057453 | 5057453 | 20240910143121_ssdX6 | NZ002Z | 2024-09-14T12:01:06.089Z | 2024-09-16T12:17:44.133Z |
5057440 | 5057440 | 20240910142954_4t3xn | NZ002Z | 2024-09-14T12:01:04.139Z | 2024-09-16T12:17:43.986Z |
5057071 | 5057071 | 20240908120641_2pQRR | NZ002Z | 2024-09-13T12:17:44.426Z | 2024-09-16T12:21:28.733Z |
5057062 | 5057062 | 20240908120637_4Bw5n | NZ002Z | 2024-09-13T12:17:44.387Z | 2024-09-16T12:21:28.727Z |
5056894 | 5056894 | 20240908113712_bs7pg | NZ002Z | 2024-09-13T12:17:40.755Z | 2024-09-16T12:21:27.681Z |
5056876 | 5056876 | 20240908113516_4J2rF | NZ002Z | 2024-09-13T12:17:40.386Z | 2024-09-16T12:21:27.606Z |
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);