names

39 rows where place_id = 594848

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617822 1873199 1873199 defendant Walle Richard draper 594848 594848 Walle, Richard, of North Alverton, draper 1
3617823 1873199 1873199 defendant Walle William draper 594848 594848 Walle, William, of North Alverton, draper 2
3617824 1873199 1873199 defendant Walle John draper 594848 594848 Walle, John, of North Alverton, draper 3
3942139 2004389 2004389 defendant Humfrey Ralph yeoman 594848 594848 Humfrey, Ralph, of North Alverton, yeoman 0
4420130 2171196 2171196 defendant Lounde John de la   594848 594848 Lounde, John de la, of North Alverton, son of Nicholas 0
4520686 2206819 2206819 plaintiff Forster Robert   594848 594848 Forster, Robert, of North Alverton 0
4520688 2206819 2206819 defendant Barnby John de   594848 594848 Barnby, John de, of North Alverton 1
4524134 2207881 2207881 plaintiff Heyden Roger   594848 594848 Heyden, Roger, of North Alverton 0
4524135 2207881 2207881 defendant Fissher John   594848 594848 Fissher, John, of North Alverton 0
4524136 2207882 2207882 plaintiff Heyden Roger   594848 594848 Heyden, Roger, of North Alverton 0
4524137 2207882 2207882 defendant Smyth Thomas   594848 594848 Smyth, Thomas, of North Alverton 0
4524138 2207883 2207883 plaintiff Heyden Roger   594848 594848 Heyden, Roger, of North Alverton 0
4524140 2207884 2207884 plaintiff Heyden Roger   594848 594848 Heyden, Roger, of North Alverton 0
4524141 2207884 2207884 defendant Webbester Robert   594848 594848 Webbester, Robert, of North Alverton 0
4524142 2207885 2207885 plaintiff Heyden Roger   594848 594848 Heyden, Roger, of North Alverton 0
4524143 2207885 2207885 defendant Wellester Robert   594848 594848 Wellester, Robert, of North Alverton 0
4524144 2207886 2207886 plaintiff Heydon Roger   594848 594848 Heydon, Roger, of North Alverton 0
4524150 2207887 2207887 plaintiff Heydon Roger   594848 594848 Heydon, Roger, of North Alverton 0
4524151 2207887 2207887 defendant Webbester Robert   594848 594848 Webbester, Robert, of North Alverton 0
4529457 2209492 2209492 defendant Webbester Robert   594848 594848 Webbester, Robert, of North Alverton 0
4614502 2235543 2235543 defendant Emondson Thomas   594848 594848 Emondson, Thomas, of North Alverton 1
4631923 2240870 2240870 plaintiff Toveton Thomas de master of the hospital of St James 594848 594848 Toveton, Thomas de, of North Alverton, master of the hospital of St James 0
4631934 2240871 2240871 plaintiff Toveton Thomas   594848 594848 Toveton, Thomas, of North Alverton, master of the hospital of St James, sucessor to John Hylyare, the former master 0
4768596 2286158 2286158 defendant Rowe Gillian widow 594848 594848 Rowe, Gillian, of North Alverton, widow 0
4809654 2299184 2299184 defendant Silton John smith 594848 594848 Silton, John, of North Alverton, smith 3
4809655 2299184 2299184 defendant Smyth Thomas smith 594848 594848 Smyth, Thomas, of North Alverton, smith 4
4809656 2299184 2299184 defendant Kyng John smith 594848 594848 Kyng, John, of North Alverton, smith 5
4809657 2299184 2299184 defendant Helmeslay Robert yeoman 594848 594848 Helmeslay, Robert, of North Alverton, yeoman 6
4809658 2299184 2299184 defendant Carter William smith 594848 594848 Carter, William, of North Alverton, smith 7
4817499 2301565 2301565 plaintiff More Richard de draper 594848 594848 More, Richard de, of North Alverton, draper 0
4910903 2329920 2329920 defendant Luncan John yeoman 594848 594848 Luncan, John, of North Alverton, yeoman 0
5021376 2363158 2363158 defendant Seton Margaret widow 594848 594848 Seton, Margaret, of North Alverton, widow 0
5052645 2372383 2372383 defendant Ottelay William shoemaker 594848 594848 Ottelay, William, of North Alverton, shoemaker 1
5052646 2372383 2372383 defendant Bermyngham Richard shoemaker 594848 594848 Bermyngham, Richard, of North Alverton, shoemaker 2
5064669 2375972 2375972 defendant Otley William shoemaker 594848 594848 Otley, William, of North Alverton, shoemaker 0
5154201 2402386 2402386 defendant Wright John yeoman 594848 594848 Wright, John, of North Alverton, yeoman 0
5171344 2407344 2407344 defendant Wright John   594848 594848 Wright, John, of North Alverton 0
5236069 2426132 2426132 defendant Trendan John clerk 594848 594848 Trendan, John, of North Alverton, clerk 0
5379778 2469256 2469256 defendant Ampulfurth William   594848 594848 Ampulfurth, William, of North Alverton, franklin 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);