names

56 rows where place_id = 636709

✎ 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
3832230 1967993 1967993 defendant Walford John butcher 636709 636709 Walford, John, of Spaxton, butcher 0
3862250 1977559 1977559 defendant Walvord John husbandman 636709 636709 Walvord, John, of Spaxton, husbandman 0
3869259 1979961 1979961 defendant Byne John husbandman 636709 636709 Byne, John, of Spaxton, husbandman 2
3898635 1989751 1989751 defendant Walforde John husbandman 636709 636709 Walforde, John, of Spaxton, husbandman 0
3912893 1994643 1994643 defendant Colvord Richard husbandman 636709 636709 Colvord, Richard, of Spaxton, husbandman 0
4014210 2029808 2029808 defendant Kene John yeoman 636709 636709 Kene, John, of Spaxton, yeoman 2
4044288 2040409 2040409 plaintiff Rawlins John gent 636709 636709 Rawlins, John, of Spaxton, gent 0
4044289 2040409 2040409 defendant Amestrong John husbandman 636709 636709 Amestrong, John, of Spaxton, husbandman 0
4044304 2040416 2040416 defendant Leave Barnaby fuller 636709 636709 Leave, Barnaby, of Spaxton, fuller 0
4044306 2040417 2040417 defendant Loave Barnabe fuller 636709 636709 Loave, Barnabe, of Spaxton, fuller 0
4072104 2050322 2050322 defendant Walsheman John husbandman 636709 636709 Walsheman, John, of Spaxton, husbandman 0
4207417 2098147 2098147 plaintiff Rawlyns John (legal representative) 636709 636709 Rawlyns, John, of Spaxton, gent, executors of 0
4274784 2121125 2121125 defendant Oliver John yeoman 636709 636709 Oliver, John, of Spaxton, yeoman 0
4284447 2124486 2124486 defendant Oliver John yeoman 636709 636709 Oliver, John, of Spaxton, yeoman 0
4288988 2126118 2126118 defendant Leve Humphrey husbandman 636709 636709 Leve, Humphrey, of Spaxton, husbandman 0
4297916 2129355 2129355 defendant Govet Robert fuller 636709 636709 Govet, Robert, of Spaxton, fuller 0
4297918 2129356 2129356 defendant Govett Robert husbandman 636709 636709 Govett, Robert, of Spaxton, husbandman 0
4308380 2133084 2133084 defendant Oliver John yeoman 636709 636709 Oliver, John, of Spaxton, yeoman 0
4321728 2137688 2137688 defendant Reade John husbandman 636709 636709 Reade, John, of Spaxton, husbandman 2
4377535 2157042 2157042 defendant Oliver Richard yeoman 636709 636709 Oliver, Richard, of Spaxton, yeoman 0
4562438 2219814 2219814 plaintiff Portneye Henry   636709 636709 Portneye, Henry, of Spaxton, parson 0
4665995 2250839 2250839 plaintiff Hull Robert   636709 636709 Hull, Robert, of Spaxton 0
4666017 2250845 2250845 plaintiff Hulle Robert   636709 636709 Hulle, Robert, of Spaxton 0
4724436 2272938 2272938 plaintiff Everard John   636709 636709 Everard, John, of Spaxton 0
4746930 2279604 2279604 plaintiff Hulle Robert   636709 636709 Hulle, Robert, of Spaxton, on his own account 0
4754648 2281836 2281836 plaintiff Hille Robert   636709 636709 Hille, Robert, of Spaxton 5
4764725 2284956 2284956 plaintiff Hill Robert (legal representative) 636709 636709 Hill, Robert, of Spaxton, executors of 0
4764733 2284957 2284957 plaintiff Hill Robert (legal representative) 636709 636709 Hill, Robert, of Spaxton, executors of 0
4764751 2284961 2284961 plaintiff Hille Robert (legal representative) 636709 636709 Hille, Robert, of Spaxton, executors of 0
4788834 2292565 2292565 plaintiff Hill Robert (legal representative) 636709 636709 Hill, Robert, of Spaxton, executors of 0
4788861 2292572 2292572 plaintiff Hille Robert (legal representative) 636709 636709 Hille, Robert, of Spaxton, executors of 0
4788869 2292573 2292573 plaintiff Hille Robert (legal representative) 636709 636709 Hille, Robert, of Spaxton, executors of 0
4813478 2300327 2300327 plaintiff Hille John   636709 636709 Hille, John, of Spaxton 0
4840153 2308472 2308472 plaintiff Hill John   636709 636709 Hill, John, of Spaxton 0
4840156 2308473 2308473 plaintiff Hill John esq 636709 636709 Hill, John, of Spaxton, esq 0
4840178 2308478 2308478 plaintiff Hille John   636709 636709 Hille, John, of Spaxton 0
4867406 2316773 2316773 plaintiff Hill John   636709 636709 Hill, John, of Spaxton 0
4888000 2323053 2323053 defendant Gybbes Walter yeoman 636709 636709 Gybbes, Walter, of Spaxton, yeoman 0
4995956 2355639 2355639 defendant Phylyp Thomas clerk 636709 636709 Phylyp, Thomas, of Spaxton, clerk 0
5001068 2357191 2357191 defendant Fylyp Thomas   636709 636709 Fylyp, Thomas, of Spaxton 0
5001070 2357191 2357191 defendant Helyer William husbandman 636709 636709 Helyer, William, of Spaxton, husbandman 2
5001071 2357191 2357191 defendant Helyer William laborer 636709 636709 Helyer, William, of Spaxton, laborer 3
5001073 2357191 2357191 defendant Barstapill John laborer 636709 636709 Barstapill, John, of Spaxton, laborer 5
5022640 2363529 2363529 defendant Phylyp Thomas clerk 636709 636709 Phylyp, Thomas, of Spaxton, clerk 0
5082246 2381181 2381181 defendant Neper John smith 636709 636709 Neper, John, of Spaxton, smith 1
5180217 2409953 2409953 defendant Chepman John husbandman 636709 636709 Chepman, John, of Spaxton, husbandman 0
5180218 2409953 2409953 defendant Suthwode Thomas husbandman 636709 636709 Suthwode, Thomas, of Spaxton, husbandman 1
5190762 2413051 2413051 defendant Chapman John husbandman 636709 636709 Chapman, John, of Spaxton, husbandman 1
5202307 2416437 2416437 defendant Chepman John husbandman 636709 636709 Chepman, John, of Spaxton, husbandman 0
5202308 2416437 2416437 defendant Suthwode Thomas husbandman 636709 636709 Suthwode, Thomas, of Spaxton, husbandman 1
5202310 2416438 2416438 defendant Shepman John husbandman 636709 636709 Shepman, John, of Spaxton, husbandman 0
5272019 2436897 2436897 defendant Toly John clerk 636709 636709 Toly, John, of Spaxton, clerk 3
5513597 2509102 2509102 defendant Coke Richard husbandman 636709 636709 Coke, Richard, of Spaxton, husbandman 5
5543665 2518126 2518126 defendant Atwell John husbandman 636709 636709 Atwell, John, of Spaxton, husbandman 0
5584989 2530380 2530380 defendant Tuxwill John husbandman 636709 636709 Tuxwill, John, of Spaxton, husbandman 6
5626580 2552286 2552286 defendant Pilton John yeoman 636709 636709 Pilton, John, of Spaxton, yeoman 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);