names

34 rows where place_id = 607909

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671404 1917035 1917035 defendant Webbe Nicholas laborer 607909 607909 Webbe, Nicholas, of Chynnore, laborer 1
3671405 1917035 1917035 defendant Robyns Thomas husbandman 607909 607909 Robyns, Thomas, of Chynnore, husbandman 2
3671429 1917043 1917043 defendant Robyns William pulter 607909 607909 Robyns, William, of Chynnore, pulter 1
3753733 1943109 1943109 defendant Goodknave alias Goodchylde Richard husbandman 607909 607909 Goodknave alias Goodchylde, Richard, of Chynnore, husbandman 0
3797595 1957144 1957144 defendant Marche John husbandman 607909 607909 Marche, John, of Chynnore, husbandman 1
3822294 1964879 1964879 defendant Kyng Thomas husbandman 607909 607909 Kyng, Thomas, of Chynnore, husbandman 0
3848992 1973281 1973281 plaintiff Lambard Richard butcher 607909 607909 Lambard, Richard, of Chynnore, butcher 0
3848993 1973281 1973281 defendant Puffe alias Smyth John smith 607909 607909 Puffe alias Smyth, John, of Chynnore, smith 0
3865713 1978755 1978755 defendant Donney alias Marche John husbandman 607909 607909 Donney alias Marche, John, of Chynnore, husbandman 0
4520370 2206716 2206716 plaintiff Fisshere John   607909 607909 Fisshere, John, of Chynnore 0
4520373 2206717 2206717 plaintiff Fisshere John   607909 607909 Fisshere, John, of Chynnore 0
4520376 2206718 2206718 plaintiff Fisshere John   607909 607909 Fisshere, John, of Chynnore 0
4521289 2207003 2207003 plaintiff Fysshere John   607909 607909 Fysshere, John, of Chynnore 0
4548402 2215439 2215439 defendant Bocher John   607909 607909 Bocher, John, of Chynnore 0
4552489 2216736 2216736 plaintiff Fisshere John   607909 607909 Fisshere, John, of Chynnore 0
4552493 2216737 2216737 plaintiff Fisshere John   607909 607909 Fisshere, John, of Chynnore 0
4596763 2230228 2230228 defendant Fyssher John   607909 607909 Fyssher, John, of Chynnore 0
4612864 2235086 2235086 defendant Fissher John   607909 607909 Fissher, John, of Chynnore 0
4612925 2235102 2235102 defendant Fyssher John   607909 607909 Fyssher, John, of Chynnore 0
4671629 2256773 2256773 defendant Thame Robert husbandman 607909 607909 Thame, Robert, of Chynnore, husbandman 2
4701266 2265796 2265796 plaintiff Fyssher John   607909 607909 Fyssher, John, of Chynnore 0
4712560 2269246 2269246 plaintiff Smyth Richard   607909 607909 Smyth, Richard, of Chynnore 0
4738270 2277063 2277063 defendant Fenyan Robert husbandman 607909 607909 Fenyan, Robert, of Chynnore, husbandman 2
4754203 2281693 2281693 defendant Nasshe Thomas clerk 607909 607909 Nasshe, Thomas, of Chynnore, clerk 0
4810553 2299446 2299446 defendant Estwode John   607909 607909 Estwode, John, of Chynnore, shepherd 0
4811806 2299805 2299805 defendant Lye Richard husbandman 607909 607909 Lye, Richard, of Chynnore, husbandman 0
5006138 2358683 2358683 defendant Est Thomas husbandman 607909 607909 Est, Thomas, of Chynnore, husbandman 0
5006140 2358684 2358684 defendant Est Thomas yeoman 607909 607909 Est, Thomas, of Chynnore, yeoman 0
5060658 2374767 2374767 defendant Est Thomas yeoman 607909 607909 Est, Thomas, of Chynnore, yeoman 0
5102548 2387149 2387149 defendant Stevenes Richard husbandman 607909 607909 Stevenes, Richard, of Chynnore, husbandman 0
5118900 2391958 2391958 defendant Est Thomas husbandman 607909 607909 Est, Thomas, of Chynnore, husbandman 0
5118901 2391958 2391958 defendant Est Joan widow 607909 607909 Est, Joan, of Chynnore, widow 1
5229728 2424314 2424314 defendant Williams John husbandman 607909 607909 Williams, John, of Chynnore, husbandman 0
5230910 2424648 2424648 defendant Wyllyams John husbandman 607909 607909 Wyllyams, John, of Chynnore, 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);