names

78 rows where place_id = 586497

✎ 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
3588878 1864171 1864171 defendant Tayllour Robert husbandman 586497 586497 Tayllour, Robert, of Barston, husbandman 0
3613256 1871799 1871799 defendant Bawen or Balben Baldwin husbandman 586497 586497 Bawen or Balben, Baldwin, of Barston, husbandman 0
3623505 1874881 1874881 defendant Wyn John husbandman 586497 586497 Wyn, John, of Barston, husbandman 3
3623506 1874881 1874881 defendant Brey William tailor 586497 586497 Brey, William, of Barston, tailor 4
3660493 1913544 1913544 defendant Moger Robert husbandman 586497 586497 Moger, Robert, of Barston, husbandman 1
3660494 1913544 1913544 defendant Wigthrond Robert smith 586497 586497 Wigthrond, Robert, of Barston, smith 2
3671349 1917015 1917015 defendant Towers William husbandman 586497 586497 Towers, William, of Barston, husbandman 0
3671350 1917015 1917015 defendant Scott Andrew husbandman 586497 586497 Scott, Andrew, of Barston, husbandman 1
3675848 1918482 1918482 defendant Wethers Robert smith 586497 586497 Wethers, Robert, of Barston, smith 0
3675849 1918482 1918482 defendant Mawge Robert husbandman 586497 586497 Mawge, Robert, of Barston, husbandman 1
3686685 1921989 1921989 defendant Pacy Thomas yeoman 586497 586497 Pacy, Thomas, of Barston, yeoman 4
3691008 1923351 1923351 defendant Thorold William gent 586497 586497 Thorold, William, of Barston, gent 0
3705327 1927956 1927956 defendant Thorold William gent 586497 586497 Thorold, William, of Barston, gent 0
3712739 1930299 1930299 defendant Pacy Robert (legal representative) 586497 586497 Pacy, Robert, of Barston, husbandman, executor of 0
3712740 1930299 1930299 defendant Welby Robert husbandman 586497 586497 Welby, Robert, of Barston, husbandman 1
3713787 1930612 1930612 defendant Grook John husbandman 586497 586497 Grook, John, of Barston, husbandman 0
3722267 1933222 1933222 defendant Grey Thomas husbandman 586497 586497 Grey, Thomas, of Barston, husbandman 1
3725362 1934225 1934225 defendant Coldale Robert husbandman 586497 586497 Coldale, Robert, of Barston, husbandman 2
3729245 1935397 1935397 defendant Crocok John husbandman 586497 586497 Crocok, John, of Barston, husbandman 0
3739747 1938644 1938644 defendant Welby Robert husbandman 586497 586497 Welby, Robert, of Barston, husbandman 0
3741314 1939148 1939148 defendant Coldale Robert yeoman 586497 586497 Coldale, Robert, of Barston, yeoman 2
3751475 1942378 1942378 defendant Pypar Henry husbandman 586497 586497 Pypar, Henry, of Barston, husbandman 2
3796024 1956619 1956619 defendant Dowce Baldwin husbandman 586497 586497 Dowce, Baldwin, of Barston, husbandman 1
3796031 1956619 1956619 defendant Nytynghall William husbandman 586497 586497 Nytynghall, William, of Barston, husbandman 8
3796032 1956619 1956619 defendant Massy John husbandman 586497 586497 Massy, John, of Barston, husbandman 9
3814652 1962494 1962494 defendant Pen William husbandman 586497 586497 Pen, William, of Barston, husbandman 0
3814653 1962494 1962494 defendant Belamy William husbandman 586497 586497 Belamy, William, of Barston, husbandman 1
3814656 1962494 1962494 defendant Frodsam William husbandman 586497 586497 Frodsam, William, of Barston, husbandman 4
3912160 1994392 1994392 plaintiff Wyllyngton William esq 586497 586497 Wyllyngton, William, of Barston, esq 0
3912162 1994393 1994393 plaintiff Wyllyngton William esq 586497 586497 Wyllyngton, William, of Barston, esq 0
4023541 2033128 2033128 defendant Burbage Thomas husbandman 586497 586497 Burbage, Thomas, of Barston, husbandman 1
4023544 2033129 2033129 defendant Burbage Thomas husbandman 586497 586497 Burbage, Thomas, of Barston, husbandman 1
4100424 2060479 2060479 defendant Mondaye Nicholas clerk 586497 586497 Mondaye, Nicholas, of Barston, clerk 0
4224246 2103967 2103967 defendant Watson Christopher carpenter 586497 586497 Watson, Christopher, of Barston, carpenter 6
4275497 2121369 2121369 defendant Hatton Christopher husbandman 586497 586497 Hatton, Christopher, of Barston, husbandman 0
4275498 2121369 2121369 defendant Casemore Isabel widow 586497 586497 Casemore, Isabel, of Barston, widow 1
4284241 2124415 2124415 defendant Harryson Robert tanner 586497 586497 Harryson, Robert, of Barston, tanner 0
4284969 2124674 2124674 defendant Hatton Christopher husbandman 586497 586497 Hatton, Christopher, of Barston, husbandman 0
4284970 2124674 2124674 defendant Casemore Isabel widow 586497 586497 Casemore, Isabel, of Barston, widow 1
4310256 2133740 2133740 defendant Harrison Robert tanner 586497 586497 Harrison, Robert, of Barston, tanner 0
4310262 2133742 2133742 defendant Harrison Robert tanner 586497 586497 Harrison, Robert, of Barston, tanner 0
4374110 2155811 2155811 defendant Michell Robert butcher 586497 586497 Michell, Robert, of Barston, butcher 1
4524680 2208055 2208055 defendant Mere William   586497 586497 Mere, William, of Barston 0
4566488 2221086 2221086 defendant Basset Hugh   586497 586497 Basset, Hugh, of Barston 2
4623762 2238408 2238408 defendant Wymmundham John   586497 586497 Wymmundham, John, of Barston 0
4654359 2247237 2247237 defendant Gaunt Robert yeoman 586497 586497 Gaunt, Robert, of Barston, yeoman 0
4683187 2260357 2260357 defendant Wryght John   586497 586497 Wryght, John, of Barston, wright 1
4742806 2278403 2278403 defendant Gaunt Robert husbandman 586497 586497 Gaunt, Robert, of Barston, husbandman 2
4754461 2281774 2281774 defendant Duffeld John husbandman 586497 586497 Duffeld, John, of Barston, husbandman 1
4811822 2299809 2299809 defendant Wyther John husbandman 586497 586497 Wyther, John, of Barston, husbandman 1
4830481 2305565 2305565 defendant Bowere William de husbandman 586497 586497 Bowere, William de, of Barston, husbandman 0
4830482 2305565 2305565 defendant Talys John husbandman 586497 586497 Talys, John, of Barston, husbandman 1
4865543 2316185 2316185 defendant Wyther John husbandman 586497 586497 Wyther, John, of Barston, husbandman 2
4946977 2341045 2341045 defendant Graunt William husbandman 586497 586497 Graunt, William, of Barston, husbandman 0
4987453 2353204 2353204 defendant Abirford Thomas shoemaker 586497 586497 Abirford, Thomas, of Barston, shoemaker 0
5001858 2357443 2357443 defendant Pacy Richard, sen husbandman 586497 586497 (Pacy, Richard, sen, of Barston, husbandman 3
5050851 2371872 2371872 defendant Elwys Richard yeoman 586497 586497 Elwys, Richard, of Barston, yeoman 0
5143998 2399391 2399391 defendant Cosyn Thomas butcher 586497 586497 Cosyn, Thomas, of Barston, butcher 0
5201005 2416052 2416052 defendant Neuby William husbandman 586497 586497 Neuby, William, of Barston, husbandman 0
5247883 2429518 2429518 defendant Julyan Thomas miller 586497 586497 Julyan, Thomas, of Barston, miller 3
5313773 2449145 2449145 defendant Sawer Margaret widow 586497 586497 Sawer, Margaret, of Barston, widow 3
5340461 2457218 2457218 defendant Thorp Robert husbandman 586497 586497 Thorp, Robert, of Barston, husbandman 0
5340462 2457218 2457218 defendant Thorp William husbandman 586497 586497 Thorp, William, of Barston, husbandman 1
5345845 2458836 2458836 defendant Alynson Robert   586497 586497 Alynson, Robert, of Barston, husbandma 1
5505535 2506649 2506649 defendant Hud William clerk 586497 586497 Hud, William, of Barston, clerk 0
5505536 2506649 2506649 defendant Bampton Robert chaplain 586497 586497 Bampton, Robert, of Barston, chaplain 1
5514195 2509283 2509283 defendant Whitacres William husbandman 586497 586497 Whitacres, William, of Barston, husbandman 1
5520675 2511290 2511290 defendant Cranwell Robert butcher 586497 586497 Cranwell, Robert, of Barston, butcher 0
5520677 2511291 2511291 defendant Pase Robert husbandman 586497 586497 Pase, Robert, of Barston, husbandman 0
5520679 2511292 2511292 defendant Pase Robert husbandman 586497 586497 Pase, Robert, of Barston, husbandman 0
5520680 2511292 2511292 defendant Cranwell Robert butcher 586497 586497 Cranwell, Robert, of Barston, butcher 1
5543079 2517954 2517954 defendant Pace Robert yeoman 586497 586497 Pace, Robert, of Barston, yeoman 1
5575692 2527485 2527485 defendant Whiteacres William yeoman 586497 586497 Whiteacres, William, of Barston, yeoman 0
5608207 2537465 2537465 defendant Long Thomas husbandman 586497 586497 Long, Thomas, of Barston, husbandman 15
5608208 2537465 2537465 defendant Powell John husbandman 586497 586497 Powell, John, of Barston, husbandman 16
5608209 2537465 2537465 defendant Powll Thomas husbandman 586497 586497 Powll, Thomas, of Barston, husbandman 17
5608210 2537465 2537465 defendant Wryght Thomas husbandman 586497 586497 Wryght, Thomas, of Barston, husbandman 18
5608211 2537465 2537465 defendant Wytakers William husbandman 586497 586497 Wytakers, William, of Barston, husbandman 19

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