names

72 rows where place_id = 591278

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603924 1868898 1868898 defendant Elryk Thomas yeoman 591278 591278 Elryk, Thomas, of Kyrketon, yeoman 0
3603925 1868898 1868898 defendant Poles John gent 591278 591278 Poles, John, of Kyrketon, gent 1
3606215 1869613 1869613 defendant Echard Roland   591278 591278 Echard, Roland, of Kyrketon 0
3606216 1869613 1869613 defendant Fokys John husbandman 591278 591278 Fokys, John, of Kyrketon, husbandman 1
4029271 2035114 2035114 defendant Vyllars John clerk 591278 591278 Vyllars, John, of Kyrketon, clerk 2
4415287 2169676 2169676 defendant Gery William   591278 591278 Gery, William, of Kyrketon 0
4482337 2195180 2195180 plaintiff Coveyn or Coneyn Alan   591278 591278 (Coveyn or Coneyn, Alan, of Kyrketon 1
4482340 2195180 2195180 defendant Algerkyrk Robert de   591278 591278 Algerkyrk, Robert de, of Kyrketon 0
4493078 2198534 2198534 defendant Tebson William   591278 591278 Tebson, William, of Kyrketon 1
4499050 2200348 2200348 plaintiff Welby Thomas de   591278 591278 Welby, Thomas de, of Kyrketon 1
4514255 2204875 2204875 defendant Holte Thomas   591278 591278 Holte, Thomas, of Kyrketon 0
4590752 2228459 2228459 defendant Conen John   591278 591278 Conen, John, of Kyrketon 0
4621306 2237653 2237653 defendant Hervy Peter   591278 591278 Hervy, Peter, of Kyrketon 0
4632886 2241158 2241158 defendant Welleford John   591278 591278 Welleford, John, of Kyrketon 0
4658143 2248425 2248425 plaintiff Copuldyk William   591278 591278 Copuldyk, William, of Kyrketon 0
4703460 2266464 2266464 plaintiff Hervy John   591278 591278 Hervy, John, of Kyrketon 0
4735846 2276361 2276361 plaintiff Stratton Augustine   591278 591278 Stratton, Augustine, of Kyrketon 0
4782964 2290692 2290692 defendant Bateson Edmund husbandman 591278 591278 Bateson, Edmund, of Kyrketon, husbandman 1
4805931 2298064 2298064 defendant Fokys John clerk 591278 591278 Fokys, John, of Kyrketon, clerk 0
4822511 2303114 2303114 defendant Yong William husbandman 591278 591278 Yong, William, of Kyrketon, husbandman 3
4840039 2308433 2308433 defendant Mey John husbandman 591278 591278 Mey, John, of Kyrketon, husbandman 1
4866635 2316525 2316525 defendant Gerner William husbandman 591278 591278 Gerner, William, of Kyrketon, husbandman 1
4929052 2335508 2335508 defendant Hervy Roger husbandman 591278 591278 Hervy, Roger, of Kyrketon, husbandman 1
4929055 2335509 2335509 defendant Hervy Roger husbandman 591278 591278 Hervy, Roger, of Kyrketon, husbandman 1
4935514 2337505 2337505 defendant Gowesell Robert husbandman 591278 591278 Gowesell, Robert, of Kyrketon, husbandman 1
4937415 2338075 2338075 defendant Holand Charles yeoman 591278 591278 Holand, Charles, of Kyrketon, yeoman 0
4968286 2347475 2347475 defendant Norton Robert yeoman 591278 591278 Norton, Robert, of Kyrketon, yeoman 0
4974222 2349249 2349249 defendant Norton Robert yeoman 591278 591278 Norton, Robert, of Kyrketon, yeoman 0
4974224 2349250 2349250 defendant Norton Robert yeoman 591278 591278 Norton, Robert, of Kyrketon, yeoman 0
4997707 2356170 2356170 plaintiff Holton John   591278 591278 Holton, John, of Kyrketon 0
5043289 2369617 2369617 plaintiff Flete Thomas   591278 591278 Flete, Thomas, of Kyrketon 0
5135372 2396852 2396852 defendant Stalworthy William husbandman 591278 591278 Stalworthy, William, of Kyrketon, husbandman 0
5135472 2396887 2396887 defendant Lock Henry   591278 591278 Lock, Henry, of Kyrketon, mason 0
5136927 2397317 2397317 defendant Pery John husbandman 591278 591278 Pery, John, of Kyrketon, husbandman 3
5136928 2397317 2397317 defendant Tomson Alan husbandman 591278 591278 Tomson, Alan, of Kyrketon, husbandman 4
5214950 2420094 2420094 defendant Holton John husbandman 591278 591278 Holton, John, of Kyrketon, husbandman 1
5222085 2422162 2422162 defendant Aylward Maud (legal representative) 591278 591278 Aylward, Maud, of Kyrketon, executors of 1
5222086 2422162 2422162 defendant Cony Roger husbandman 591278 591278 (Cony, Roger, of Kyrketon, husbandman 2
5222087 2422162 2422162 defendant Tomson Alan husbandman 591278 591278 Tomson, Alan, of Kyrketon, husbandman 3
5222088 2422162 2422162 defendant Fokys Joce husbandman 591278 591278 Fokys, Joce, of Kyrketon, husbandman 4
5229689 2424304 2424304 defendant Beese Thomas thatcher 591278 591278 Beese, Thomas, of Kyrketon, thatcher 0
5297204 2444178 2444178 defendant Gosse Thomas husbandman 591278 591278 Gosse, Thomas, of Kyrketon, husbandman 3
5320322 2451165 2451165 defendant Foule Richard (legal representative) 591278 591278 Foule, Richard, of Kyrketon, husbandman, executors of 3
5320323 2451165 2451165 defendant Foule John husbandman 591278 591278 (Foule, John, of Kyrketon, husbandman 4
5320324 2451165 2451165 defendant Foule Elizabeth widow 591278 591278 Foule, Elizabeth, of Kyrketon, widow 5
5331074 2454363 2454363 defendant Flynt William husbandman 591278 591278 Flynt, William, of Kyrketon, husbandman 0
5331075 2454363 2454363 defendant Flynt Thomas husbandman 591278 591278 Flynt, Thomas, of Kyrketon, husbandman 1
5331076 2454363 2454363 defendant Flynt John, junior husbandman 591278 591278 Flynt, John, junior, of Kyrketon, husbandman 2
5331077 2454363 2454363 defendant Broune Walter husbandman 591278 591278 Broune, Walter, of Kyrketon, husbandman 3
5332750 2454865 2454865 plaintiff Conyng or Cony John   591278 591278 Conyng or Cony, John, of Kyrketon 0
5351098 2460450 2460450 plaintiff Cursum Thomas esq 591278 591278 Cursum, Thomas, of Kyrketon, esq 0
5390159 2472247 2472247 defendant Cheter Thomas husbandman 591278 591278 Cheter, Thomas, of Kyrketon, husbandman 0
5402946 2475922 2475922 defendant Looman Alan husbandman 591278 591278 Looman, Alan, of Kyrketon, husbandman 3
5415917 2479694 2479694 defendant Cheter Thomas husbandman 591278 591278 Cheter, Thomas, of Kyrketon, husbandman 0
5415918 2479694 2479694 defendant Looman Alan husbandman 591278 591278 Looman, Alan, of Kyrketon, husbandman 1
5431502 2484378 2484378 defendant Spenlove Thomas husbandman 591278 591278 Spenlove, Thomas, of Kyrketon, husbandman 1
5432485 2484688 2484688 defendant Cheter Thomas husbandman 591278 591278 Cheter, Thomas, of Kyrketon, husbandman 0
5432486 2484688 2484688 defendant Looman Alan husbandman 591278 591278 Looman, Alan, of Kyrketon, husbandman 1
5485297 2500519 2500519 defendant Rawelet Robert butcher 591278 591278 Rawelet, Robert, of Kyrketon, butcher 0
5505480 2506630 2506630 defendant Marton William clerk 591278 591278 Marton, William, of Kyrketon, clerk 0
5513392 2509040 2509040 defendant Grene John (legal representative) 591278 591278 Grene, John, of Kyrketon, son of Grene, William, of Kyrton, executors of 0
5513393 2509040 2509040 defendant Grene John husbandman 591278 591278 (Grene, John, of Kyrketon, husbandman 1
5513395 2509040 2509040 defendant Stevenson Richard (legal representative) 591278 591278 Stevenson, Richard, of Kyrketon, husbandman, executors of 3
5513400 2509041 2509041 defendant Grene John husbandman 591278 591278 (Grene, John, of Kyrketon, husbandman 1
5513402 2509041 2509041 defendant Stevenson Richard (legal representative) 591278 591278 Stevenson, Richard, of Kyrketon, husbandman, executors of 3
5520272 2511158 2511158 defendant Marabyll Margaret widow 591278 591278 Marabyll, Margaret, of Kyrketon, widow 3
5520273 2511158 2511158 defendant Marabyll Margaret spinster 591278 591278 Marabyll, Margaret, of Kyrketon, spinster 4
5520300 2511168 2511168 defendant Parleben John yeoman 591278 591278 Parleben, John, of Kyrketon, yeoman 0
5520302 2511169 2511169 defendant Parleben John yeoman 591278 591278 Parleben, John, of Kyrketon, yeoman 0
5526021 2512729 2512729 defendant Burgh Thomas gent 591278 591278 Burgh, Thomas, of Kyrketon, gent 0
5625839 2552028 2552028 defendant Arnold Robert husbandman 591278 591278 Arnold, Robert, of Kyrketon, husbandman 0
5636994 2555516 2555516 defendant Yong William husbandman 591278 591278 Yong, William, of Kyrketon, husbandman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);