names

40 rows where place_id = 619220

✎ 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
3728752 1935233 1935233 defendant Carter John husbandman 619220 619220 Carter, John,of Wytlesford, husbandman 0
3737875 1938065 1938065 defendant Eye John carpenter 619220 619220 Eye, John, of Wytlesford, carpenter 0
3742546 1939540 1939540 defendant Rande William yeoman 619220 619220 Rande, William, of Wytlesford, yeoman 1
3742548 1939540 1939540 defendant Eye or Gye John carpenter 619220 619220 Eye or Gye, John, of Wytlesford, carpenter 3
3789842 1954650 1954650 defendant Wellys Edward   619220 619220 Wellys, Edward, of Wytlesford, organ maker 0
3923890 1998301 1998301 defendant Spiser Robert cooper 619220 619220 Spiser, Robert, of Wytlesford, cooper 0
4540012 2212784 2212784 defendant Staunford John de   619220 619220 Staunford, John de, of Wytlesford, vicar 0
4661404 2249391 2249391 defendant Coche Simon husbandman 619220 619220 Coche, Simon, of Wytlesford, husbandman 1
4661407 2249392 2249392 defendant Brounyng Maud brewster 619220 619220 Brounyng, Maud, of Wytlesford, brewster 0
4661408 2249392 2249392 defendant Coche Simon husbandman 619220 619220 Coche, Simon, of Wytlesford, husbandman 1
4715166 2270072 2270072 defendant Dulkyn John husbandman 619220 619220 Dulkyn, John, of Wytlesford, husbandman 1
4741066 2277896 2277896 defendant Gellesson William husbandman 619220 619220 Gellesson, William, of Wytlesford, husbandman 0
4741067 2277896 2277896 defendant Soidre John husbandman 619220 619220 Soidre, John, of wytlesford, husbandman 1
4811466 2299696 2299696 defendant Rose John husbandman 619220 619220 with Rose, John, of Wytlesford, husbandman 1
4818367 2301824 2301824 defendant Mareys Thomas husbandman 619220 619220 Mareys, Thomas, of Wytlesford, husbandman 2
4874248 2318890 2318890 defendant Broun John husbandman 619220 619220 Broun, John, of Wytlesford, husbandman 2
4878017 2320080 2320080 defendant Swon John husbandman 619220 619220 Swon, John, of Wytlesford, husbandman 1
4989461 2353783 2353783 defendant Waynsed Simon husbandman 619220 619220 Waynsed, Simon, of Wytlesford, husbandman 1
4995828 2355598 2355598 defendant Best John husbandman 619220 619220 Best, John, of Wytlesford, husbandman 2
5014795 2361201 2361201 defendant Hunte Robert carpenter 619220 619220 Hunte, Robert, of Wytlesford, carpenter 1
5014796 2361201 2361201 defendant Jylson Thomas husbandman 619220 619220 Jylson, Thomas, of Wytlesford, husbandman 2
5017249 2361928 2361928 defendant Swon John maltman 619220 619220 Swon, John, of Wytlesford, maltman 4
5018056 2362165 2362165 defendant Cooke Henry husbandman 619220 619220 Cooke, Henry, of Wytlesford, husbandman 0
5023049 2363648 2363648 defendant Couchy John husbandman 619220 619220 Couchy, John, of Wytlesford, husbandman 2
5073126 2378449 2378449 defendant Brome John husbandman 619220 619220 Brome, John, of Wytlesford, husbandman 0
5092868 2384295 2384295 defendant Brome John husbandman 619220 619220 Brome, John, of Wytlesford, husbandman 0
5092869 2384295 2384295 defendant Neweton John maltman 619220 619220 Neweton, John, of Wytlesford, maltman 1
5092870 2384295 2384295 defendant Sadeler William husbandman 619220 619220 Sadeler, William, of Wytlesford, husbandman 2
5122412 2392983 2392983 defendant Cook Henry husbandman 619220 619220 Cook, Henry, of Wytlesford, husbandman 2
5163943 2405192 2405192 defendant Parker Thomas husbandman 619220 619220 Parker, Thomas, of Wytlesford, husbandman 1
5205369 2417324 2417324 defendant Robynet John husbandman 619220 619220 Robynet, John, of Wytlesford, husbandman 3
5407744 2477292 2477292 defendant Style John carpenter 619220 619220 Style, John, of Wytlesford, carpenter 0
5502844 2505802 2505802 defendant Aleyn John laborer 619220 619220 Aleyn, John, of Wytlesford, laborer 0
5504550 2506345 2506345 defendant Tylney Robert esq 619220 619220 Tylney, Robert, of Wytlesford, esq 0
5504555 2506346 2506346 defendant Tylney Robert esq 619220 619220 Tylney, Robert, of Wytlesford, esq 0
5627936 2552707 2552707 defendant Godyng John, junior yeoman 619220 619220 Godyng, John, junior, of Wytlesford, yeoman 0
5629305 2553143 2553143 plaintiff Rande John   619220 619220 Rande, John, of Wytlesford 0
5629306 2553143 2553143 defendant Brome John   619220 619220 Brome, John, of Wytlesford, "trompour" or trumpeter 0
5629308 2553144 2553144 plaintiff Rande John   619220 619220 Rande, John, of Wytlesford 0
5629309 2553144 2553144 defendant Brome John   619220 619220 Brome, John, of Wytlesford, "trompour" or trumpeter 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);