names

70 rows where place_id = 610998

✎ 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
3686212 1921851 1921851 plaintiff Bounce Thomas   610998 610998 Bounce, Thomas, of Thame, Oxon 0
3690737 1923269 1923269 defendant Parker John clerk 610998 610998 Parker, John, of Thame, Oxon, clerk 1
3690747 1923271 1923271 defendant Parker John clerk 610998 610998 Parker, John, of Thame, Oxon, clerk 1
3758296 1944590 1944590 defendant Blakegrove Richard husbandman 610998 610998 Blakegrove, Richard, of Thame, Oxon, husbandman 0
3859326 1976611 1976611 defendant Kenner John husbandman 610998 610998 Kenner, John, of Thame, Oxon, husbandman 0
3859329 1976612 1976612 defendant Kenner John husbandman 610998 610998 Kenner, John, of Thame, Oxon, husbandman 0
3926726 1999272 1999272 defendant Wey William innholder 610998 610998 Wey, William, of Thame, Oxon, innholder 0
3939323 2003458 2003458 defendant Medcalfe Abraham chapman 610998 610998 Medcalfe, Abraham, of Thame, Oxon, chapman 0
3943357 2004795 2004795 plaintiff Andfeld Thomas chandler 610998 610998 Andfeld, Thomas, of Thame, Oxon, chandler 0
3968519 2013622 2013622 defendant Symyon Thomas draper 610998 610998 Symyon, Thomas, of Thame, Oxon, draper 0
4016507 2030610 2030610 plaintiff Stribehill Thomas yeoman 610998 610998 Stribehill, Thomas, of Thame, Oxon, yeoman 0
4016510 2030611 2030611 plaintiff Stribelhill Thomas yeoman 610998 610998 Stribelhill, Thomas, of Thame, Oxon, yeoman 0
4091110 2057107 2057107 defendant Dormer Michael esq 610998 610998 Dormer, Michael, of Thame, Oxon, gent, son of William Dormer, esq 0
4167150 2084016 2084016 defendant Pyttman Nicholas chapman 610998 610998 Pyttman, Nicholas, of Thame, Oxon, chapman 1
4192928 2093091 2093091 defendant Kendall Christopher gent 610998 610998 Kendall, Christopher, of Thame, Oxon, gent 0
4248974 2112643 2112643 defendant Pitman Nicholas chapman 610998 610998 Pitman, Nicholas, of Thame, Oxon, chapman 0
4248993 2112648 2112648 defendant Pitman Nicholas chapman 610998 610998 Pitman, Nicholas, of Thame, Oxon, chapman 1
4258203 2115716 2115716 defendant Wolman Francis yeoman or gent 610998 610998 Wolman, Francis, of Thame, Oxon, yeoman or gent 0
4266386 2118401 2118401 defendant Yeate Leonard smith 610998 610998 Yeate, Leonard, of Thame, Oxon, smith 0
4519841 2206557 2206557 defendant Stokes John   610998 610998 (Stokes, John, of Thame, Oxon 3
4545965 2214674 2214674 defendant atte Mor_ Richard   610998 610998 atte Mor_, Richard, of Thame, Oxon 0
4623888 2238451 2238451 plaintiff Moode Richard   610998 610998 Moode, Richard, of Thame, Oxon 0
4637489 2242515 2242515 defendant Bryghtwell Agnes   610998 610998 Bryghtwell, Agnes, of Thame, Oxon 0
4642593 2243952 2243952 defendant Grene John   610998 610998 Grene, John, of Thame, Oxon 2
4657003 2248081 2248081 defendant Bolour John husbandman 610998 610998 Bolour, John, of Thame, Oxon, husbandman 0
4671848 2256838 2256838 defendant Tybard John ironmonger 610998 610998 Tybard, John, of Thame, Oxon, ironmonger 2
4672083 2256917 2256917 defendant Bolour John husbandman 610998 610998 Bolour, John, of Thame, Oxon, husbandman 0
4672089 2256918 2256918 defendant Bolour John, senior husbandman 610998 610998 Bolour, John, senior, of Thame, Oxon, husbandman 0
4680466 2259504 2259504 defendant Godman William husbandman 610998 610998 Godman, William, of Thame, Oxon, husbandman 0
4691992 2263030 2263030 defendant Marchall Joan widow 610998 610998 Marchall, Joan, of Thame, Oxon, widow 1
4721060 2271922 2271922 defendant Palmer William shoemaker 610998 610998 Palmer, William, of Thame, Oxon, shoemaker 0
4732612 2275376 2275376 defendant Palmer William yeoman 610998 610998 Palmer, William, of Thame, Oxon, yeoman 0
4733093 2275528 2275528 defendant Jaket John   610998 610998 Jaket, John, of Thame, Oxon, bailiff 0
4733096 2275529 2275529 defendant Jaket John   610998 610998 Jaket, John, of Thame, Oxon, bailiff 0
4765992 2285355 2285355 defendant Palmer William chapman 610998 610998 Palmer, William, of Thame, Oxon, chapman 0
4778488 2289250 2289250 defendant Longe Thomas courser 610998 610998 Longe, Thomas, of Thame, Oxon, courser 0
4792445 2293722 2293722 defendant Hosyer Richard draper 610998 610998 Hosyer, Richard, of Thame, Oxon, draper 0
4802560 2296988 2296988 defendant Mustell William husbandman 610998 610998 Mustell, William, of Thame, Oxon, husbandman 2
4810220 2299341 2299341 defendant Freman Thomas chapman 610998 610998 Freman, Thomas, of Thame, Oxon, chapman 2
4833903 2306612 2306612 defendant Tayllour Nicholas husbandman 610998 610998 Tayllour, Nicholas, of Thame, Oxon, husbandman 2
4837533 2307674 2307674 defendant Orchard John husbandman 610998 610998 (Orchard, John, of Thame, Oxon, husbandman 3
4845132 2309990 2309990 defendant Harpham Thomas chapman 610998 610998 Harpham, Thomas, of Thame, Oxon, chapman 0
4845136 2309992 2309992 defendant Harpham Thomas chapman 610998 610998 Harpham, Thomas, of Thame, Oxon, chapman 0
4855700 2313154 2313154 defendant Turnepace Thomas chandler 610998 610998 Turnepace, Thomas, of Thame, Oxon, chandler 0
4855702 2313155 2313155 defendant Turnepate Thomas chandler 610998 610998 Turnepate, Thomas, of Thame, Oxon, chandler 0
4860476 2314638 2314638 defendant Peyntour John husbandman 610998 610998 Peyntour, John, of Thame, Oxon, husbandman 2
4883472 2321748 2321748 defendant Welles Thomas yeoman 610998 610998 Welles, Thomas, of Thame, Oxon, yeoman 2
4889585 2323539 2323539 defendant Baudewyn John yeoman 610998 610998 Baudewyn, John, of Thame, Oxon, yeoman 2
4901973 2327220 2327220 defendant Peyntour Henry painter 610998 610998 Peyntour, Henry, of Thame, Oxon, painter 0
4926434 2334686 2334686 defendant Jaket John yeoman 610998 610998 Jaket, John, of Thame, Oxon, yeoman 0
4932087 2336429 2336429 defendant Felde Thomas tailor 610998 610998 Felde, Thomas, of Thame, Oxon, tailor 0
4949203 2341738 2341738 defendant Bisshop William   610998 610998 Bisshop, William, of Thame, Oxon, plough maker 2
4949210 2341739 2341739 defendant Bisshop William ploughmaker 610998 610998 Bisshop, William, of Thame, Oxon, ploughmaker 3
4987717 2353291 2353291 defendant Lucy William husbandman 610998 610998 Lucy, William, of Thame, Oxon, husbandman 2
5072211 2378177 2378177 defendant Benet John chapman 610998 610998 Benet, John, of Thame, Oxon, chapman 3
5085214 2382076 2382076 defendant Carles Richard tailor 610998 610998 Carles, Richard, of Thame, Oxon, tailor 1
5099606 2386321 2386321 defendant Pydyngton Richard yeoman 610998 610998 Pydyngton, Richard, of Thame, Oxon, yeoman 2
5134857 2396696 2396696 defendant Bates John gent 610998 610998 Bates, John, of Thame, Oxon, gent 1
5180063 2409905 2409905 defendant Lyndesey Richard   610998 610998 Lyndesey, Richard, of Thame, Oxon, abbot of the monastery of the BVM 1
5221054 2421861 2421861 defendant Bates Thomas gent 610998 610998 Bates, Thomas, of Thame, Oxon, gent 0
5236739 2426330 2426330 defendant Dene John cordwainer 610998 610998 Dene, John, of Thame, Oxon, cordwainer 2
5249240 2429897 2429897 defendant Benet John chapman 610998 610998 Benet, John, of Thame, Oxon, chapman 0
5269477 2436172 2436172 defendant Batys alias Bates John gent 610998 610998 Batys alias Bates, John, of Thame, Oxon, gent 0
5323057 2451976 2451976 defendant Bates John gent 610998 610998 Bates, John, of Thame, Oxon, gent 1
5420897 2481178 2481178 defendant Bates Thomas gent 610998 610998 Bates, Thomas, of Thame, Oxon, gent 0
5439986 2486902 2486902 defendant Bates Thomas gent 610998 610998 Bates, Thomas, of Thame, Oxon, gent 0
5553676 2521111 2521111 defendant Lukenor William chapman 610998 610998 Lukenor, William, of Thame, Oxon, chapman 2
5555897 2521718 2521718 defendant de Bardys Adrian clerk 610998 610998 de Bardys, Adrian, of Thame, Oxon, clerk 0
5558505 2522436 2522436 defendant Wodbryge William cordwainer 610998 610998 Wodbryge, William, of Thame, Oxon, cordwainer 0
5626501 2552261 2552261 plaintiff More Richard   610998 610998 More, Richard, of Thame, Oxon 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);