names

83 rows where place_id = 589071

✎ 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
3596419 1866509 1866509 defendant Asper Thomas husbandman 589071 589071 Asper, Thomas, of Bykeleswade, husbandman 2
3596420 1866509 1866509 defendant Graunt John yeoman 589071 589071 Graunt, John, of Bykeleswade, yeoman 3
3686345 1921888 1921888 defendant Radwell John yeoman 589071 589071 Radwell, John, of Bykeleswade, yeoman 0
3686347 1921888 1921888 defendant Whitlock John glover 589071 589071 Whitlock, John, of Bykeleswade, glover 2
3686349 1921888 1921888 defendant Pekke John yeoman 589071 589071 (Pekke, John, of Bykeleswade, yeoman 4
3699100 1925926 1925926 defendant Grymmesby alias Fuller John glover 589071 589071 Grymmesby alias Fuller, John, of Bykeleswade, glover 0
4494686 2199032 2199032 defendant Bere Stephen   589071 589071 Bere, Stephen, of Bykeleswade 0
4497519 2199867 2199867 defendant Bere Stephen   589071 589071 Bere, Stephen, of Bykeleswade 0
4505346 2202201 2202201 defendant Bere Stephen   589071 589071 Bere, Stephen, of Bykeleswade 0
4522951 2207509 2207509 defendant Bere Stephen spicer 589071 589071 Bere, Stephen, of Bykeleswade, spicer 1
4581010 2225540 2225540 defendant Wyse John   589071 589071 Wyse, John, of Bykeleswade 0
4586838 2227283 2227283 defendant Derby John   589071 589071 Derby, John, of Bykeleswade 0
4586840 2227283 2227283 defendant Lincoln John   589071 589071 together with Lincoln, John, of Bykeleswade 2
4586842 2227284 2227284 defendant Lyncoln John   589071 589071 Lyncoln, John, of Bykeleswade 0
4586843 2227284 2227284 defendant Derby John   589071 589071 together with Derby, John, of Bykeleswade 1
4586844 2227284 2227284 defendant Lincoln John   589071 589071 Lincoln, John, of Bykeleswade, formerly servant of John Lincoln 2
4590076 2228259 2228259 plaintiff Lyncolne John   589071 589071 Lyncolne, John, of Bykeleswade 0
4597749 2230547 2230547 defendant Smyth Simon   589071 589071 Smyth, Simon, of Bykeleswade 0
4614665 2235599 2235599 defendant Sutton John   589071 589071 Sutton, John, of Bykeleswade 0
4628850 2239953 2239953 defendant Manypeny Thomas   589071 589071 Manypeny, Thomas, of bykeleswade 2
4641835 2243714 2243714 plaintiff Glover John   589071 589071 Glover, John, of Bykeleswade 0
4645379 2244719 2244719 defendant Ropere Nicholas   589071 589071 Ropere, Nicholas, of Bykeleswade 2
4645380 2244719 2244719 defendant (illegible) John   589071 589071 _, John, of Bykeleswade 3
4661599 2249463 2249463 defendant Langford Henry   589071 589071 Langford, Henry, of Bykeleswade 0
4669194 2256070 2256070 defendant Hamond John butcher 589071 589071 Hamond, John, of Bykeleswade, butcher 0
4682219 2260060 2260060 defendant Hawe John btcher 589071 589071 Hawe, John, of Bykeleswade, btcher 0
4686581 2261412 2261412 defendant Keron John glover 589071 589071 Keron, John, of Bykeleswade, glover 1
4718373 2271086 2271086 plaintiff Baker Thomas   589071 589071 Baker, Thomas, of Bykeleswade 0
4719015 2271294 2271294 defendant Taverner Roger yeoman 589071 589071 Taverner, Roger, of Bykeleswade, yeoman 1
4726015 2273424 2273424 plaintiff Goos John   589071 589071 Goos, John, of Bykeleswade 0
4726016 2273424 2273424 defendant Baker Robert baker 589071 589071 Baker, Robert, of Bykeleswade, baker 0
4726020 2273424 2273424 defendant Buntyng John husbandman 589071 589071 Buntyng, John, of Bykeleswade, husbandman 4
4735325 2276195 2276195 defendant Goldhop John tailor 589071 589071 Goldhop, John, of Bykeleswade, tailor 0
4783114 2290735 2290735 defendant Heron John glover 589071 589071 Heron, John, of Bykeleswade, glover 2
4785195 2291386 2291386 defendant Orney William cordwainer 589071 589071 Orney, William, of Bykeleswade, cordwainer 0
4788667 2292510 2292510 defendant Taverner Roger husbandman 589071 589071 Taverner, Roger, of Bykeleswade, husbandman 0
4797490 2295386 2295386 defendant Wryght John laborer 589071 589071 Wryght, John, of Bykeleswade, laborer 0
4804435 2297571 2297571 defendant Derlyng William husbandman 589071 589071 Derlyng, William, of Bykeleswade, husbandman 0
4818302 2301804 2301804 defendant Baker Robert baker 589071 589071 Baker, Robert, of Bykeleswade, baker 0
4860083 2314523 2314523 defendant Chapman Thomas husbandman 589071 589071 Chapman, Thomas, of Bykeleswade, husbandman 0
4870728 2317823 2317823 plaintiff Marchall Richard   589071 589071 Marchall, Richard, of Bykeleswade 0
4877744 2320001 2320001 plaintiff Stratton Thomas   589071 589071 Stratton, Thomas, of Bykeleswade 0
4880077 2320677 2320677 defendant Chapman Thomas husbandman 589071 589071 Chapman, Thomas, of Bykeleswade, husbandman 4
4905288 2328248 2328248 defendant Cook John yeoman 589071 589071 Cook, John, of Bykeleswade, yeoman 1
4905289 2328248 2328248 defendant Dunby John brasier 589071 589071 Dunby, John, of Bykeleswade, brasier 2
4927728 2335108 2335108 defendant Sybbesson John fisher 589071 589071 Sybbesson, John, of Bykeleswade, fisher 0
4934833 2337294 2337294 defendant Stokker John husbandman 589071 589071 Stokker, John, of Bykeleswade, husbandman 1
4934834 2337294 2337294 defendant Stowthon John butcher 589071 589071 Stowthon, John, of Bykeleswade, butcher 2
4977991 2350383 2350383 defendant Jaye Thomas smith 589071 589071 Jaye, Thomas, of Bykeleswade, smith 4
5093757 2384574 2384574 plaintiff Rasyn Thomas yeoman 589071 589071 Rasyn, Thomas, of Bykeleswade, yeoman 0
5093759 2384574 2384574 defendant Knyght Thomas fuller 589071 589071 Knyght, Thomas, of Bykeleswade, fuller 1
5093760 2384574 2384574 defendant Alman John husbandman 589071 589071 Alman, John, of Bykeleswade, husbandman 2
5093766 2384574 2384574 defendant Horley Thomas husbandman 589071 589071 Horley, Thomas, of Bykeleswade, husbandman 8
5093768 2384574 2384574 defendant Pope Richard husbandman 589071 589071 Pope, Richard, of Bykeleswade, husbandman 10
5097529 2385707 2385707 defendant Broune William yeoman 589071 589071 Broune, William, of Bykeleswade, yeoman 4
5110125 2389373 2389373 defendant Jay Thomas smith 589071 589071 Jay, Thomas, of Bykeleswade, smith 1
5120103 2392318 2392318 defendant Cok John husbandman 589071 589071 Cok, John, of Bykeleswade, husbandman 0
5280861 2439474 2439474 defendant Bocher John butcher 589071 589071 Bocher, John, of Bykeleswade, butcher 0
5291647 2442564 2442564 defendant Raulyn Henry cooper 589071 589071 Raulyn, Henry, of Bykeleswade, cooper 0
5291648 2442564 2442564 defendant Johnson John cooper 589071 589071 Johnson, John, of Bykeleswade, cooper 1
5294252 2443290 2443290 defendant Pope Richard husbandman 589071 589071 Pope, Richard, of Bykeleswade, husbandman 0
5295235 2443598 2443598 defendant Adysley William weaver 589071 589071 Adysley, William, of Bykeleswade, weaver 1
5444422 2488237 2488237 defendant Kyng William yeoman 589071 589071 Kyng, William, of Bykeleswade, yeoman 0
5444423 2488237 2488237 defendant Swyfte Robert husbandman 589071 589071 Swyfte, Robert, of Bykeleswade, husbandman 1
5456672 2491918 2491918 defendant Baker Robert baker 589071 589071 Baker, Robert, of Bykeleswade, baker 4
5459131 2492627 2492627 defendant Baker Robert baker 589071 589071 Baker, Robert, of Bykeleswade, baker 3
5468525 2495526 2495526 defendant Baker Robert baker 589071 589071 Baker, Robert, of Bykeleswade, baker 4
5480161 2499050 2499050 defendant Kyng William yeoman 589071 589071 Kyng, William, of Bykeleswade, yeoman 0
5540345 2517109 2517109 defendant Treder Edward smith 589071 589071 Treder, Edward, of Bykeleswade, smith 2
5566003 2524664 2524664 defendant Pond Edward husbandman 589071 589071 Pond, Edward, of Bykeleswade, husbandman 0
5566120 2524687 2524687 defendant Lyon John husbandman 589071 589071 Lyon, John, of Bykeleswade, husbandman 0
5569176 2525538 2525538 defendant Graunte Robert husbandman 589071 589071 Graunte, Robert, of Bykeleswade, husbandman 0
5569177 2525538 2525538 defendant Wodham William husbandman 589071 589071 Wodham, William, of Bykeleswade, husbandman 1
5569179 2525538 2525538 defendant Raymount William butcher 589071 589071 Raymount, William, of Bykeleswade, butcher 3
5573746 2526887 2526887 defendant Chiboll Thomas husbandman 589071 589071 Chiboll, Thomas, of Bykeleswade, husbandman 1
5574519 2527113 2527113 defendant Fuller John glover 589071 589071 Fuller, John, of Bykeleswade, glover 0
5574520 2527113 2527113 defendant Styward John butcher 589071 589071 Styward, John, of Bykeleswade, butcher 1
5574522 2527113 2527113 defendant Grote John weaver 589071 589071 Grote, John, of Bykeleswade, weaver 3
5574523 2527113 2527113 defendant Chyvald Thomas yeoman 589071 589071 Chyvald, Thomas, of Bykeleswade, yeoman 4
5605916 2536742 2536742 defendant Juvyn John laborer 589071 589071 Juvyn, John, of Bykeleswade, laborer 1
5605917 2536742 2536742 defendant Canon Thomas husbandman 589071 589071 Canon, Thomas, of Bykeleswade, husbandman 2
5632294 2554131 2554131 defendant Dunby Robert brasier 589071 589071 Dunby, Robert, of Bykeleswade, brasier 0
5632295 2554131 2554131 defendant Holt Robert dyer 589071 589071 Holt, Robert, of Bykeleswade, dyer 1

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