names

38 rows where place_id = 607947

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671615 1917107 1917107 defendant Slye Oliver yeoman 607947 607947 Slye, Oliver, of Lapworth, yeoman 1
3695811 1924923 1924923 defendant Hey John yeoman 607947 607947 Hey, John, of Lapworth, yeoman 1
3713890 1930644 1930644 defendant Slye Roger gent 607947 607947 Slye, Roger, of Lapworth, gent 2
3718194 1931975 1931975 defendant Hey John yeoman 607947 607947 Hey, John, of Lapworth, yeoman 0
3764414 1946532 1946532 defendant Hay John yeoman 607947 607947 Hay, John, of Lapworth, yeoman 0
3797116 1956980 1956980 defendant Haye John yeoman 607947 607947 Haye, John, of Lapworth, yeoman 0
4026903 2034272 2034272 plaintiff Catesby Edward gent 607947 607947 Catesby, Edward, of Lapworth, gent 0
4031421 2035906 2035906 defendant Catysbye Richard gent 607947 607947 Catysbye, Richard, of Lapworth, gent 0
4031423 2035907 2035907 defendant Catysbye Richard gent 607947 607947 Catysbye, Richard, of Lapworth, gent 0
4174737 2086634 2086634 defendant Thacker William yeoman 607947 607947 Thacker, William, of Lapworth, yeoman 0
4279140 2122635 2122635 defendant Harward alias Catesbye Elizabeth widow 607947 607947 Harward alias Catesbye, Elizabeth, of Lapworth, widow 0
4295085 2128325 2128325 defendant Bacon Thomas yeoman 607947 607947 Bacon, Thomas, of Lapworth, yeoman 0
4327601 2139554 2139554 defendant Lovett Thomas gent 607947 607947 Lovett, Thomas, of Lapworth, gent 2
4371774 2154964 2154964 defendant Cotterell Henry laborer 607947 607947 Cotterell, Henry, of Lapworth, laborer 1
4379440 2157726 2157726 defendant Lawrence alias Clark Robert yeoman 607947 607947 Lawrence alias Clark, Robert, of Lapworth, yeoman 0
4513838 2204753 2204753 plaintiff Bukmore John   607947 607947 Bukmore, John, of Lapworth 1
4515428 2205241 2205241 defendant Gourgevyle William   607947 607947 Gourgevyle, William, of Lapworth 0
4536728 2211763 2211763 defendant Creweley John   607947 607947 Creweley, John, of Lapworth 2
4582780 2226051 2226051 defendant Sly Walter   607947 607947 Sly, Walter, of Lapworth 0
4582781 2226051 2226051 defendant Cook John   607947 607947 Cook, John, of Lapworth 1
4605937 2232971 2232971 defendant Sly Walter   607947 607947 Sly, Walter, of Lapworth 0
4614099 2235421 2235421 defendant Spenser Thomas   607947 607947 Spenser, Thomas, of Lapworth 0
4614101 2235421 2235421 defendant Sly Simon   607947 607947 Sly, Simon, of Lapworth 2
4680820 2259622 2259622 defendant Blithe William husbandman 607947 607947 Blithe, William, of Lapworth, husbandman 2
4706522 2267420 2267420 defendant Blythe William husbandman 607947 607947 Blythe, William, of Lapworth, husbandman 2
4706523 2267420 2267420 defendant Person William yeoman 607947 607947 Person, William, of Lapworth, yeoman 3
4793194 2293968 2293968 defendant Spencer Thomas husbandman 607947 607947 Spencer, Thomas, of Lapworth, husbandman 1
4826570 2304346 2304346 defendant Broun Robert husbandman 607947 607947 Broun, Robert, of Lapworth, husbandman 1
4932357 2336516 2336516 defendant Pratte John husbandman 607947 607947 Pratte, John, of Lapworth, husbandman 4
4974109 2349218 2349218 defendant Walton Thomas husbandman 607947 607947 Walton, Thomas, of Lapworth, husbandman 5
4976880 2350036 2350036 defendant Holt Almaric gent 607947 607947 Holt, Almaric, of Lapworth, gent 0
5057569 2373832 2373832 defendant Sly John husbandman 607947 607947 Sly, John, of Lapworth, husbandman 0
5076712 2379534 2379534 defendant Prat Thomas husbandman 607947 607947 Prat, Thomas, of Lapworth, husbandman 1
5267339 2435548 2435548 defendant Symondes Simon yeoman 607947 607947 Symondes, Simon, of Lapworth, yeoman 1
5294975 2443521 2443521 defendant Broun Thomas capenter 607947 607947 Broun, Thomas, of Lapworth, capenter 0
5308055 2447432 2447432 defendant Appulby Thomas yeoman 607947 607947 Appulby, Thomas, of Lapworth, yeoman 1
5362721 2463988 2463988 defendant Slye John husbandman 607947 607947 Slye, John, of Lapworth, husbandman 4
5374498 2467627 2467627 defendant Broun Thomas carpenter 607947 607947 Broun, Thomas, of Lapworth, carpenter 3

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