names

61 rows where place_id = 592219

✎ 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
3606976 1869844 1869844 defendant Gale Thomas gent 592219 592219 Gale, Thomas, of Dertmouth, Devon, gent 0
3625859 1902941 1902941 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 0
3640330 1907407 1907407 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 2
3663771 1914601 1914601 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 0
3679686 1919713 1919713 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 0
3714180 1930734 1930734 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 1
3714184 1930735 1930735 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 1
3814317 1962388 1962388 defendant Longmede Nicholas gent 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, gent 0
3820497 1964293 1964293 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 0
3820500 1964294 1964294 defendant Longmede Nicholas merchant 592219 592219 Longmede, Nicholas, of Dertmouth, Devon, merchant 0
3826624 1966173 1966173 defendant Langmede Nicholas merchant 592219 592219 Langmede, Nicholas, of Dertmouth, Devon, merchant 0
3857527 1975990 1975990 defendant Predys Richard merchant 592219 592219 Predys, Richard, of Dertmouth, Devon, merchant 0
3932017 2001009 2001009 defendant Predyaux Richard yeoman 592219 592219 Predyaux, Richard, of Dertmouth, Devon, yeoman 0
3936635 2002579 2002579 defendant Adams Nicholas gent 592219 592219 Adams, Nicholas, of Dertmouth, Devon, gent 0
3941596 2004201 2004201 defendant Predyaux Richard yeoman 592219 592219 Predyaux, Richard, of Dertmouth, Devon, yeoman 0
4933733 2336928 2336928 defendant Haweley Nicholas esq 592219 592219 Haweley, Nicholas, of Dertmouth, Devon, esq 0
4961342 2345358 2345358 defendant Buk William merchant 592219 592219 Buk, William, of Dertmouth, Devon, merchant 0
4977461 2350224 2350224 defendant Gylle Thomas gent 592219 592219 Gylle, Thomas, of Dertmouth, Devon, or of London, gent 0
4977463 2350225 2350225 defendant Gylle Thomas gent 592219 592219 Gylle, Thomas, of Dertmouth, Devon, or of London, gent 0
4981578 2351402 2351402 defendant Boordys Mathew merchant 592219 592219 Boordys, Mathew, of Dertmouth, Devon, merchant 0
5020063 2362754 2362754 defendant Bordys Mathew merchant 592219 592219 Bordys, Mathew, of Dertmouth, Devon, merchant 0
5038984 2368305 2368305 plaintiff Gylle Thomas gent 592219 592219 Gylle, Thomas, of Dertmouth, Devon, gent 2
5079018 2380208 2380208 defendant Payne Robert mariner 592219 592219 Payne, Robert, of Dertmouth, Devon, mariner 2
5079658 2380405 2380405 defendant Skelton John merchant 592219 592219 Skelton, John, of Dertmouth, Devon, merchant 0
5087944 2382853 2382853 defendant Newman John merchant 592219 592219 Newman, John, of Dertmouth, Devon, merchant 1
5113933 2390463 2390463 defendant Stebbyng Nicholas merchant 592219 592219 Stebbyng, Nicholas, of Dertmouth, Devon, merchant 0
5120817 2392519 2392519 defendant Gille Thomas gent 592219 592219 Gille, Thomas, of Dertmouth, Devon, gent 0
5120821 2392520 2392520 defendant Gille Thomas, senior gent 592219 592219 Gille, Thomas, senior, of Dertmouth, Devon, gent 0
5120824 2392521 2392521 defendant Gille Thomas, senior gent 592219 592219 Gille, Thomas, senior, of Dertmouth, Devon, gent 0
5120828 2392522 2392522 defendant Gylle Thomas, senior gent 592219 592219 Gylle, Thomas, senior, of Dertmouth, Devon, gent 0
5120831 2392523 2392523 defendant Stebbyng Nicholas merchant 592219 592219 Stebbyng, Nicholas, of Dertmouth, Devon, merchant 0
5132543 2396012 2396012 defendant Weston John mariner 592219 592219 Weston, John, of Dertmouth, Devon, mariner 1
5140289 2398263 2398263 defendant Gille Thomas gent 592219 592219 Gille, Thomas, of Dertmouth, Devon, gent 0
5226525 2423422 2423422 defendant Wonyngton John merchant 592219 592219 Wonyngton, John, of Dertmouth, Devon, merchant 1
5233772 2425465 2425465 defendant Phelipp John merchant 592219 592219 Phelipp, John, of Dertmouth, Devon, merchant 0
5244925 2428688 2428688 defendant Wrangebroke Thomas merchant 592219 592219 Wrangebroke, Thomas, of Dertmouth, Devon, merchant 1
5244934 2428691 2428691 defendant Wrangebroke Thomas merchant 592219 592219 Wrangebroke, Thomas, of Dertmouth, Devon, merchant 1
5262715 2434082 2434082 defendant Gale Thomas merchant 592219 592219 Gale, Thomas, of Dertmouth, Devon, gent, or of London, merchant 0
5269852 2436289 2436289 defendant Gose Thomas gent 592219 592219 Gose, Thomas, of Dertmouth, Devon, gent 0
5286057 2440930 2440930 defendant Gale Thomas gent 592219 592219 Gale, Thomas, of Dertmouth, Devon, gent 0
5331943 2454629 2454629 defendant Wychals John merchant 592219 592219 Wychals, John, of Dertmouth, Devon, merchant 0
5336666 2456037 2456037 defendant Dunrygge William chapman 592219 592219 Dunrygge, William, of Dertmouth, Devon, chapman 1
5341460 2457522 2457522 defendant Gale Thomas gent 592219 592219 Gale, Thomas, of Dertmouth, Devon, gent 2
5375820 2468031 2468031 defendant Wemyngton Nicholas merchant & purser 592219 592219 Wemyngton, Nicholas, of Dertmouth, Devon, merchant & purser 0
5441237 2487292 2487292 defendant Gale Thomas   592219 592219 Gale, Thomas, of Dertmouth, Devon 0
5454108 2491129 2491129 defendant Gale Thomas   592219 592219 Gale, Thomas, of Dertmouth, Devon 0
5454623 2491301 2491301 defendant Gale Thomas merchant 592219 592219 Gale, Thomas, of Dertmouth, Devon, merchant 0
5454625 2491302 2491302 defendant Gale Thomas merchant 592219 592219 Gale, Thomas, of Dertmouth, Devon, merchant 0
5461409 2493364 2493364 defendant Gale Thomas merchant 592219 592219 Gale, Thomas, of Dertmouth, Devon, merchant 0
5466473 2494909 2494909 defendant Gale Thomas merchant 592219 592219 Gale, Thomas, of Dertmouth, Devon, merchant 0
5489951 2501883 2501883 defendant Wyllyngton Nicholas merchant 592219 592219 Wyllyngton, Nicholas, of Dertmouth, Devon, merchant 0
5504269 2506252 2506252 plaintiff Amadas Walter   592219 592219 Amadas, Walter, of Dertmouth, Devon 0
5525657 2512617 2512617 defendant Fokerey Joan widow 592219 592219 Fokerey, Joan, of Dertmouth, Devon, widow 0
5536012 2515765 2515765 defendant Ley William merchant 592219 592219 Ley, William, of Dertmouth, Devon, merchant 0
5536018 2515766 2515766 defendant Ley William merchant 592219 592219 Ley, William, of Dertmouth, Devon, merchant 0
5536025 2515767 2515767 defendant Ley William merchant 592219 592219 Ley, William, of Dertmouth, Devon, merchant 0
5539697 2516896 2516896 defendant Fokerey Joan widow 592219 592219 Fokerey, Joan, of Dertmouth, Devon, widow 0
5584172 2530120 2530120 defendant Focray Joan widow 592219 592219 Focray, Joan, of Dertmouth, Devon, widow 0
5626838 2552367 2552367 defendant Bacheler Walter merchant 592219 592219 Bacheler, Walter, of Dertmouth, Devon, merchant 0
5628949 2553023 2553023 defendant Coyll John merchant 592219 592219 Coyll, John, of Dertmouth, Devon, merchant 1
5628953 2553024 2553024 defendant Coyll John merchant 592219 592219 Coyll, John, of Dertmouth, Devon, merchant 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);