names

152 rows where place_id = 592690

✎ 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
3608531 1870327 1870327 defendant Drawe John butcher 592690 592690 Drawe, John, of Shefford, butcher 0
3621735 1874336 1874336 defendant Shyrwode Thomas mercer 592690 592690 Shyrwode, Thomas, of Shefford, mercer 1
3621738 1874337 1874337 defendant Shyrwode Thomas mercer 592690 592690 Shyrwode, Thomas, of Shefford, mercer 1
3630932 1904494 1904494 defendant Nyxson Thomas tailor 592690 592690 Nyxson, Thomas, of Shefford, tailor 0
3669892 1916528 1916528 defendant Trust Thomas gent 592690 592690 Trust, Thomas, of Shefford, gent 0
3685020 1921456 1921456 defendant Davy Mathew yeoman 592690 592690 (Davy, Mathew, of Shefford, yeoman 1
3696922 1925257 1925257 defendant Tryste Thomas gent 592690 592690 Tryste, Thomas, of Shefford, gent 1
3744329 1940126 1940126 defendant Gwylbon William pulter 592690 592690 Gwylbon, William, of Shefford, pulter 0
3754984 1943506 1943506 defendant Byrt Thomas husbandman 592690 592690 Byrt, Thomas, of Shefford, husbandman 0
3764164 1946442 1946442 defendant Byrt John husbandman 592690 592690 Byrt, John, of Shefford, husbandman 0
3764167 1946443 1946443 defendant Byrt John husbandman 592690 592690 Byrt, John, of Shefford, husbandman 1
3795175 1956357 1956357 defendant Bonam William baker 592690 592690 Bonam, William, of Shefford, baker 0
3841606 1970959 1970959 defendant Verdewe John tailor 592690 592690 Verdewe, John, of Shefford, tailor 0
3841611 1970960 1970960 defendant Verdewe John tailor 592690 592690 Verdewe, John, of Shefford, tailor 0
3976167 2016231 2016231 defendant Cotton John gent 592690 592690 Cotton, John, of Shefford, gent 0
4060482 2046153 2046153 plaintiff Davies Kinnericus clerk 592690 592690 Davies, Kinnericus, of Shefford, clerk 0
4081532 2053705 2053705 plaintiff Wilcock Henry esq 592690 592690 Wilcock, Henry, of Shefford, esq 0
4214428 2100553 2100553 defendant Thedye Thomas husbandman 592690 592690 Thedye, Thomas, of Shefford, husbandman 0
4214430 2100554 2100554 defendant Thodye Thomas husbandman 592690 592690 Thodye, Thomas, of Shefford, husbandman 0
4217970 2101779 2101779 defendant Monke William chapman 592690 592690 Monke, William, of Shefford, or of Hitchen, Herts, chapman 0
4345033 2145537 2145537 defendant Price John yeoman 592690 592690 Price, John, of Shefford, yeoman 0
4382930 2159003 2159003 defendant Williamson or Willison George glover 592690 592690 Williamson or Willison, George, of Shefford, glover 0
4396429 2163381 2163381 defendant Pryce John yeoman 592690 592690 Pryce, John, of Shefford, yeoman 0
4468074 2190685 2190685 defendant Fullere John   592690 592690 Fullere, John, of Shefford 0
4497777 2199949 2199949 defendant Busteler Cecilia   592690 592690 Busteler, Cecilia, of Shefford 0
4503262 2201586 2201586 plaintiff Parker John   592690 592690 Parker, John, of Shefford 0
4506868 2202617 2202617 defendant Cook John butcher 592690 592690 Cook, John, of Shefford, butcher 0
4520462 2206745 2206745 plaintiff Fitz John   592690 592690 Fitz, John, of Shefford 0
4520464 2206746 2206746 plaintiff Fitz John   592690 592690 Fitz, John, of Shefford 0
4542849 2213653 2213653 defendant Bakere John   592690 592690 Bakere, John, of Shefford 0
4575003 2223703 2223703 defendant Rope William   592690 592690 Rope, William, of Shefford 1
4575004 2223704 2223704 plaintiff Bocher William   592690 592690 Bocher, William, of Shefford 0
4582418 2225942 2225942 defendant Dycon John   592690 592690 Dycon, John, of Shefford 2
4583679 2226310 2226310 defendant Bother Richard   592690 592690 Bother, Richard, of Shefford 0
4597873 2230591 2230591 defendant Bocher Richard   592690 592690 Bocher, Richard, of Shefford 1
4644186 2244394 2244394 plaintiff Lounde Thomas   592690 592690 Lounde, Thomas, of Shefford 0
4653305 2246974 2246974 plaintiff Lounde Thomas   592690 592690 Lounde, Thomas, of Shefford 1
4665142 2250580 2250580 plaintiff Hert William   592690 592690 Hert, William, of Shefford 0
4665145 2250581 2250581 plaintiff Hert William   592690 592690 Hert, William, of Shefford 0
4690390 2262552 2262552 defendant Lounde Thomas gent 592690 592690 Lounde, Thomas, of Shefford, gent 2
4700318 2265516 2265516 defendant Bocher Richard butcher 592690 592690 Bocher, Richard, of Shefford, butcher 1
4706289 2267348 2267348 plaintiff Lounde Thomas   592690 592690 Lounde, Thomas, of Shefford 0
4706291 2267349 2267349 plaintiff Lounde Thomas   592690 592690 Lounde, Thomas, of Shefford 0
4707824 2267816 2267816 defendant Cobeham Reginald esq 592690 592690 Cobeham, Reginald, of Shefford, esq 0
4720462 2271735 2271735 defendant Taillour John tailor 592690 592690 Taillour, John, of Shefford, tailor 0
4723943 2272788 2272788 defendant Brewer William yeoman 592690 592690 Brewer, William, of Shefford, yeoman 1
4724932 2273090 2273090 defendant Bocher Richard butcher 592690 592690 Bocher, Richard, of Shefford, butcher 0
4746516 2279473 2279473 defendant Hert William   592690 592690 Hert, William, of Shefford 0
4747482 2279769 2279769 defendant Gamelyngey Richard yeoman 592690 592690 Gamelyngey, Richard, of Shefford, yeoman 0
4763198 2284476 2284476 defendant Wether John yeoman 592690 592690 Wether, John, of Shefford, yeoman 1
4767355 2285777 2285777 defendant Deye William husbandman 592690 592690 Deye, William, of Shefford, husbandman 0
4774867 2288133 2288133 defendant Brewere William yeoman 592690 592690 Brewere, William, of Shefford, yeoman 0
4779737 2289655 2289655 defendant Kent Lawrence laborer 592690 592690 Kent, Lawrence, of Shefford, laborer 1
4782136 2290414 2290414 plaintiff Lounde Thomas   592690 592690 Lounde, Thomas, of Shefford 1
4791752 2293518 2293518 defendant Deye William husbandman 592690 592690 Deye, William, of Shefford, husbandman 0
4806315 2298185 2298185 defendant Deye William baker 592690 592690 Deye, William, of Shefford, baker 0
4812003 2299868 2299868 plaintiff Payne Thomas   592690 592690 Payne, Thomas, of Shefford 1
4812004 2299868 2299868 defendant Raundys Joan widow 592690 592690 Raundys, Joan, of Shefford, widow 0
4813970 2300480 2300480 defendant Brewer William   592690 592690 Brewer, William, of Shefford, bailiff 0
4830300 2305515 2305515 defendant Person John butcher 592690 592690 Person, John, of Shefford, butcher 0
4832617 2306224 2306224 defendant Verdon Nicholas yeoman 592690 592690 Verdon, Nicholas, of Shefford, yeoman 0
4837753 2307740 2307740 defendant Pridde Henry miller 592690 592690 Pridde, Henry, of Shefford, miller 0
4851903 2312030 2312030 defendant Aylmar Thomas tanner 592690 592690 Aylmar, Thomas, of Shefford, tanner 0
4851904 2312030 2312030 defendant Aylmar John tanner 592690 592690 Aylmar, John, of Shefford, tanner 1
4851982 2312053 2312053 defendant Merston Richard gent 592690 592690 Merston, Richard, of Shefford, gent 0
4853255 2312435 2312435 defendant Blanchard William   592690 592690 Blanchard, William, of Shefford, shoe maker 2
4853669 2312563 2312563 defendant Henle William husbandman 592690 592690 Henle, William, of Shefford, husbandman 4
4857152 2313621 2313621 defendant Person John butcher 592690 592690 Person, John, of Shefford, butcher 0
4859448 2314332 2314332 defendant Verdon Nicholas yeoman 592690 592690 Verdon, Nicholas, of Shefford, yeoman 0
4862054 2315143 2315143 defendant Barbour John barber 592690 592690 Barbour, John, of Shefford, barber 0
4862055 2315143 2315143 defendant Mayehewe John yeoman 592690 592690 Mayehewe, John, of Shefford, yeoman 1
4862056 2315143 2315143 defendant Sherman Robert barker 592690 592690 Sherman, Robert, of Shefford, barker 2
4862057 2315143 2315143 defendant Oxenford Robert skinner 592690 592690 Oxenford, Robert, of Shefford, skinner 3
4862060 2315143 2315143 defendant Couper William husbandman 592690 592690 Couper, William, of Shefford, husbandman 6
4864970 2316019 2316019 defendant Prudde Henry miller 592690 592690 Prudde, Henry, of Shefford, miller 0
4870142 2317629 2317629 plaintiff Lound Thomas   592690 592690 Lound, Thomas, of Shefford 0
4870152 2317633 2317633 defendant Verdon Nicholas   592690 592690 Verdon, Nicholas, of Shefford, "chopchirche" 1
4884555 2322076 2322076 defendant Holygost Bartholomew husbandman 592690 592690 Holygost, Bartholomew, of Shefford, husbandman 3
4884556 2322076 2322076 defendant Roper alias Samfeld William husbandman 592690 592690 Roper alias Samfeld, William, of Shefford, husbandman 4
4907478 2328899 2328899 defendant Lounde John gent 592690 592690 Lounde, John, of Shefford, gent 2
4913187 2330621 2330621 defendant Prudde Henry miller 592690 592690 Prudde, Henry, of Shefford, miller 1
4924339 2334049 2334049 defendant Merston Richard gent 592690 592690 Merston, Richard, of Shefford, gent 0
4941360 2339323 2339323 defendant Merston Richard gent 592690 592690 Merston, Richard, of Shefford, gent 0
4963660 2346042 2346042 defendant Bere William chandler 592690 592690 Bere, William, of Shefford, chandler 1
4973588 2349054 2349054 plaintiff Lounde Walter   592690 592690 Lounde, Walter, of Shefford 0
4988856 2353618 2353618 defendant Berewell John shoemaker 592690 592690 Berewell, John, of Shefford, shoemaker 3
5000063 2356904 2356904 plaintiff Lound John   592690 592690 Lound, John, of Shefford 0
5000065 2356904 2356904 defendant Aylmere John tanner 592690 592690 Aylmere, John, of Shefford, tanner 1
5000067 2356904 2356904 defendant Whitbrede William   592690 592690 Whitbrede, William, of Shefford, mason 3
5033235 2366602 2366602 defendant Lounde Walter gent 592690 592690 Lounde, Walter, of Shefford, gent 0
5041224 2368981 2368981 defendant Lounde Walter gent 592690 592690 Lounde, Walter, of Shefford, gent 0
5041226 2368982 2368982 defendant Lounde Walter gent 592690 592690 Lounde, Walter, of Shefford, gent 0
5092788 2384270 2384270 plaintiff Person Emma (legal representative) 592690 592690 Person, Emma, of Shefford, widow, executor of 0
5092790 2384270 2384270 defendant Valentyne John smith 592690 592690 Valentyne, John, of Shefford, smith 0
5092791 2384270 2384270 defendant May William smith 592690 592690 May, William, of Shefford, smith 1
5114175 2390545 2390545 defendant Vyncent Richard husbandman 592690 592690 Vyncent, Richard, of Shefford, husbandman 0
5114176 2390545 2390545 defendant Knottesford William tailor 592690 592690 Knottesford, William, of Shefford, tailor 1
5114178 2390545 2390545 defendant Rogger William miller 592690 592690 Rogger, William,of Shefford, miller 3
5167257 2406155 2406155 defendant Roper John husbandman 592690 592690 Roper, John, of Shefford, husbandman 0
5180749 2410109 2410109 defendant Forst Richard husbandman 592690 592690 Forst, Richard, of Shefford, husbandman 0

Next page

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);