names

56 rows where place_id = 613042

✎ 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
3696313 1925067 1925067 defendant Spreges Thomas butcher 613042 613042 Spreges, Thomas, of Rendham, butcher 0
3743907 1939979 1939979 defendant Brown Richard husbandman 613042 613042 Brown, Richard, of Rendham, husbandman 0
3749040 1941630 1941630 defendant Brown Thomas husbandman 613042 613042 Brown, Thomas, of Rendham, husbandman 0
3763618 1946259 1946259 defendant Brown Thomas husbandman 613042 613042 Brown, Thomas, of Rendham, husbandman 0
3809289 1960785 1960785 defendant Norman Thomas butcher 613042 613042 Norman, Thomas, of Rendham, butcher 0
3813096 1962004 1962004 defendant Heyloke Thomas butcher 613042 613042 Heyloke, Thomas, of Rendham, butcher 1
3841069 1970781 1970781 defendant Bryggys Thomas husbandman 613042 613042 Bryggys, Thomas, of Rendham, husbandman 1
3845021 1971995 1971995 defendant Typpon Robert husbandman 613042 613042 Typpon, Robert, of Rendham, husbandman 0
3886818 1985853 1985853 defendant Thurston Robert yeoman 613042 613042 Thurston, Robert, of Rendham, yeoman 0
3894503 1988370 1988370 defendant Hakon Robert carpenter 613042 613042 Hakon, Robert, of Rendham, carpenter 0
3920481 1997198 1997198 defendant Myddelton William yeoman 613042 613042 Myddelton, William, of Rendham, yeoman 0
3937348 2002827 2002827 defendant Hakon Robert yeoman 613042 613042 Hakon, Robert, of Rendham, yeoman 0
3938430 2003196 2003196 defendant Mydleton William yeoman 613042 613042 Mydleton, William, of Rendham, yeoman 0
3958298 2009978 2009978 defendant Thurston Thomas husbandman 613042 613042 Thurston, Thomas, of Rendham, husbandman 0
3969495 2013939 2013939 plaintiff Cotwen John husbandman 613042 613042 Cotwen, John, of Rendham, husbandman 0
3986525 2019921 2019921 defendant Thurston Thomas yeoman 613042 613042 Thurston, Thomas, of Rendham, yeoman 3
3998839 2024340 2024340 defendant Thurston Thomas yeoman 613042 613042 Thurston, Thomas, of Rendham, yeoman 0
4110260 2063931 2063931 defendant Fale Henry husbandman 613042 613042 Fale, Henry, of Rendham, husbandman 0
4163428 2082733 2082733 defendant Crane William yeoman 613042 613042 Crane, William, of Rendham, yeoman 0
4203412 2096744 2096744 defendant Thurston Thomas yeoman 613042 613042 Thurston, Thomas, of Rendham, yeoman 3
4216089 2101120 2101120 defendant Calver William tanner 613042 613042 Calver, William, of Rendham, tanner 2
4243434 2110796 2110796 defendant Thurston John yeoman 613042 613042 Thurston, John, of Rendham, yeoman 0
4390943 2161587 2161587 defendant Flyngant Thomas yeoman 613042 613042 Flyngant, Thomas, of Rendham, yeoman 0
4390950 2161589 2161589 defendant Flyngant Thomas yeoman 613042 613042 Flyngant, Thomas, of Rendham, yeoman 0
4426126 2172978 2172978 defendant Norton Hamo de   613042 613042 Norton, Hamo de, of Rendham 0
4465095 2189739 2189739 defendant Geffes William   613042 613042 Geffes, William, of Rendham 2
4575493 2223844 2223844 defendant Purs Edmund   613042 613042 Purs, Edmund, of Rendham 0
4597754 2230549 2230549 defendant Parmasey John tailor 613042 613042 Parmasey, John, of Rendham, tailor 0
4597757 2230550 2230550 defendant Parmafey John tailor 613042 613042 Parmafey, John, of Rendham, tailor 0
4656005 2247757 2247757 defendant Hamund Thomas pedder 613042 613042 Hamund, Thomas, of Rendham, pedder 0
4664178 2250284 2250284 plaintiff Halle John   613042 613042 Halle, John, of Rendham 0
4677796 2258675 2258675 defendant Hamond Thomas husbandman 613042 613042 Hamond, Thomas, of Rendham, husbandman 0
4681530 2259835 2259835 defendant Hamond Thomas cheseman 613042 613042 Hamond, Thomas, of Rendham, cheseman 0
4687996 2261814 2261814 defendant Ballar-- Walter   613042 613042 Ballar--, Walter, of Rendham 2
4693295 2263404 2263404 defendant Fyske John husbandman 613042 613042 Fyske, John, of Rendham, husbandman 0
4750813 2280720 2280720 plaintiff Runtyng William   613042 613042 Runtyng, William, of Rendham 0
4753288 2281409 2281409 defendant Webbe John   613042 613042 Webbe, John, of Rendham, vicar 3
4796533 2295072 2295072 defendant Coytyf Richard husbandman 613042 613042 Coytyf, Richard, of Rendham, husbandman 0
4796534 2295072 2295072 defendant Spergaunt William tailor 613042 613042 Spergaunt, William, of Rendham, tailor 1
4805717 2297998 2297998 defendant Runtyng William shoemaker 613042 613042 Runtyng, William, of Rendham, shoemaker 0
4812505 2300025 2300025 defendant Fysk John   613042 613042 Fysk, John, of Rendham 0
4840356 2308528 2308528 defendant Ryntyng William yeoman 613042 613042 Ryntyng, William, of Rendham, yeoman 0
4849566 2311340 2311340 defendant Runtyng William husbandman 613042 613042 Runtyng, William, of Rendham, husbandman 0
4860926 2314776 2314776 defendant Fysk John yeoman 613042 613042 Fysk, John, of Rendham, yeoman 0
4874290 2318903 2318903 defendant Clerk Robert husbandman 613042 613042 Clerk, Robert, of Rendham, husbandman 0
4933189 2336772 2336772 defendant Palmer Robert husbandman 613042 613042 Palmer, Robert, of Rendham, husbandman 2
5025728 2364428 2364428 defendant Too John tailor 613042 613042 Too, John, of Rendham, tailor 0
5092400 2384156 2384156 defendant Runtyng Robert yeoman 613042 613042 Runtyng, Robert, of Rendham, yeoman 0
5097102 2385585 2385585 defendant Lunnas Ralph husbandman 613042 613042 Lunnas, Ralph, of Rendham,husbandman 1
5110637 2389510 2389510 defendant Baldewyn Edmund barker 613042 613042 Baldewyn, Edmund, of Rendham, barker 0
5125281 2393873 2393873 defendant Runtyng William husbandman 613042 613042 Runtyng, William, of Rendham, husbandman 2
5135102 2396764 2396764 defendant Pye William carpneter 613042 613042 Pye, William, of Rendham, carpneter 1
5171926 2407504 2407504 defendant Pye William carpenter 613042 613042 Pye, William, of Rendham, carpenter 1
5497381 2504156 2504156 defendant Deryng Robert husbandman 613042 613042 Deryng, Robert, of Rendham, husbandman 0
5560106 2522915 2522915 defendant Lundenes William husbandman 613042 613042 Lundenes, William, of Rendham, husbandman 0
5633072 2554346 2554346 defendant Fyssk John husbandman 613042 613042 Fyssk, John, of Rendham, 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);