names

50 rows where place_id = 588438

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594511 1865913 1865913 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 0
3757998 1944483 1944483 defendant Hendryngham John clerk 588438 588438 Hendryngham, John, of Wykhampton, clerk 0
3773417 1949396 1949396 defendant Hyndryngham John clerk 588438 588438 Hyndryngham, John, of Wykhampton, clerk 0
4552241 2216655 2216655 defendant Cove John   588438 588438 Cove, John, of Wykhampton 0
4734027 2275827 2275827 defendant Bray John gent 588438 588438 Bray, John, of Wykhampton, gent 0
4939863 2338856 2338856 defendant Wryght Henry husbandman 588438 588438 Wryght, Henry, of Wykhampton, husbandman 3
4952792 2342792 2342792 defendant Skernyng Thomas clerk 588438 588438 Skernyng, Thomas, of Wykhampton, clerk 0
4955479 2343601 2343601 defendant Hamond Philip yeoman 588438 588438 Hamond, Philip, of Wykhampton, yeoman 2
4986240 2352813 2352813 defendant Hardy John yeoman 588438 588438 Hardy, John, of Wykhampton, yeoman 1
5003886 2358026 2358026 defendant Hardy John yeoman 588438 588438 Hardy, John, of Wykhampton, yeoman 3
5005913 2358630 2358630 defendant Wright Henry yeoman 588438 588438 Wright, Henry, of Wykhampton, yeoman 2
5035800 2367327 2367327 defendant Eche Henry husbandman 588438 588438 Eche, Henry, of Wykhampton, husbandman 2
5035804 2367328 2367328 defendant Skernyng Thomas clerk 588438 588438 Skernyng, Thomas, of Wykhampton, clerk 0
5038741 2368233 2368233 defendant Hardy John yeoman 588438 588438 Hardy, John, of Wykhampton, yeoman 1
5047709 2370932 2370932 defendant Hardy John yeoman 588438 588438 Hardy, John, of Wykhampton, yeoman 0
5057524 2373821 2373821 defendant Thurkeld John yeoman 588438 588438 Thurkeld, John, of Wykhampton, yeoman 6
5065837 2376302 2376302 defendant Thurkyld John husbandman 588438 588438 Thurkyld, John, of Wykhampton, husbandman 0
5105651 2388102 2388102 defendant Thurkeld John yeoman 588438 588438 Thurkeld, John, of Wykhampton, yeoman 5
5230303 2424481 2424481 defendant Thurkeld John yeoman 588438 588438 Thurkeld, John, of Wykhampton, yeoman 2
5314537 2449379 2449379 defendant Seman Thomas yeoman 588438 588438 Seman, Thomas, of Wykhampton, yeoman 0
5329546 2453901 2453901 defendant Garner John husbandman 588438 588438 Garner, John, of Wykhampton, husbandman 4
5329547 2453901 2453901 defendant Julles Roge husbandman 588438 588438 Julles, Roge, of Wykhampton, husbandman 5
5329550 2453901 2453901 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 8
5331826 2454598 2454598 defendant Seman Thomas yeoman 588438 588438 Seman, Thomas, of Wykhampton, yeoman 1
5336621 2456022 2456022 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 0
5336622 2456022 2456022 defendant Julles Roger husbandman 588438 588438 Julles, Roger, of Wykhampton, husbandman 1
5364710 2464625 2464625 defendant Thurkeld John husbandman 588438 588438 Thurkeld, John, of Wykhampton, husbandman 0
5364711 2464625 2464625 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 1
5364712 2464625 2464625 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 2
5366668 2465227 2465227 defendant Inllys or Jullys Roger husbandman 588438 588438 Inllys or Jullys, Roger, of Wykhampton, husbandman 1
5366671 2465228 2465228 defendant Jullys or Inllys Roger husbandman 588438 588438 Jullys or Inllys, Roger, of Wykhampton, husbandman 1
5383727 2470430 2470430 defendant Thurkeld John husbandman 588438 588438 Thurkeld, John, of Wykhampton, husbandman 0
5403414 2476050 2476050 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 0
5416479 2479846 2479846 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 0
5433298 2484925 2484925 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 0
5442150 2487569 2487569 defendant Jullys or Inylys Roger husbandman 588438 588438 Jullys or Inylys, Roger, of Wykhampton, husbandman 1
5454893 2491380 2491380 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 1
5460465 2493072 2493072 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 1
5465938 2494739 2494739 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 1
5466731 2494996 2494996 defendant Juyllys Roger husbandman 588438 588438 Juyllys, Roger, of Wykhampton, husbandman 1
5466734 2494997 2494997 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 1
5478049 2498457 2498457 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 0
5478051 2498458 2498458 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 0
5479164 2498791 2498791 defendant Seman Thomas   588438 588438 Seman, Thomas, of Wykhampton 2
5506282 2506880 2506880 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 3
5506505 2506940 2506940 defendant Seman Thomas husbandman 588438 588438 Seman, Thomas, of Wykhampton, husbandman 0
5506506 2506940 2506940 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 1
5506508 2506940 2506940 defendant Thurkeld John husbandman 588438 588438 Thurkeld, John, of Wykhampton, husbandman 3
5506759 2507034 2507034 defendant Jullys Roger husbandman 588438 588438 Jullys, Roger, of Wykhampton, husbandman 2
5588128 2531296 2531296 defendant Galys John yeoman 588438 588438 Galys, John, of Wykhampton, yeoman 6

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);