participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,359 rows where station_code = "NZ0004" 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 |
---|---|---|---|---|---|
5603403 | 5603403 | 20241125152114_r2ARU | NZ0004 | 2024-11-26T14:11:04.002Z | 2024-11-26T14:11:04.002Z |
5603348 | 5603348 | 20241125150908_dxG43 | NZ0004 | 2024-11-26T14:10:58.732Z | 2024-11-26T14:10:58.732Z |
5603280 | 5603280 | 20241125145040_HVfjV | NZ0004 | 2024-11-26T14:10:49.837Z | 2024-11-26T14:10:49.837Z |
5603237 | 5603237 | 20241125144347_TPQad | NZ0004 | 2024-11-26T14:10:36.647Z | 2024-11-26T14:10:36.647Z |
5603227 | 5603227 | 20241125144102_aFbvI | NZ0004 | 2024-11-26T14:10:33.805Z | 2024-11-26T14:10:33.805Z |
5603158 | 5603158 | 20241125142718_ZlGBU | NZ0004 | 2024-11-26T14:10:25.212Z | 2024-11-26T14:10:25.212Z |
5603149 | 5603149 | 20241125142517_SzIOi | NZ0004 | 2024-11-26T14:10:23.017Z | 2024-11-26T14:10:23.017Z |
5602999 | 5602999 | 20241125134744_RJbwx | NZ0004 | 2024-11-26T14:10:06.532Z | 2024-11-26T14:10:06.532Z |
5602982 | 5602982 | 20241125134328_tBsus | NZ0004 | 2024-11-26T14:10:04.421Z | 2024-11-26T14:10:04.421Z |
5602945 | 5602945 | 20241125133511_7cCmd | NZ0004 | 2024-11-26T14:09:55.698Z | 2024-11-26T14:09:55.698Z |
5602767 | 5602767 | 20241125125531_R2PPp | NZ0004 | 2024-11-26T14:09:31.547Z | 2024-11-26T14:09:31.547Z |
5602761 | 5602761 | 20241125125511_wyHrL | NZ0004 | 2024-11-26T14:09:30.879Z | 2024-11-26T14:09:30.879Z |
5602620 | 5602620 | 20241125122704_S729z | NZ0004 | 2024-11-26T14:09:03.069Z | 2024-11-26T14:09:03.069Z |
5602523 | 5602523 | 20241125120846_nYQpF | NZ0004 | 2024-11-26T14:08:44.091Z | 2024-11-26T14:08:44.091Z |
5602472 | 5602472 | 20241125120107_FWzI5 | NZ0004 | 2024-11-26T14:08:39.617Z | 2024-11-26T14:08:39.617Z |
5602355 | 5602355 | 20241125114233_Itdhg | NZ0004 | 2024-11-26T14:08:27.071Z | 2024-11-26T14:08:27.071Z |
5602278 | 5602278 | 20241125112439_uHtb2 | NZ0004 | 2024-11-26T14:08:04.654Z | 2024-11-26T14:08:04.654Z |
5602129 | 5602129 | 20241125110300_1z7Co | NZ0004 | 2024-11-26T14:07:42.364Z | 2024-11-26T14:07:42.364Z |
5602018 | 5602018 | 20241125104452_r7Sdb | NZ0004 | 2024-11-26T14:07:30.013Z | 2024-11-26T14:07:30.013Z |
5601862 | 5601862 | 20241125101924_FG5A0 | NZ0004 | 2024-11-26T14:07:00.311Z | 2024-11-26T14:07:00.311Z |
5601751 | 5601751 | 20241125100300_m5KW3 | NZ0004 | 2024-11-26T14:06:36.135Z | 2024-11-26T14:06:36.135Z |
5601742 | 5601742 | 20241125100127_C7Ip2 | NZ0004 | 2024-11-26T14:06:33.897Z | 2024-11-26T14:06:33.897Z |
5601728 | 5601728 | 20241125095705_g8p4W | NZ0004 | 2024-11-26T14:06:32.255Z | 2024-11-26T14:06:32.255Z |
5601699 | 5601699 | 20241125095202_bUJLD | NZ0004 | 2024-11-26T14:06:27.509Z | 2024-11-26T14:06:27.509Z |
5601678 | 5601678 | 20241125094700_jyLnQ | NZ0004 | 2024-11-26T14:06:24.888Z | 2024-11-26T14:06:24.888Z |
5601654 | 5601654 | 20241125094232_666cB | NZ0004 | 2024-11-26T14:06:20.929Z | 2024-11-26T14:06:20.929Z |
5597439 | 5597439 | 20241124152419_rg2lL | NZ0004 | 2024-11-25T14:11:29.237Z | 2024-11-26T14:18:44.598Z |
5597385 | 5597385 | 20241124152042_owJBH | NZ0004 | 2024-11-25T14:11:26.218Z | 2024-11-26T14:18:44.588Z |
5597342 | 5597342 | 20241124151856_chnw8 | NZ0004 | 2024-11-25T14:11:24.123Z | 2024-11-26T14:18:44.582Z |
5597263 | 5597263 | 20241124151438_mWh1a | NZ0004 | 2024-11-25T14:11:19.258Z | 2024-11-26T14:18:44.569Z |
5597176 | 5597176 | 20241124150846_Pk6Y7 | NZ0004 | 2024-11-25T14:11:14.456Z | 2024-11-26T14:18:44.557Z |
5597027 | 5597027 | 20241124145656_zjV1W | NZ0004 | 2024-11-25T14:10:59.489Z | 2024-11-26T14:18:44.537Z |
5596911 | 5596911 | 20241124144519_WkA07 | NZ0004 | 2024-11-25T14:10:47.256Z | 2024-11-26T14:18:44.508Z |
5596742 | 5596742 | 20241124142109_byVMS | NZ0004 | 2024-11-25T14:10:31.449Z | 2024-11-26T14:18:44.473Z |
5596716 | 5596716 | 20241124141741_tc3pW | NZ0004 | 2024-11-25T14:10:29.695Z | 2024-11-26T14:18:44.469Z |
5596541 | 5596541 | 20241124140218_XE6Y5 | NZ0004 | 2024-11-25T14:10:17.618Z | 2024-11-26T14:18:44.443Z |
5596500 | 5596500 | 20241124135729_n3znf | NZ0004 | 2024-11-25T14:10:11.953Z | 2024-11-26T14:18:44.436Z |
5596364 | 5596364 | 20241124134227_zjO91 | NZ0004 | 2024-11-25T14:09:52.950Z | 2024-11-26T14:18:44.416Z |
5596349 | 5596349 | 20241124134102_5c3BJ | NZ0004 | 2024-11-25T14:09:51.332Z | 2024-11-26T14:18:44.414Z |
5596338 | 5596338 | 20241124134016_tcFNC | NZ0004 | 2024-11-25T14:09:50.825Z | 2024-11-26T14:18:44.413Z |
5596080 | 5596080 | 20241124131438_fDTAO | NZ0004 | 2024-11-25T14:09:29.193Z | 2024-11-26T14:18:44.374Z |
5596040 | 5596040 | 20241124130926_MhleP | NZ0004 | 2024-11-25T14:09:24.352Z | 2024-11-26T14:18:44.365Z |
5595959 | 5595959 | 20241124130305_BRD3n | NZ0004 | 2024-11-25T14:09:13.164Z | 2024-11-26T14:18:44.352Z |
5595690 | 5595690 | 20241124124204_hfOKj | NZ0004 | 2024-11-25T14:08:44.294Z | 2024-11-26T14:18:44.309Z |
5595563 | 5595563 | 20241124123229_dTQnZ | NZ0004 | 2024-11-25T14:08:33.282Z | 2024-11-26T14:18:44.289Z |
5595504 | 5595504 | 20241124122639_z9YEd | NZ0004 | 2024-11-25T14:08:23.902Z | 2024-11-26T14:18:44.279Z |
5595469 | 5595469 | 20241124122128_G59JF | NZ0004 | 2024-11-25T14:08:18.040Z | 2024-11-26T14:18:44.273Z |
5595384 | 5595384 | 20241124121304_jIWFO | NZ0004 | 2024-11-25T14:08:06.330Z | 2024-11-26T14:18:44.261Z |
5595291 | 5595291 | 20241124120314_Uykib | NZ0004 | 2024-11-25T14:07:54.943Z | 2024-11-26T14:18:44.244Z |
5595156 | 5595156 | 20241124114903_Q32pU | NZ0004 | 2024-11-25T14:07:40.763Z | 2024-11-26T14:18:44.217Z |
5594977 | 5594977 | 20241124112733_LFpbC | NZ0004 | 2024-11-25T14:07:03.933Z | 2024-11-26T14:18:44.184Z |
5576833 | 5576833 | 20241122135121_oDfmD | NZ0004 | 2024-11-23T14:10:36.559Z | 2024-11-26T14:22:53.103Z |
5576812 | 5576812 | 20241122134206_GJqVl | NZ0004 | 2024-11-23T14:10:33.292Z | 2024-11-26T14:22:52.797Z |
5576797 | 5576797 | 20241122132836_80ll7 | NZ0004 | 2024-11-23T14:10:28.258Z | 2024-11-26T14:22:52.552Z |
5576789 | 5576789 | 20241122132621_MKg2I | NZ0004 | 2024-11-23T14:10:26.470Z | 2024-11-26T14:22:52.474Z |
5576742 | 5576742 | 20241122130450_jlMiB | NZ0004 | 2024-11-23T14:10:17.782Z | 2024-11-26T14:22:52.040Z |
5576738 | 5576738 | 20241122130421_ytYfn | NZ0004 | 2024-11-23T14:10:17.391Z | 2024-11-26T14:22:52.020Z |
5576728 | 5576728 | 20241122130330_lIoFC | NZ0004 | 2024-11-23T14:10:16.620Z | 2024-11-26T14:22:51.955Z |
5576616 | 5576616 | 20241122124006_bXe2n | NZ0004 | 2024-11-23T14:09:55.087Z | 2024-11-23T14:09:55.087Z |
5576532 | 5576532 | 20241122122643_kVdJL | NZ0004 | 2024-11-23T14:09:46.208Z | 2024-11-26T14:22:50.159Z |
5576423 | 5576423 | 20241122120659_v52Da | NZ0004 | 2024-11-23T14:09:25.828Z | 2024-11-26T14:22:49.064Z |
5576394 | 5576394 | 20241122115820_dmyXv | NZ0004 | 2024-11-23T14:09:21.874Z | 2024-11-26T14:22:48.792Z |
5576347 | 5576347 | 20241122115030_7QcNA | NZ0004 | 2024-11-23T14:09:16.660Z | 2024-11-26T14:22:48.428Z |
5576051 | 5576051 | 20241122111026_7YWFw | NZ0004 | 2024-11-23T14:08:29.072Z | 2024-11-26T14:22:46.070Z |
5576048 | 5576048 | 20241122110938_PUQZD | NZ0004 | 2024-11-23T14:08:28.714Z | 2024-11-26T14:22:46.064Z |
5575651 | 5575651 | 20241122095458_5klHV | NZ0004 | 2024-11-23T14:07:07.320Z | 2024-11-26T14:22:42.575Z |
5575589 | 5575589 | 20241122094607_tnZnz | NZ0004 | 2024-11-23T14:06:53.508Z | 2024-11-26T14:22:42.123Z |
5575304 | 5575304 | 20241122090207_Jgsfm | NZ0004 | 2024-11-23T14:06:06.188Z | 2024-11-26T14:22:37.017Z |
5569074 | 5569074 | 20241121142724_sgQH2 | NZ0004 | 2024-11-22T14:10:17.306Z | 2024-11-26T14:24:32.075Z |
5569027 | 5569027 | 20241121142006_SRVjE | NZ0004 | 2024-11-22T14:10:12.141Z | 2024-11-26T14:24:31.974Z |
5568987 | 5568987 | 20241121141407_30bnl | NZ0004 | 2024-11-22T14:10:09.510Z | 2024-11-26T14:24:31.910Z |
5568958 | 5568958 | 20241121141102_PpPV5 | NZ0004 | 2024-11-22T14:10:07.131Z | 2024-11-26T14:24:31.835Z |
5568910 | 5568910 | 20241121140250_cet6x | NZ0004 | 2024-11-22T14:10:03.549Z | 2024-11-26T14:24:31.445Z |
5568877 | 5568877 | 20241121135548_HIku0 | NZ0004 | 2024-11-22T14:10:01.310Z | 2024-11-26T14:24:31.229Z |
5568849 | 5568849 | 20241121135107_sgiSt | NZ0004 | 2024-11-22T14:09:59.620Z | 2024-11-26T14:24:31.117Z |
5568205 | 5568205 | 20241121120457_FzNET | NZ0004 | 2024-11-22T14:08:26.345Z | 2024-11-26T14:24:25.533Z |
5560880 | 5560880 | 20241120150918_xvBFn | NZ0004 | 2024-11-21T14:09:55.245Z | 2024-11-26T14:26:08.400Z |
5560854 | 5560854 | 20241120145357_kk5lE | NZ0004 | 2024-11-21T14:09:52.780Z | 2024-11-26T14:26:08.196Z |
5560757 | 5560757 | 20241120141600_FL4V6 | NZ0004 | 2024-11-21T14:09:42.542Z | 2024-11-26T14:26:07.700Z |
5560111 | 5560111 | 20241120120211_Gcyxa | NZ0004 | 2024-11-21T14:08:04.114Z | 2024-11-26T14:26:03.318Z |
5560072 | 5560072 | 20241120115410_PEGxc | NZ0004 | 2024-11-21T14:07:59.455Z | 2024-11-26T14:26:02.993Z |
5554787 | 5554787 | 20241119103941_2bpPS | NZ0004 | 2024-11-20T14:03:17.794Z | 2024-11-26T14:27:15.364Z |
5554775 | 5554775 | 20241119103524_uON0m | NZ0004 | 2024-11-20T14:03:15.535Z | 2024-11-26T14:27:15.207Z |
5551811 | 5551811 | 20241118151946_cEkK6 | NZ0004 | 2024-11-19T14:05:36.215Z | 2024-11-26T14:28:08.568Z |
5551556 | 5551556 | 20241118141300_szHDa | NZ0004 | 2024-11-19T14:04:59.514Z | 2024-11-26T14:28:08.257Z |
5551491 | 5551491 | 20241118135748_qfztP | NZ0004 | 2024-11-19T14:04:53.439Z | 2024-11-26T14:28:08.148Z |
5551397 | 5551397 | 20241118132642_HfD83 | NZ0004 | 2024-11-19T14:04:44.249Z | 2024-11-26T14:28:07.899Z |
5550715 | 5550715 | 20241118111437_xi2Ef | NZ0004 | 2024-11-19T14:02:58.158Z | 2024-11-26T14:28:03.597Z |
5550661 | 5550661 | 20241118110455_8wdg2 | NZ0004 | 2024-11-19T14:02:53.644Z | 2024-11-26T14:28:03.446Z |
5550226 | 5550226 | 20241118094956_i19TH | NZ0004 | 2024-11-19T14:01:51.028Z | 2024-11-26T14:28:01.137Z |
5550092 | 5550092 | 20241118092953_jyICJ | NZ0004 | 2024-11-19T14:01:34.256Z | 2024-11-26T14:28:00.837Z |
5549954 | 5549954 | 20241118085616_iMV6a | NZ0004 | 2024-11-19T14:01:21.227Z | 2024-11-26T14:27:59.461Z |
5549947 | 5549947 | 20241118085535_WdKvc | NZ0004 | 2024-11-19T14:01:20.920Z | 2024-11-26T14:27:59.436Z |
5549881 | 5549881 | 20241118082913_9wkkc | NZ0004 | 2024-11-19T14:01:05.712Z | 2024-11-26T14:27:59.077Z |
5546314 | 5546314 | 20241117102331_kmYqw | NZ0004 | 2024-11-18T14:02:50.257Z | 2024-11-26T14:28:26.909Z |
5546276 | 5546276 | 20241117101000_vvjfa | NZ0004 | 2024-11-18T14:02:40.332Z | 2024-11-26T14:28:26.652Z |
5546126 | 5546126 | 20241117092025_DlfWT | NZ0004 | 2024-11-18T14:02:10.586Z | 2024-11-26T14:28:25.588Z |
5545998 | 5545998 | 20241117083925_sMQ0X | NZ0004 | 2024-11-18T14:01:41.536Z | 2024-11-26T14:28:24.640Z |
5545993 | 5545993 | 20241117083837_oOyL3 | NZ0004 | 2024-11-18T14:01:41.101Z | 2024-11-26T14:28:24.637Z |
5544676 | 5544676 | 20241116141810_Rl6DD | NZ0004 | 2024-11-17T14:01:50.161Z | 2024-11-25T14:22:40.168Z |
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);