names

86 rows where place_id = 593512

✎ 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
3612174 1871452 1871452 defendant Houghton John carpenter 593512 593512 Houghton, John, of Kempston, carpenter 1
3631852 1904771 1904771 defendant Gosse John husbandman 593512 593512 Gosse, John, of Kempston, husbandman 1
3651176 1910735 1910735 defendant Game William yeoman 593512 593512 Game, William, of Kempston, yeoman 0
3651177 1910735 1910735 defendant Game Henry husbandman 593512 593512 Game, Henry, of Kempston, husbandman 1
3651178 1910735 1910735 defendant Swayne John laborer 593512 593512 Swayne, John, of Kempston, laborer 2
3651179 1910735 1910735 defendant Swayne William laborer 593512 593512 Swayne, William, of Kempston, laborer 3
3651180 1910735 1910735 defendant Francys Henry laborer 593512 593512 Francys, Henry, of Kempston, laborer 4
3770655 1948507 1948507 plaintiff Smyth William   593512 593512 Smyth, William, of Kempston 0
3770659 1948508 1948508 plaintiff Smyth William   593512 593512 Smyth, William, of Kempston 0
3835944 1969156 1969156 defendant Grey Reginald (legal representative) 593512 593512 Grey, Reginald, of Kempston, esq, executrix of 0
3946792 2005947 2005947 defendant Broun Henry husbandman 593512 593512 Broun, Henry, of Kempston, husbandman 2
3985016 2019399 2019399 defendant Claxton Edward yeoman 593512 593512 Claxton, Edward, of Kempston, yeoman 0
4223024 2103543 2103543 defendant Stokes Thomas husbandman 593512 593512 Stokes, Thomas, of Kempston, husbandman 0
4353032 2148290 2148290 defendant Harvy Thomas, senior yeoman 593512 593512 Harvy, Thomas, senior, of Kempston, yeoman 0
4353033 2148290 2148290 defendant Harvy Thomas, junior yeoman 593512 593512 Harvy, Thomas, junior, of Kempston, yeoman 1
4357573 2149878 2149878 defendant Harvey Thomas yeoman 593512 593512 Harvey, Thomas, of Kempston, yeoman 0
4438490 2181326 2181326 defendant Mayhu William   593512 593512 Mayhu, William, of Kempston 0
4438910 2181464 2181464 defendant Palle John   593512 593512 Palle, John, of Kempston 0
4452887 2185911 2185911 defendant Philip John   593512 593512 Philip, John, of Kempston, millward 0
4461948 2188795 2188795 defendant Cok Thomas   593512 593512 Cok, Thomas, of Kempston 0
4481658 2194960 2194960 defendant Clerk John   593512 593512 Clerk, John, of Kempston 0
4497781 2199949 2199949 defendant Maynard Hugh   593512 593512 Maynard, Hugh, of Kempston 4
4507000 2202658 2202658 defendant Rycher John bowmaker 593512 593512 Rycher, John, of Kempston, bowmaker 0
4526024 2208436 2208436 defendant Barton John   593512 593512 Barton, John, of Kempston 3
4548758 2215550 2215550 plaintiff Clog Thomas (legal representative) 593512 593512 Clog, Thomas, of Kempston, chaplain, executors of 0
4559359 2218879 2218879 defendant Clerk John   593512 593512 Clerk, John, of Kempston 0
4568811 2221830 2221830 defendant Cretyng Thomas   593512 593512 Cretyng, Thomas, of Kempston 0
4626911 2239362 2239362 defendant Cok Thomas   593512 593512 Cok, Thomas, of Kempston 0
4644816 2244550 2244550 defendant Osbot Richard carpenter 593512 593512 Osbot, Richard, of Kempston, carpenter 1
4652173 2246618 2246618 defendant Taillour John tailor 593512 593512 Taillour, John, of Kempston, tailor 0
4671343 2256688 2256688 defendant Bury John husbandman 593512 593512 Bury, John, of Kempston, husbandman 0
4691910 2263006 2263006 defendant atte borne William husbandman 593512 593512 atte borne, William, of Kempston, husbandman 2
4692610 2263206 2263206 plaintiff atte Okes John   593512 593512 atte Okes, John, of Kempston 0
4692611 2263206 2263206 defendant Rovell Nicholas   593512 593512 Rovell, Nicholas, of Kempston, wright 0
4692613 2263207 2263207 plaintiff atte Okes Robert   593512 593512 atte Okes, Robert, of Kempston 0
4692614 2263207 2263207 defendant Swayn John   593512 593512 Swayn, John, of Kempston, wright 0
4732860 2275452 2275452 defendant Cok John husbandman 593512 593512 Cok, John, of Kempston, husbandman 1
4741392 2277980 2277980 defendant Baa John husbandman 593512 593512 Baa, John, of Kempston, husbandman 2
4741393 2277980 2277980 defendant Baa Joan widow 593512 593512 Baa, Joan, of Kempston, widow 3
4745298 2279137 2279137 defendant Coke Thomas husbandman 593512 593512 Coke, Thomas, of Kempston, husbandman 0
4752620 2281227 2281227 defendant Smyth Henry yeoman 593512 593512 Smyth, Henry, of Kempston, yeoman 0
4775562 2288350 2288350 defendant Dyfford William   593512 593512 Dyfford, William, of Kempston, bailiff 0
4809409 2299119 2299119 defendant Cok John husbandman 593512 593512 Cok, John, of Kempston, husbandman 0
4811405 2299676 2299676 defendant Cok John husbandman 593512 593512 Cok, John, of Kempston, husbandman 0
4814264 2300566 2300566 defendant Hervy William husbandman 593512 593512 Hervy, William, of Kempston, husbandman 0
4818168 2301758 2301758 defendant Goos Lawrence miller 593512 593512 Goos, Lawrence, of Kempston, miller 0
4825495 2304017 2304017 defendant Hunte William chapman 593512 593512 Hunte, William, of Kempston, chapman 4
4832620 2306224 2306224 defendant Newold John husbandman 593512 593512 Newold, John, of Kempston, husbandman 3
4832622 2306225 2306225 plaintiff Carlton John   593512 593512 Carlton, John, of Kempston 0
4832623 2306225 2306225 defendant Newold Richard   593512 593512 Newold, Richard, of Kempston, holy water clerk 0
4832624 2306225 2306225 defendant Revell Nicholas carpenter 593512 593512 Revell, Nicholas, of Kempston, carpenter 1
4835718 2307168 2307168 defendant Cok John husbandman 593512 593512 Cok, John, of Kempston, husbandman 0
4859456 2314334 2314334 plaintiff Carlton John   593512 593512 Carlton, John, of Kempston 0
4859457 2314334 2314334 defendant Newold Richard   593512 593512 Newold, Richard, of Kempston, holy water clerk 0
4894949 2325083 2325083 defendant Bodard Bartholomew husbandman 593512 593512 Bodard, Bartholomew, of Kempston, husbandman 1
4894953 2325084 2325084 defendant Athelard Richard   593512 593512 Athelard, Richard, of Kempston, bailiff 2
4905270 2328242 2328242 defendant Rovell or Ronell Nicholas carpenter 593512 593512 Rovell or Ronell, Nicholas, of Kempston, carpenter 1
4905272 2328242 2328242 defendant Dysseford John husbandman 593512 593512 Dysseford, John, of Kempston, husbandman 3
4946266 2340820 2340820 defendant Swayn John   593512 593512 Swayn, John, of Kempston, holy water clerk 0
4946267 2340820 2340820 defendant Swayn Ellen widow 593512 593512 Swayn, Ellen, of Kempston, widow 1
5002188 2357545 2357545 defendant Neuwold Thomas husbandman 593512 593512 Neuwold, Thomas, of Kempston, husbandman 0
5107941 2388762 2388762 defendant Hervy William yeoman 593512 593512 Hervy, William, of Kempston, yeoman 0
5137376 2397444 2397444 defendant Basse Robert pedder 593512 593512 Basse, Robert, of Kempston, pedder 0
5151163 2401482 2401482 defendant Hunte Richard husbandman 593512 593512 Hunte, Richard, of Kempston, husbandman 0
5199659 2415644 2415644 defendant Hervy William husbandman 593512 593512 Hervy, William, of Kempston, husbandman 0
5211190 2419000 2419000 defendant Hervy William husbandman 593512 593512 Hervy, William, of Kempston, husbandman 0
5214096 2419849 2419849 defendant Newold John yeoman 593512 593512 Newold, John, of Kempston, yeoman 4
5214149 2419864 2419864 defendant Amse or Anise or Avise Hugh husbandman 593512 593512 Amse or Anise or Avise, Hugh, of Kempston, husbandman 1
5232257 2425011 2425011 defendant Newold John yeoman 593512 593512 Newold, John, of Kempston, yeoman 0
5232284 2425020 2425020 plaintiff Gent Thomas   593512 593512 Gent, Thomas, of Kempston 1
5321950 2451634 2451634 defendant Maynard Richard husbandman 593512 593512 Maynard, Richard, of Kempston, husbandman 0
5321951 2451634 2451634 defendant Sandon Simon husbandman 593512 593512 Sandon, Simon, of Kempston, husbandman 1
5321953 2451634 2451634 defendant Wyse William husbandman 593512 593512 Wyse, William, of Kempston, husbandman 3
5321954 2451634 2451634 defendant Glover William husbandman 593512 593512 Glover, William, of Kempston, husbandman 4
5321955 2451634 2451634 defendant Abbot Henry husbandman 593512 593512 Abbot, Henry, of Kempston, husbandman 5
5321956 2451634 2451634 defendant Gonell or Govell Richard husbandman 593512 593512 Gonell or Govell, Richard, of Kempston, husbandman 6
5387210 2471413 2471413 defendant Coke John yeoman 593512 593512 Coke, John, of Kempston, yeoman 1
5395145 2473678 2473678 defendant B-- John yeoman 593512 593512 B--, John, of Kempston, yeoman 1
5412664 2478735 2478735 defendant Cokes John yeoman 593512 593512 Cokes, John, of Kempston, yeoman 1
5423916 2482106 2482106 defendant Cokkys Thomas tailor 593512 593512 Cokkys, Thomas, of Kempston, tailor 0
5427539 2483188 2483188 defendant Cok Thomas yeoman 593512 593512 Cok, Thomas, of Kempston, yeoman 0
5443019 2487820 2487820 defendant Cokkys Thomas tailor 593512 593512 Cokkys, Thomas, of Kempston, tailor 0
5455739 2491617 2491617 defendant Cokkys Thomas tailor 593512 593512 Cokkys, Thomas, of Kempston, tailor 0
5500468 2505080 2505080 defendant Cok Thomas yeoman 593512 593512 Cok, Thomas, of Kempston, yeoman 2
5616779 2549052 2549052 defendant Clog Thomas   593512 593512 Clog, Thomas, of Kempston 0
5621442 2550603 2550603 defendant Cok Thomas   593512 593512 Cok, Thomas, of Kempston 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);