names

55 rows where place_id = 599042

✎ 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
3634951 1905733 1905733 defendant Wolcy Robert butcher 599042 599042 Wolcy, Robert, of Theberton, butcher 0
3690615 1923229 1923229 defendant Sudbury John husbandman 599042 599042 Sudbury, John, of Theberton, husbandman 0
3741195 1939105 1939105 defendant Baker John   599042 599042 Baker, John, of Theberton, court holder 0
3753485 1943027 1943027 defendant Pyggesdon alias Coke John husbandman 599042 599042 Pyggesdon alias Coke, John, of Theberton, husbandman 2
3754550 1943381 1943381 defendant Reve John carpenter 599042 599042 Reve, John, of Theberton, carpenter 0
3802517 1958682 1958682 plaintiff Pecok Richard   599042 599042 Pecok, Richard, of Theberton 0
3824245 1965459 1965459 defendant Pecok Richard husbandman 599042 599042 Pecok, Richard, of Theberton, husbandman 0
3862205 1977541 1977541 defendant Baker John yeoman 599042 599042 Baker, John, of Theberton, yeoman 1
4150946 2078461 2078461 defendant Jeney Arthur gent 599042 599042 Jeney, Arthur, of Theberton, gent 0
4191545 2092605 2092605 defendant Backler Barnard husbandman 599042 599042 Backler, Barnard, of Theberton, husbandman 3
4198874 2095162 2095162 defendant Joney Arthur gent 599042 599042 Joney, Arthur, of Theberton, gent 2
4203481 2096771 2096771 defendant Morsse George yeoman 599042 599042 Morsse, George, of Theberton, yeoman 1
4203482 2096771 2096771 defendant Benet Richard husbandman 599042 599042 Benet, Richard, of Theberton, husbandman 2
4306039 2132251 2132251 defendant Hayle John husbandman 599042 599042 Hayle, John, of Theberton, husbandman 0
4405337 2166362 2166362 defendant Wentworth Henry esq 599042 599042 Wentworth, Henry, of Theberton, esq 0
4476594 2193340 2193340 defendant Caune Richard   599042 599042 Caune, Richard, of Theberton 0
4558781 2218703 2218703 defendant Herm_ Richard   599042 599042 Herm_, Richard, of Theberton 0
4676080 2258131 2258131 defendant Woluene Thomas husbandman 599042 599042 Woluene, Thomas, of Theberton, husbandman 0
4907997 2329061 2329061 defendant Craton Nicholas (legal representative) 599042 599042 Craton, Nicholas, of Theberton, parson, administrator of 0
4938873 2338550 2338550 defendant Mose Edmund shoemaker 599042 599042 Mose, Edmund, of Theberton, shoemaker 0
4938874 2338550 2338550 defendant Thynglove William yeoman 599042 599042 Thynglove, William, of Theberton, yeoman 1
4964628 2346326 2346326 defendant Thynglove or Thynglone William husbandman 599042 599042 Thynglove or Thynglone, William, of Theberton, husbandman 0
4964629 2346326 2346326 defendant Sturmyn John husbandman 599042 599042 Sturmyn, John, of Theberton, husbandman 1
4970778 2348202 2348202 defendant Feld John husbandman 599042 599042 Feld, John, of Theberton, husbandman 0
4999823 2356826 2356826 defendant Sturmyn John husbandman 599042 599042 Sturmyn, John, of Theberton, husbandman 0
4999824 2356826 2356826 defendant Langton John husbandman 599042 599042 Langton, John, of Theberton, husbandman 1
5081581 2380995 2380995 defendant Gerveys alias Swynker Thomas butcer 599042 599042 Gerveys alias Swynker, Thomas, of Theberton, butcer 0
5098069 2385867 2385867 defendant Wyteman Robert yeoman 599042 599042 Wyteman, Robert, of Theberton, yeoman 3
5111335 2389707 2389707 defendant Jerveys Thomas yeoman 599042 599042 Jerveys, Thomas, of Theberton, yeoman 0
5116688 2391313 2391313 defendant Yeverton Edmund chapman 599042 599042 Yeverton, Edmund, of Theberton, chapman 1
5123203 2393225 2393225 defendant Jenney William gent 599042 599042 Jenney, William, of Theberton, gent 2
5125285 2393874 2393874 defendant Wightman Robert husbandman 599042 599042 Wightman, Robert, of Theberton, husbandman 0
5143868 2399343 2399343 defendant Wightman Robert husbandman 599042 599042 Wightman, Robert, of Theberton, husbandman 0
5143870 2399344 2399344 defendant Wightman Robert husbandman 599042 599042 Wightman, Robert, of Theberton, husbandman 0
5154173 2402377 2402377 defendant Wyghtman John butcher 599042 599042 Wyghtman, John, of Theberton, butcher 4
5154180 2402378 2402378 defendant Blofeld Thomas butcher 599042 599042 Blofeld, Thomas, of Theberton, butcher 5
5171326 2407339 2407339 defendant Wyghtman John butcher 599042 599042 Wyghtman, John, of Theberton, butcher 4
5171333 2407340 2407340 defendant Blofeld Thomas butcher 599042 599042 Blofeld, Thomas, of Theberton, butcher 5
5214705 2420029 2420029 defendant Whitman Robert yeoman 599042 599042 Whitman, Robert, of Theberton, yeoman 2
5237671 2426600 2426600 plaintiff Genney William   599042 599042 Genney, William, of Theberton 0
5242815 2428102 2428102 defendant Wyghtman Robert yeoman 599042 599042 Wyghtman, Robert, of Theberton, yeoman 4
5256215 2432069 2432069 plaintiff Deken John (legal representative) 599042 599042 Deken, John, of Theberton, administrator of 0
5256218 2432070 2432070 plaintiff Deken John   599042 599042 Deken, John, of Theberton, administrators of 0
5256220 2432070 2432070 defendant Sturmyn John yeoman 599042 599042 Sturmyn, John, of Theberton, yeoman 0
5279607 2439114 2439114 defendant Yeverston Edmund spicer 599042 599042 Yeverston, Edmund, of Theberton, spicer 0
5306169 2446833 2446833 plaintiff Cotyngham Geoffrey   599042 599042 Cotyngham, Geoffrey, of Theberton, warden of the goods & chattels of the church 1
5398250 2474569 2474569 defendant Enyrston Edmund husbandman 599042 599042 Enyrston, Edmund, of Theberton, husbandman 0
5411381 2478363 2478363 defendant Evyrston Edmund husbandman 599042 599042 Evyrston, Edmund, of Theberton, husbandman 0
5420170 2480950 2480950 defendant Williamson Robert tailor 599042 599042 Williamson, Robert, of Theberton, tailor 4
5438904 2486558 2486558 defendant Williamson Robert tailor 599042 599042 Williamson, Robert, of Theberton, tailor 4
5452783 2490711 2490711 defendant Williamson Robert tailor 599042 599042 Williamson, Robert, of Theberton, tailor 4
5464222 2494205 2494205 defendant Kegell Robert husbandman 599042 599042 Kegell, Robert, of Theberton, husbandman 1
5464223 2494205 2494205 defendant Kegell John husbandman 599042 599042 Kegell, John, of Theberton, husbandman 2
5585615 2530570 2530570 defendant Michell Thomas husbandman 599042 599042 Michell, Thomas, of Theberton, husbandman 1
5592919 2532785 2532785 defendant Broun William yeoman 599042 599042 Broun, William, of Theberton, 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);