names

35 rows where place_id = 594310

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615523 1872496 1872496 defendant Martyn William husbandman 594310 594310 Martyn, William, of Wygenhale St Mary Magdalene, husbandman 1
3616355 1872754 1872754 defendant Palmer John clerk 594310 594310 Palmer, John, of Wygenhale St Mary Magdalene, clerk 0
3616356 1872754 1872754 defendant Prentys William   594310 594310 Prentys, William, of Wygenhale St Mary Magdalene 1
3616362 1872756 1872756 defendant Palmer John clerk 594310 594310 Palmer, John, of Wygenhale St Mary Magdalene, clerk 0
3616363 1872756 1872756 defendant Prentys William husbandman 594310 594310 Prentys, William, of Wygenhale St Mary Magdalene, husbandman 1
3620662 1874041 1874041 defendant Toppe John (legal representative) 594310 594310 Toppe, John, of Wygenhale St Mary Magdalene, husbandman, executors of 0
3620663 1874041 1874041 defendant Prentys William husbandman 594310 594310 (Prentys, William, of Wygenhale St Mary Magdalene, husbandman 1
3620664 1874041 1874041 defendant Kervyle Humphrey gent 594310 594310 Kervyle, Humphrey, of Wygenhale St Mary Magdalene, gent 2
3647770 1909695 1909695 defendant Buk William husbandman 594310 594310 Buk, William, of Wygenhale St Mary Magdalene, husbandman 0
3992248 2021992 2021992 defendant Sargaunt alias Corser Thomas husbandman 594310 594310 Sargaunt alias Corser, Thomas, of Wygenhale St Mary Magdalene, husbandman 1
4066234 2048212 2048212 defendant Hungate John husbandman 594310 594310 Hungate, John, of Wygenhale St Mary Magdalene, husbandman 0
4066235 2048212 2048212 defendant Wilson Robert husbandman 594310 594310 Wilson, Robert, of Wygenhale St Mary Magdalene, husbandman 1
4066237 2048212 2048212 defendant Rycheman John husbandman 594310 594310 Rycheman, John, of Wygenhale St Mary Magdalene, husbandman 3
4097789 2059541 2059541 defendant Purle John yeoman 594310 594310 Purle, John, of Wygenhale St Mary Magdalene, yeoman 2
4097790 2059541 2059541 defendant Funnell William clerk 594310 594310 Funnell, William, of Wygenhale St Mary Magdalene, clerk 3
4102616 2061235 2061235 defendant Walters Thomas   594310 594310 Walters, Thomas, of Wygenhale St Mary Magdalene, brick burner 2
4102617 2061235 2061235 defendant Lambert John laborer 594310 594310 Lambert, John, of Wygenhale St Mary Magdalene, laborer 3
4990267 2353995 2353995 defendant Chapleyn William husbandman 594310 594310 Chapleyn, William, of Wygenhale St Mary Magdalene, husbandman 2
5043334 2369629 2369629 defendant Beteson Thomas yeoman 594310 594310 Beteson, Thomas, of Wygenhale St Mary Magdalene, yeoman 1
5054321 2372872 2372872 defendant Man Thomas husbandman 594310 594310 Man, Thomas, of Wygenhale St Mary Magdalene, husbandman 0
5054322 2372872 2372872 defendant Man John husbandman 594310 594310 Man, John, of Wygenhale St Mary Magdalene, husbandman 1
5354939 2461615 2461615 defendant Topp William husbandman 594310 594310 (Topp, William, of Wygenhale St Mary Magdalene, husbandman 10
5361838 2463731 2463731 defendant Whyte William gent 594310 594310 Whyte, William, of Wygenhale St Mary Magdalene, gent 0
5373213 2467216 2467216 defendant Buk Margaret widow 594310 594310 Buk, Margaret, of Wygenhale St Mary Magdalene, widow 1
5373215 2467217 2467217 defendant Rudlond Mathew husbandman 594310 594310 Rudlond, Mathew, of Wygenhale St Mary Magdalene, husbandman 0
5432779 2484772 2484772 defendant Martyn William husbandman 594310 594310 Martyn, William, of Wygenhale St Mary Magdalene, husbandman 0
5432783 2484772 2484772 defendant Buk Margaret widow 594310 594310 Buk, Margaret, of Wygenhale St Mary Magdalene, widow 4
5448773 2489528 2489528 defendant Martyn William sadler 594310 594310 Martyn, William, of Wygenhale St Mary Magdalene, husbandman Sampson, William, of Bishop's Lenn, sadler 0
5448778 2489529 2489529 defendant Martyn William husbandman 594310 594310 Martyn, William, of Wygenhale St Mary Magdalene, husbandman 0
5505140 2506516 2506516 defendant Heynes John smith 594310 594310 Heynes, John, of Wygenhale St Mary magdalene, smith 2
5532582 2514734 2514734 plaintiff Tullyet William (legal representative) 594310 594310 Tullyet, William, of Wygenhale St Mary Magdalene, executor of 0
5541422 2517431 2517431 plaintiff Kegell Edmund   594310 594310 Kegell, Edmund, of Wygenhale St Mary Magdalene 0
5541612 2517484 2517484 defendant Cobbe Thomas yeoman 594310 594310 Cobbe, Thomas, of Wygenhale St Mary Magdalene, yeoman 0
5585804 2530618 2530618 plaintiff Kegell Edmund (legal representative) 594310 594310 Kegell, Edmund, of Wygenhale St Mary Magdalene, executors of 0
5606668 2536968 2536968 plaintiff Tullyet William (legal representative) 594310 594310 Tullyet, William, of Wygenhale St Mary Magdalene, executor of Perys, Alice, of Wygenhale, maiden, executor of 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);