names

55 rows where place_id = 591835

✎ 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
3605738 1869458 1869458 defendant Holtby John yeoman 591835 591835 Holtby, John, of Osgodby, yeoman 0
3669393 1916365 1916365 defendant Odrynggam Robert husbandman 591835 591835 Odrynggam, Robert, of Osgodby, husbandman 0
3702233 1926954 1926954 defendant Richardson Thomas husbandman 591835 591835 Richardson, Thomas, of Osgodby, husbandman 1
3744334 1940128 1940128 defendant Yong John husbandman 591835 591835 Yong, John, of Osgodby, husbandman 0
3884771 1985182 1985182 plaintiff Armyn William (legal representative) 591835 591835 Armyn, William, of Osgodby, esq, executor of 0
4064533 2047597 2047597 defendant Osgodby William yeoman 591835 591835 Osgodby, William, of Osgodby, yeoman 0
4415594 2169757 2169757 defendant atte See Richard   591835 591835 atte See, Richard, of Osgodby 0
4421919 2171731 2171731 plaintiff Welles John   591835 591835 Welles, John, of Osgodby 1
4469287 2191064 2191064 plaintiff Blyton Alice   591835 591835 Blyton, Alice, of Osgodby, formerly wife of John 0
4577678 2224524 2224524 defendant Graveley John   591835 591835 Graveley, John, of Osgodby 0
4585814 2226986 2226986 defendant Piper Richard   591835 591835 Piper, Richard, of Osgodby 1
4650079 2246039 2246039 plaintiff Wele Thomas   591835 591835 Wele, Thomas, of Osgodby 0
4656457 2247916 2247916 plaintiff Cateryk William (legal representative) 591835 591835 Cateryk, William, of Osgodby, executor of 0
4665906 2250813 2250813 defendant Leveryngton Nicholas husbandman 591835 591835 Leveryngton, Nicholas, of Osgodby, husbandman 0
4687260 2261622 2261622 defendant Hudsone John husbandman 591835 591835 Hudsone, John, of Osgodby, husbandman 0
4750740 2280699 2280699 defendant Cooke Johnn   591835 591835 Cooke, Johnn, of Osgodby, bailiff 3
4809588 2299164 2299164 defendant Osgodby John gent 591835 591835 Osgodby, John, of Osgodby, gent 1
4846610 2310452 2310452 defendant Barde Robert gent 591835 591835 Barde, Robert, of Osgodby, gent 0
4858040 2313883 2313883 defendant Dene John gent 591835 591835 Dene, John, of Osgodby, gent 2
4872231 2318276 2318276 plaintiff Neweton Thomas clerk 591835 591835 Neweton, Thomas, of Osgodby, clerk 0
4872234 2318276 2318276 defendant Chapman John husbandman 591835 591835 Chapman, John, of Osgodby, husbandman 2
4882794 2321540 2321540 defendant Coke John   591835 591835 Coke, John, of Osgodby, bailiff 4
4906925 2328748 2328748 defendant Paynell Geoffrey (legal representative) 591835 591835 Paynell, Geoffrey, of Osgodby, esq, executors of 0
4979384 2350795 2350795 defendant Barde Robert esq 591835 591835 Barde, Robert, of Osgodby, esq 0
4979386 2350795 2350795 defendant Tomson Stephen husbandman 591835 591835 together with Tomson, Stephen, of Osgodby, husbandman 2
4979387 2350795 2350795 defendant Watson John husbandman 591835 591835 Watson, John, of Osgodby, husbandman 3
4979388 2350795 2350795 defendant Baron Richard husbandman 591835 591835 Baron, Richard, of Osgodby, husbandman 4
4979389 2350795 2350795 defendant Prat John husbandman 591835 591835 Prat, John, of Osgodby, husbandman 5
4979390 2350795 2350795 defendant Prat William husbandman 591835 591835 Prat, William, of Osgodby, husbandman 6
4979399 2350796 2350796 defendant Tomson Stephen husbandman 591835 591835 Tomson, Stephen, of Osgodby, husbandman 0
4979400 2350796 2350796 defendant Watson John husbandman 591835 591835 Watson, John, of Osgodby, husbandman 1
4979401 2350796 2350796 defendant Baron Richard husbandman 591835 591835 Baron, Richard, of Osgodby, husbandman 2
4979403 2350796 2350796 defendant Prat William husbandman 591835 591835 Prat, William, of Osgodby, husbandman 4
4991055 2354215 2354215 plaintiff Clerk Robert   591835 591835 Clerk, Robert, of Osgodby 0
4991059 2354216 2354216 plaintiff Clerk Robert   591835 591835 Clerk, Robert, of Osgodby 0
4993470 2354917 2354917 defendant Smalwode Thomas husbandman 591835 591835 Smalwode, Thomas, of Osgodby, husbandman 0
5007470 2359080 2359080 defendant Barde Robert gent 591835 591835 Barde, Robert, of Osgodby, gent 0
5007474 2359080 2359080 defendant Lorymer Richard yeoman 591835 591835 Lorymer, Richard, of Osgodby, yeoman 4
5007475 2359080 2359080 defendant Baron Richard yeoman 591835 591835 Baron, Richard, of Osgodby, yeoman 5
5007481 2359082 2359082 defendant Smalwode Thomas husbandman 591835 591835 Smalwode, Thomas, of Osgodby, husbandman 0
5020833 2362990 2362990 defendant Barde Robert gent 591835 591835 Barde, Robert, of Osgodby, gent 0
5059619 2374444 2374444 defendant Clerk Robert yeoman 591835 591835 Clerk, Robert, of Osgodby, yeoman 8
5073701 2378620 2378620 defendant Symond Robert husbandman 591835 591835 Symond, Robert, of Osgodby, husbandman 1
5076807 2379558 2379558 defendant Smyth Thomas yeoman 591835 591835 Smyth, Thomas, of Osgodby, yeoman 2
5083193 2381470 2381470 defendant Clerk Robert yeoman 591835 591835 Clerk, Robert, of Osgodby, yeoman 10
5115530 2390969 2390969 defendant Chapman John husbandman 591835 591835 Chapman, John, of Osgodby, husbandman 0
5132229 2395922 2395922 defendant Hanson John husbandman 591835 591835 Hanson, John, of Osgodby, husbandman 2
5132230 2395922 2395922 defendant Blounte Thomas husbandman 591835 591835 Blounte, Thomas, of Osgodby, husbandman 3
5219832 2421520 2421520 defendant Emlyn Robert laborer 591835 591835 Emlyn, Robert, of Osgodby, laborer 11
5219852 2421521 2421521 defendant Emlyn Robert laborer 591835 591835 Emlyn, Robert, of Osgodby, laborer 11
5571401 2526189 2526189 defendant Barehed William husbandman 591835 591835 Barehed, William, of Osgodby, husbandman 4
5573592 2526841 2526841 defendant Stamp John yeoman 591835 591835 Stamp, John, of Osgodby, yeoman 0
5579077 2528527 2528527 defendant Nycoll John laborer 591835 591835 Nycoll, John, of Osgodby, laborer 3
5579080 2528528 2528528 defendant Gregson Richard weaver 591835 591835 Gregson, Richard, of Osgodby, weaver 1
5637018 2555525 2555525 defendant Jonson William carpenter 591835 591835 Jonson, William, of Osgodby, carpenter 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);