names

72 rows where place_id = 592833

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609094 1870502 1870502 defendant Drake John husbandman 592833 592833 Drake, John, of Wakton, husbandman 0
3645512 1908995 1908995 defendant Lavyle Thomas husbandman 592833 592833 Lavyle, Thomas, of Wakton, husbandman 8
3654006 1911517 1911517 defendant Hunts Robert butcher 592833 592833 Hunts, Robert, of Wakton, butcher 0
3704261 1927630 1927630 defendant Goche Geoffrey yeoman 592833 592833 Goche, Geoffrey, of Wakton, yeoman 0
3708075 1928827 1928827 defendant Norman alias Lavyle Thomas husbandman 592833 592833 Norman alias Lavyle, Thomas, of Wakton, husbandman 0
3719051 1932234 1932234 defendant Goche Geoffrey husbandman 592833 592833 Goche, Geoffrey, of Wakton, husbandman 4
3730870 1935882 1935882 defendant Lavill Thomas husbandman 592833 592833 Lavill, Thomas, of Wakton, husbandman 0
3730871 1935882 1935882 defendant Lavill William husbandman 592833 592833 Lavill, William, of Wakton, husbandman 1
3802170 1958575 1958575 defendant Lavyle alias Norman William husbandman 592833 592833 Lavyle alias Norman, William, of Wakton, husbandman 1
3875332 1981995 1981995 defendant Stryngfelawe Robert clerk 592833 592833 Stryngfelawe, Robert, of Wakton, clerk 0
3884588 1985117 1985117 defendant Seman John husbandman 592833 592833 Seman, John, of Wakton, husbandman 0
3888147 1986291 1986291 defendant Sendell Simon yeoman 592833 592833 Sendell, Simon, of Wakton, yeoman 2
3888148 1986291 1986291 defendant Wale Walter husbandman 592833 592833 Wale, Walter, of Wakton, husbandman 3
3888149 1986291 1986291 defendant Keryson Robert husbandman 592833 592833 Keryson, Robert, of Wakton, husbandman 4
3889919 1986866 1986866 defendant Ponyett John husbandman 592833 592833 Ponyett, John, of Wakton, husbandman 0
3889922 1986866 1986866 defendant Thorne alias Thornham John laborer 592833 592833 Thorne alias Thornham, John, of Wakton, laborer 3
3895051 1988554 1988554 defendant Thorne alias Thornham John laborer 592833 592833 Thorne alias Thornham, John, of Wakton, laborer 0
3913711 1994926 1994926 defendant Sendell Simon yeoman 592833 592833 Sendell, Simon, of Wakton, yeoman 0
4256547 2115159 2115159 defendant Lavyle John yeoman 592833 592833 Lavyle, John, of Wakton, yeoman 0
4449981 2184949 2184949 defendant Munde John   592833 592833 Munde, John, of Wakton 1
4724899 2273080 2273080 defendant Drake John husbandman 592833 592833 Drake, John, of Wakton, husbandman 2
4744878 2279018 2279018 defendant Drake John yeoman 592833 592833 Drake, John, of Wakton, yeoman 1
5115765 2391039 2391039 defendant Drake Nicholas yeoman 592833 592833 Drake, Nicholas, of Wakton, yeoman 4
5115769 2391039 2391039 defendant Botild William husbandman 592833 592833 Botild, William, of Wakton, husbandman 8
5124263 2393543 2393543 defendant Drake Nicholas yeoman 592833 592833 Drake, Nicholas, of Wakton, yeoman 7
5124317 2393558 2393558 defendant Drake Nicholas yeoman 592833 592833 Drake, Nicholas, of Wakton, yeoman 6
5142207 2398843 2398843 defendant Botyle John husbandman 592833 592833 Botyle, John, of Wakton, husbandman 1
5147350 2400369 2400369 defendant Drake Nicholas yeoman 592833 592833 Drake, Nicholas, of Wakton, yeoman 0
5147351 2400369 2400369 defendant Drake Walter husbandman 592833 592833 Drake, Walter, of Wakton, husbandman 1
5167096 2406108 2406108 defendant Drake Nicholas yeoman 592833 592833 Drake, Nicholas, of Wakton, yeoman 0
5167097 2406108 2406108 defendant Drake Walter husbandman 592833 592833 Drake, Walter, of Wakton, husbandman 1
5182365 2410597 2410597 defendant Drake Nicholas yeoman 592833 592833 Drake, Nicholas, of Wakton, yeoman 0
5277861 2438612 2438612 defendant Bocher alias Estowe Robert husbandman 592833 592833 Bocher alias Estowe, Robert, of Wakton, husbandman 0
5302748 2445805 2445805 defendant Drake Thomas husbandman 592833 592833 Drake, Thomas, of Wakton, husbandman 0
5306644 2446977 2446977 defendant Drake Thomas yeoman 592833 592833 Drake, Thomas, of Wakton, yeoman 0
5309532 2447887 2447887 defendant Sarys Nicholas husbandman 592833 592833 Sarys, Nicholas, of Wakton, husbandman 0
5324621 2452440 2452440 defendant Drake Thomas husbandman 592833 592833 Drake, Thomas, of Wakton, husbandman 1
5324689 2452454 2452454 defendant Stevenson John gent 592833 592833 Stevenson, John, of Wakton, gent 1
5345776 2458817 2458817 defendant Stevenson John gent 592833 592833 Stevenson, John, of Wakton, gent 1
5354915 2461611 2461611 defendant Botyld Thomas yeoman 592833 592833 Botyld, Thomas, of Wakton, yeoman 2
5361075 2463490 2463490 defendant Botyld Thomas yeoman 592833 592833 Botyld, Thomas, of Wakton, yeoman 1
5367432 2465464 2465464 defendant Lavyle alias Smyth Adam husbandman 592833 592833 Lavyle alias Smyth, Adam, of Wakton, husbandman 0
5368803 2465833 2465833 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 2
5369848 2466160 2466160 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 2
5369855 2466161 2466161 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 2
5373207 2467215 2467215 defendant Botyll Thomas yeoman 592833 592833 Botyll, Thomas, of Wakton, yeoman 0
5373208 2467215 2467215 defendant Sarys Nicholas yeoman 592833 592833 Sarys, Nicholas, of Wakton, yeoman 1
5376250 2468165 2468165 defendant Lavyle alias Smyth Adam husbandman 592833 592833 Lavyle alias Smyth, Adam, of Wakton, husbandman 0
5380003 2469331 2469331 defendant Bouke Thomas husbandman 592833 592833 Bouke, Thomas, of Wakton, husbandman 3
5380268 2469403 2469403 defendant Sarys Nicholas husbandman 592833 592833 Sarys, Nicholas, of Wakton, husbandman 0
5383348 2470316 2470316 defendant Sarys Nicholas husbandman 592833 592833 Sarys, Nicholas, of Wakton, husbandman 0
5400331 2475171 2475171 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5408808 2477595 2477595 defendant Boteler Thomas husbandman 592833 592833 Boteler, Thomas, of Wakton, husbandman 3
5412274 2478620 2478620 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 11
5412276 2478620 2478620 defendant Boteld Thomas husbandman 592833 592833 Boteld, Thomas, of Wakton, husbandman 13
5413326 2478917 2478917 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5426955 2483003 2483003 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 10
5426971 2483004 2483004 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 10
5426973 2483004 2483004 defendant Bolold Thomas husbandman 592833 592833 Bolold, Thomas, of Wakton, husbandman 12
5428528 2483459 2483459 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5428565 2483467 2483467 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5440523 2487069 2487069 defendant Sarys Nicholas husbandman 592833 592833 Sarys, Nicholas, of Wakton, husbandman 1
5477824 2498385 2498385 defendant Boteld Thomas husbandman 592833 592833 Boteld, Thomas, of Wakton, husbandman 3
5480614 2499167 2499167 defendant Sparke John husbandman 592833 592833 Sparke, John, of Wakton, husbandman 10
5480615 2499167 2499167 defendant Boteld Thomas husbandman 592833 592833 Boteld, Thomas, of Wakton, husbandman 11
5481626 2499434 2499434 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5516792 2510070 2510070 defendant Botyld Thomas husbandman 592833 592833 Botyld, Thomas, of Wakton, husbandman 4
5544143 2518282 2518282 defendant Salons Robert husbandman 592833 592833 Salons, Robert, of Wakton, husbandman 3
5544145 2518282 2518282 defendant Botyld Thomas husbandman 592833 592833 Botyld, Thomas, of Wakton, husbandman 5
5578154 2528238 2528238 defendant Hunt Robert butcher 592833 592833 Hunt, Robert, of Wakton, butcher 1
5582118 2529476 2529476 defendant Sarys Thomas yeoman 592833 592833 Sarys, Thomas, of Wakton, yeoman 1
5602184 2535582 2535582 defendant Lavyle Thomas husbandman 592833 592833 Lavyle, Thomas, of Wakton, husbandman 1

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